No Results Response

[Shroder]

I'm trying to make this script come out with a "no results" response if nothing is found. I could have sworn it was working two days ago but right now its not. Can anyone see what the problem is?
Your help is appreciated! Thanks!

<? if ($notall == "2") {
mysql_pconnect("host","user","password")
or die("Unable to connect to SQL server");
mysql_select_db("SC") or die("Unable to select database");

$query = "SELECT * FROM TUTORIAL WHERE soundex(NAME)=soundex('$ITEM')";
$data = mysql_query($query) or die("Select Failed! </TD> </TABLE> </BODY> </HTML>");

while ($tutorials = mysql_fetch_array($data))
{
?>
<TR>
<td> ID: <? echo $tutorials['ID']; ?> </td>
<td> NAME: <?echo $tutorials['NAME'];?> </td>
</TR>
<? }

if (mysql_fetch_array($data)==0) {
echo "<TD> no results </TD>";
}
}
else {
echo "<TD> Please search for something! </TD>";
}
?>

[[deleted]]

First , get rid of the mysql_pconnect, only use it if you have a good reason, and I doubt that you do, because nobody really does 🙂

Second; this never worked:

if (mysql_fetch_array($data)==0)

mysql_fetch_array returns TRUE or FALSE, never zero.

On top of that, you should check for the number of records in the resultset, not for the fact that you could or could not fetch a record. You execute the querym, the fetch all rows from the resultset and then you check to see if it is possible to fetch a row. Obviously once you fetched them all, you can never fetch one more, so this will always fail.

[Shroder]

Thanks for the info.
What should I use now to detect if there's nothing there? Using mysql_fetch_array($data) to find out if there's a selected row takes one of the rows when it does it which makes the row not show.

I apologize for my ignorance. I know this is something that should be simple.

Thanks again!

[[deleted]]

"What should I use now to detect if there's nothing there?"

mysql_now_rows() tells you how many rows there are in the resultset. So if there is nothing in it, mysql_num_rows() will return zero.