Miscellany

$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>";}