Question

php的mysql问题 获取多行不能mysql_num_rows

代码如下：
$result=@mysql_query("SELECT jm_profile.id,jm_photo.ctime,jm_photo.name FROM jm_profile,jm_photo WHERE jm_profile.hid='".$_POST['hid']."' AND jm_profile.checked=1 AND jm_photo.forid=jm_profile.id",$con);
$totals=mysql_num_rows($result);

提示错误“<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource”

怎么才能正确计算出行数？
mysql_fetch_array之后怎么引用数组里面的值？

Answer 1

你的select语句错了，检查一下看看。