下面使用 wpdb->prepare 回傳空結果，而下面不使用 wpdb->prepare 的代碼回傳正確的結果。怎么了？
global $wpdb;
$query = $wpdb->prepare("select subid, firstname, lastname from wpks_members where member_id = %d,".$mid);
$row= $wpdb->get_row($query);
$query = $wpdb->prepare("select t.subid, t.testid, t.test_date, t.puzzle_score,t.clock_score,t.match_score,t.oddone_score,(t.puzzle_score t.clock_score t.match_score t.oddone_score) as tot,
if((t.puzzle_score t.clock_score t.match_score t.oddone_score) < 90, 'Yes', 'No') as refer, u.ufname, u.ulname
from wpks_results t
join wpks_hasi_users u on t.userid = u.userid
where t.member_id = %d,".$mid);
$rows = $wpdb->get_results($query);
//this below works
$row= $wpdb->get_row("select subid, firstname, lastname from wpks_members where member_id = ".$mid);
$query = $wpdb->prepare();
$rows = $wpdb->get_results("select t.subid, t.testid, t.test_date, t.puzzle_score,t.clock_score,t.match_score,t.oddone_score,(t.puzzle_score t.clock_score t.match_score t.oddone_score) as tot,
if((t.puzzle_score t.clock_score t.match_score t.oddone_score) < 90, 'Yes', 'No') as refer, u.ufname, u.ulname
from wpks_results t
join wpks_hasi_users u on t.userid = u.userid
where t.member_id = ".$mid);
uj5u.com熱心網友回復：
它應該是：
$query = $wpdb->prepare("select subid, firstname, lastname from wpks_members where member_id = %d", $mid);
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/375141.html
標籤：WordPress的
上一篇：無法讀取null的屬性
下一篇：按元框值自定義帖子型別查詢