[Webdev] [PHP] - Quick question

[adam beecher]

> > I was wondering if you could remeber the mysql_num_rows == 0 type thing.
> > What I want to do is test to see if the sql server sends back a result. If
> > it does then go through a while loop other wise print out a pretty message
> > for the user.
>
> If there are 0 rows it won't return anything (or shouldn't) so you might
> want to try something along the lines of if (defined($result) ) { } I
> think. Although maybe with num_rows it does give back a zero thingie.
>

I can't remember off the top of my head, because I resuse this stuff a lot, and
most of my yokes are guaranteed to have data in 'em, but at a guess:

if (mysql_num_rows($resultIndex) > 0) {
	while($row = mysql_fetch_array($resultIndex)) {
		do something with $row;
	}
}
else {
	echo pretty message for the user;
}

If that doesn't work get back to me and I'll go digging.

adam

____________________________________________

Adam Beecher - CEO & Core Geek - ieWebs™

Email ... adam at iewebs.com
Phone ... +353 (0)86 2529887
Fax ... +353 (0)86 8544767
Web ... http://iewebs.com
PGP ... http://pgp.iewebs.com
Mail ... Box 81, Eglinton St, Cork, Ireland
____________________________________________