挣扎着看为什么这没有返回任何东西-很确定这是我的语法错误(wp_rg_lead_detail表中肯定有行,field_number为2,值为Trys)
function manageGetSearchEntries( $query ) {
global $wpdb;
$fullQuery = "SELECT * FROM wp_rg_lead_detail WHERE (%s, %s) = (%d, %s)";
$result = $wpdb->get_results( $wpdb->prepare( $fullQuery, $query[0], $query[1], $query[2], $query[3] ), ARRAY_A );
return $result;
}
$entryData = manageGetSearchEntries( array( 'field_number', 'value', 2, 'Trys' ) );
这不是有效的SQL。应该更像
WHERE (%s = %d) AND (%s = %s)