what is wrong with this code
No Hurricane Specified : Go to main page and select the hurricane you wish to see.';
// Make a MySQL Connection
$connect = mysql_connect($dbhost, $dbuser, $dbpasswd) or die(mysql_error());
mysql_select_db($dbuser, $connect) or die(mysql_error());
$result = mysql_query( "SELECT hh.season, hh.ht_id, hh.ht_name, hh.ht_lcname, hr.ht_date, hr.ht_image, hr.ht_stat_mode, hr.ht_stat_cat, hr.ht_stat_pos, hr.ht_stat_news, hr.ht_record, hi.ht_intensity FROM `ht_records` hr LEFT JOIN `ht_info` hi ON hi.ht_id = hr.ht_id and hi.ht_date = hr.ht_date LEFT JOIN `ht_hurricanes` hh ON hi.ht_id = hh.ht_id where hh.season = '2007' ORDER BY hr.ht_date DESC") or die(mysql_error());
if ($row = mysql_fetch_array( $result ))
{ $id = $row['ht_id']; $rnam = $row['ht_name'];
$lcrnam = $row['ht_lcname'];
$date = $row['ht_date'];
$day = date("j", strtotime($date));
$image = $row['ht_image'];
$stat_mode = $row['ht_stat_mode'];
$stat_cat = $row['ht_stat_cat'];
$stat_pos = $row['ht_stat_pos'];
$stat_news = $row['ht_stat_news'];
$record = $row['ht_record'];
$intensity = $row['ht_intensity']; // echo $id; }
else { $err_hurricane_not_exist = 'Hurricane ' . $rnam . ' has not yet made an appearance. There is no tracking data available at this time.';
die ($err_hurricane_not_exist); } ?>
// I really need this to work, and it has worked before; but I do not know why the code worked 6 months ago, whilst it does not work now.
David - Please see my site at hurricane-tracking.co.uk since it appears to be a mysql problem. The code is probably around 18 months old and it worked at that time.