我觉得MySqli选择不起作用?

我觉得MySqli选择不起作用?

问题描述:

I think I must be going crazy because my MySqli select code isn't working.

Any Ideas why please?

$result = mysqli_query($con,"SELECT *
FROM `table` WHERE `auto` = 1 LIMIT 0 , 30");

while($row = mysqli_fetch_array($result)) {
$updateid = $row['id'];
}

echo $updateid;

I am not getting any error messages but the while statement is not triggering for some reason. A row with auto with value 1 does exist.

我想我必须疯狂,因为我的MySqli选择代码无效。 p> \ n

任何想法为什么请? p>

  $ result = mysqli_query($ con,“SELECT * 
FROM`table` WHERE`auto` = 1 LIMIT 0,30”); 
 
 while($ row  = mysqli_fetch_array($ result)){
 $ updateid = $ row ['id']; 
} 
 
echo $ updateid; 
  code>  pre> 
 
 

我是 没有收到任何错误消息但是while语句由于某种原因没有触发。 确实存在具有值为1的auto的行。 p> div>

I have also encountered the same problem earlier, try using mysql instead of mysqli. mysqli may not be working because of the version of XAMPP that you are using(older version does not support its use).