mjdamato you're the man. Thanks for that. I did need to change from date to id since I don't have a date field set up. I should do that though, so thanks for reminding me about that.
It worked perfectly to display the latest results but when I did a search, it returned this error at the top of the page:
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user ''@'localhost' (using password: NO) in C:\websites\giantstridedives\locations\index.php on line 12
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\websites\giantstridedives\locations\index.php on line 12
I removed the 'mysql_real_escape_strings()' code and it worked. After doing some searching, I found someone who said "Turns out i needed a database link in code before the rest. " I assume that he means the connection to the database. So after taking the advice in your signatures, I checked the php.net on mysql_real_escape_strings() and found an example that had a 'mysql_connect()' before the escape strings. So I added it above that line:
mysql_connect($dbhost, $dbuser, $dbpass);
$searchterm = mysql_real_escape_string(trim($_POST['search']));
Problem solved.
Thanks again for your help!