Question

php 怎样给 sql 语句变量赋值！

$str=where task_is_on = '个人已完' and task_flag = '普通' and task_do_name = '王舒婷';
$TRecord = mysql_query("select * from task_biao $str order by task_id desc ");

为什么语句就不能执行呢 ? 求指点！！！

Answer 1

第一种：数组
$allbrand = array();
while ($testingrow = mysqli_fetch_array ($testingquery)) {
    $allbrand[] = $testingrow[2];
}
第二种：字符串
$allbrand = '';
while ($testingrow = mysqli_fetch_array ($testingquery)) {
    $allbrand .= $testingrow[2]."";
}
请采纳，谢谢

Answer 2

第一行少了引号，应该改为：
$str="where ....'王舒婷'";

Answer 3

$str= "where task_is_on = '个人已完' and task_flag = '普通' and task_do_name = '王舒婷' ";