Thread: Check if result set is empty

hi everyone

starting to get into PHP, and I have trouble checking if a result set is empty.

I am doing it like this:

Code:

$result = mysql_query($query);

if (mysql_fetch_array($result, MYSQL_ASSOC) == False) print "no records found";


	while($row = mysql_fetch_array($result, MYSQL_ASSOC))  //carry on looping through while there are records
	{

but this way, if there is a record, it will fetch it into the array, and my
while loop will skip the first record.

this is my first day with php, so be gentle

you can try:

Code:

If (!$result) {
...code...
}
Else {
...code...
}

Or

here's an example of some of my code:

Code:

//get results of content query
	Public Function ResultsContent($GetAll) {
		//open conn to db
		$this->OpenDB();
			
			//get results
			$result = mysql_query($GetAll);
			$num_rows = mysql_num_rows($result);
			If($num_rows == 0) {
				$this->arrImage[] = array
				(
					'Data'=>array
					(
						'ID'=>0,
					)
				);
			}
			Else {
				while ($row = mysql_fetch_object($result)) {
					$this->arrContent[] = array
					(
						'Data'=>array
						(
							'ID'=>$row->idkey,
							'Content'=>$row->content,
							'Tags'=>$row->tags,
							'Timekey'=>$row->timekey,
							'Title'=>$row->title,
							'Type'=>$row->type,
							'Date'=>$row->date
						)
					);
				}
			}
		//close conn to db
		$this->CloseDB();
	}

where i just set ID=0 you can put: echo "nothing"

hope that helps some
Shem

thanks guys, the num_rows works 100%

Originally Posted by noFriends

thanks guys, the num_rows works 100%

Did you try (!$result)?
I think that should work too

Shem

the !result function is used to determine if your sql itself is flawed AFAIK.

tried it earlier, didn't work

That's right. There's a difference between a query that returns zero rows (which does NOT return a False result, just an empty result set) and a False result (which happens when there's a connection error or a syntax error). The PHP function mysql_num_rows($result) is what you want. It will return 0 or some positive integer.

Originally Posted by jmurrayhead

Hey NF,

I'm not well experienced with PHP, either, but I believe you could do something like this:

Code:

$returned_rows = mysql_num_rows ($Query);

Then, do this:

Code:

if ($returned_rows == 0){
    echo 'No records found';
}else{
    echo 'There were ' . $returned_rows . 'records found.';
}

Became a member just to tell you that this was a great solution that I absolutely love.

What a great guy! Thanks man!

Originally Posted by jmurrayhead

Hey NF,

I'm not well experienced with PHP, either, but I believe you could do something like this:

Code:

$returned_rows = mysql_num_rows ($Query);

Then, do this:

Code:

if ($returned_rows == 0){
    echo 'No records found';
}else{
    echo 'There were ' . $returned_rows . 'records found.';
}

Brilliant! Have been searching the entire morning for this answer.

THANKS!