Check if mySQL query retrieved any data

[Anon]

Simple question. I try to get some date from my database using:

$sql= "SELECT* FROM blabla WHERE etc";
$output = mysql_query($sql);
$row = mysql_fetch_array($output);

Now is the question. How can I check if anything came back? I want to be able to give a proper: 'no data found', when there's nothing to display...

Any tips?

[slava]

i think you can use construction as follow:

if (gettype($output)=="resource")
{
// output not empty
...
}
else
{
// output empty
....
}

[Anon]

Hmm no luck,

I get an error if I implement that code. I have checked the output variable. When there's ouput is says: Resource id #6, if there's no output it says: Resource id #7...

[[deleted]]

uhmm.... ok?

but how about this:

$sql= "SELECT* FROM blabla WHERE etc";
if (!$output = mysql_query($sql))
{
 echo 'query failed';
}
else
{
 if (mysql_num_rows($output)==0)
 {
  echo 'no results';
 }
 else
 {
  //list results
  $row = mysql_fetch_array($output);
 }
}

[Anon]

That did the job. Not sure what went wrong with gettype($output) though. Oh well, thanks Slava, Vincent.

[metuin]

<?php

$results = mysql("dB","SELECT * FROM table");

$check = mysql_num_rows($results);

if ($check == '0') {

00ps

echo "Sorry no data in table";

} else {

do stuff

$row = mysql_fetch_array($results);

echo "$row[table_row]";

}

?>

This is a very simple script to start with, didn't test it but it should work 🙂

[[deleted]]

Read the other replies before you post your own.