function selecct_pid($table,$pid){
$condition = ",".$pid.",";
$select_sql = "SELECTE * from {$table} WHERE pid like '%{$condition}%''";
$result = mysql_query($select_sql) or die("查询".$table."出错".mysql_error());
$num = mysql_num_rows($result);
return $num;
}
请问哪里错了!!!郁闷死了........具体报错如下:查询tc_friendlytips出错You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECTE * from tc_friendlytips WHERE pid like '%,3,%''' at line 1
$condition = ",".$pid.",";
$select_sql = "SELECTE * from {$table} WHERE pid like '%{$condition}%''";
$result = mysql_query($select_sql) or die("查询".$table."出错".mysql_error());
$num = mysql_num_rows($result);
return $num;
}
请问哪里错了!!!郁闷死了........具体报错如下:查询tc_friendlytips出错You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECTE * from tc_friendlytips WHERE pid like '%,3,%''' at line 1
function selecct_pid($table,$pid){
$condition = ",".$pid.",";
$select_sql = "SELECTE * from {$table} WHERE pid like '%{$condition}%'";
$result = mysql_query($select_sql) or die("查询".$table."出错".mysql_error());
$num = mysql_num_rows($result);
return $num;
}
输出sql为SELECTE * from tc_friendlytips WHERE pid like '%,23,%''
把sqlecho出来,放在mysql终端执行下 看看出什么问题