DeveloperBarn

noFriends · #1 June 25th, 2008, 07:29 AM

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

Shem · #2 June 25th, 2008, 07:34 AM

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

jmurrayhead · #3 June 25th, 2008, 07:35 AM

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.';
}

noFriends · #4 June 25th, 2008, 07:39 AM

thanks guys, the num_rows works 100%

Shem · #5 June 25th, 2008, 07:42 AM

Quote:

Originally Posted by noFriends

thanks guys, the num_rows works 100%

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

Shem

noFriends · #6 June 25th, 2008, 07:47 AM

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

tried it earlier, didn't work

don94403 · #7 June 27th, 2008, 08:00 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DeveloperBarn

Check if result set is empty

[Database] Check if result set is empty

The Following User Says Thank You to Shem For This Useful Post:
noFriends (June 25th, 2008)

The Following User Says Thank You to jmurrayhead For This Useful Post:
noFriends (June 25th, 2008)