Question

Warning:mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

$link=mysql_connect("localhost","regret");
$sql="select uid from user by id";
mysql_select_db("regret",$link);
$query=mysql_query($sql)
$result=mysql_fetch_row($query);

Answer 1

MySQL_fetch_row():这个错误表示你的sql语句是错误的：select uid from user where id = "001"；而你的 by id 不是正确的语法 你要是想按id排序查询的话应该是 select uid from user order by id desc; desc:降序查询 Asc ：升序查询

Answer 2

是数据库的问题，可能是没有user表，可能没有uid字段。

Answer 3

mysql_fetch_row是从结果集中取得一行作为关联数组，或数字数组，或二者都有。所以你的问题可能是$sql变量出问题了，检查一下sql语句。

Answer 4

$sql="select uid from user by id";语法错误
改：$sql="select uid from user order by id";