请看下面的图片。我想得到post_id 从…起meta_value = 93. 我该怎么做？
如何从元值获取帖子ID
2 个回复
SO网友:Thilak
试试这个。它会起作用的。
$prepare_guery = $wpdb->prepare( "SELECT post_id FROM $wpdp->posts where meta_key =\'_Wps_crossells\' and meta_value like \'%%d%\'", $meta_value );
$get_values = $wpdb->get_col( $prepare_guery );
SO网友:Munish Thakur
global $wpdb;
$tbl = $wpdb->prefix.\'postmeta\';
$prepare_guery = $wpdb->prepare( "SELECT post_id FROM $tbl where meta_key =\'_Wps_crossells\' and meta_value like \'%%d%\'", $meta_value );
$get_values = $wpdb->get_col( $prepare_guery );
$wpdb->prefix.\'postmeta\';