SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN('143,137,137,153,88,3') AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1这样写法对吗怎么把变量
$value=143,137,137,153,88,3';传入到
SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN('$value') AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1
$value=143,137,137,153,88,3';传入到
SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN('$value') AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1
$sql = "SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN({$value}) AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1";
$value = '143,137,137,153,88,3';
$value = str_replace(',', "','", $value);... `id` NOT IN('{$value}') ...
$sql="SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN(".$value.") AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1";#如果想要其中个别字符:
$arr=explode(",",$value);
$sql="SELECT `id`,`linkurl` FROM `users` WHERE `id` NOT IN(".$arr[0].",".$arr[3].") AND `able`='yes' ORDER BY `jifen` DESC LIMIT 1";