You have not filled the required fields. Please try again."; include "search.inc"; exit; } $sql = "SELECT * FROM dating WHERE lastname='".$lname."'"; $result = mysql_query($sql) or die(mysql_error()); if(mysql_num_rows($result) < 0) { echo "Sorry, there were no matches for your query. Please try again."; } else { echo ""; while($row = mysql_fetch_array($result)) { echo "
"; } echo "

First name	last name	city
". $row['firstname'] ." ". $row['lastname'] ." ". $row['city'] ."

"; } ?>