mysql_query return value ??

[Anon]

in mysql_query(select * from member),
if the table is empty,
what is the return value ??

[Anon]

It'll return zero. If you're not sure if your result will return anything, always check it by counting the number of rows returned or using an if statement.

$result = mysql_query("select * from member");
if ($num = mysql_num_rows($link_id))
{
//results returned...
}
else
{
//no results returned...
}

or...

$result = mysql_query("select * from member");
if ($row = mysql_fetch_array($result))
{
//results returned and already assigned to $row..
//to loop through the results, do something like this..
do
{
echo $row["name"];
} while ($row = mysql_fetch_array($result));
}
else
{
//no results returned...
}

Hope that helps..

---John Holmes...