$query = "SELECT * FROM directory WHERE city_service LIKE \"%$form_city%\" ORDER BY last_name"; $result = mysql_query("$query") or die(mysql_error()); $row = mysql_fetch_array($result, MYSQL_ASSOC);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
...When it is used, for some reason, it is not displaying the first (or last?) record. For example, if the criteria is filled in where the database has only one row with that value, then it does not output anything at all.