检查mysql_query()是否返回任何结果的正确方法是什么? [英] Whats the proper way to check if mysql_query() returned any results?

问题描述

我尝试了最直观的方法

$query = "SELECT * FROM members 
          WHERE username = '$_CLEAN[username]'
          AND password = '$_CLEAN[password]'";
$result = mysql_query($query);

if ($result)
{ ... 

但这不起作用，因为即使返回0行，mysql_query也会返回真值.

but that didn't work because mysql_query returns a true value even if 0 rows are returned.

我基本上只想在返回行的情况下执行这种逻辑.

I basically want to perform the logic in that condition only if a row is returned.

推荐答案

使用 查看全文