php, and mysql

Anon

Hi all a quick question with what is most likely a simple stupid answer that I am overlooking.

here is my code:

$sql = "SELECT tableid FROM table where row2 = value";
if($result = mysql_query($sql)
{
play with the resultset
}
else
{
do something else
}

now the question if there is nothing within row that matches value will the if statment pass or fail?

Thanks for the help to this issue

Shaun

[deleted]

The if statement will only fail if the query fails to execute. As long as you have a valid query, the if statement will always pass regardless of the amount of rows returned. If you want to do something if the rows returned equals zero, look into mysql_num_rows()....

Matt Wade
codewalkers.com

Anon

if($result = mysql_query($sql)

This is wrong, and MIGHT be causing errors...it should be

if($result = mysql_query($sql))
{
}
else
{
}

[deleted]

As matt said, mysql_query() only fails if the query was invalid.

$sql = "SELECT tableid FROM table where row2 = value";

if($result = mysql_query($sql) 
{ 
  // Give a warning about a failed query
} 
else
{ 
  if (!mysql_num_rows($result) == 0)
  {
    // Give a 'zero results' warning
  }
  else
  {
    // Play with results from query
  }
} 

A forum, a FAQ, what else do you need?