help with mysql querry
| From: | Kurth Bemis | Date: | Tue, 01 Aug 2000 19:01:48 +0000 |
| Subject: | help with mysql querry | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-9515@lists.php.net to get a copy of this message | ||
i am working on a home search engine for a company but have run into a stumbling block. i'd like to be able to say "no home returned" when there isn't a home that matches the querry in the table. i added mysql_num_rows() but i can't get it to work correctly. also...another quick question - i have 2 counters that tell the user how many homes were found and how many are on display.. if you look at my source you'll see that the code that displays it at the end of the loop. why is it displayed at the top of the page? i can't for the life of me figure it out.
look at the page. at http://www.jrehomes.com/test/test.php
heres my code- http://www.jrehomes.com/test/test.phps
any and all help would be appreciated.
~kurth
Kurth Bemis - Senior Linux Network/Systems Administrator, USAExpress.net
kurth@usaexpress.net
http://www.usaexpress.net/kurth
ICQ - 6624050
Call Sign - N1TYW
PGP key available - http://www.usaexpress.net/kurth/pgp
Fight Weak Encryption! Donate your wasted CPU cycles to Distributed.net (http://www.distributed.net)