rendered paste body$MysqlQuery1 = mysql_query("SELECT t.`IDER`, t.`IDIR`, t.`IDET`, t.`Order`, IF(t.`EventSD` = -99999999, 'Missing Infomation', DATE_FORMAT(DATE(t.`EventSD`), '%d %b %Y')) AS `EventSD`, t.`IDLREvent`, IF(t.`Desc` = \"\",'Infomation Missing', t.`Desc`) AS `Desc`, t.`IDAR`, t.`Description`, t.`SentenceOverride`, Event.`EventType`FROM tbler tLEFT JOIN tblet Event ON t.`IDET` = Event.`IDET`WHERE IDIR = " . $MysqlResult0['IDIR'] . ";");while($MysqlResults1 = mysql_fetch_assoc($MysqlQuery1)){ // print "<pre>";print_r($MysqlResults);print "</pre>"; print "<tr> <td>" . $MysqlResults1["EventType"] . "</td> <td>" . $MysqlResults1["EventSD"] . "</td> <td>" . $MysqlResults1["Desc"] . "</td></tr>";}