using a while lopp how can have it say no records found if nothing is returned.
while($data=mysql_fetch_array($result)) {
echo $data
}
Before the while loop you can check to see how many records were returned. If no records were returned, you echo that, if records were returned you enter the while loop.
Check out mysql_num_rows
