<?PHP if( isset($Customer_ID)==True ) { $_jQi6J='SELECT * FROM '.$CONF['TableNameContractSuperTickets'].' WHERE Customer_ID="'.$Customer_ID.'" ORDER BY ID DESC';$_jQii8=mysql_query($_jQi6J,$conn) or die("Error getting Service Contracts Error: sc4567<br />$_jQi6J <br />".mysql_error($conn));$_jQLCo=0;while( $_jQlfC=mysql_fetch_array($_jQii8) ) { if( $_jQLCo==0 ) { echo('<p> Service Contracts Found in Database: <table style="width: 100%; text-align: left;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top;width:20%">Contract ID </td> <td style="vertical-align: top;">Contract Desc </td> </tr>');;$_jQLCo=1;} echo(' <td style="vertical-align: top;"><a href="workorder.php?Step=EditAddTicket&serv_cont=1&Ticket_ID=SC'.$_jQlfC['ID'].'&SSID='.$SSID.'">SC'.htmlentities($_jQlfC['ID']).'</a> </td> <td style="vertical-align: top;">'.htmlentities($_jQlfC['service_desc']).' </td> </tr> ');} if( $_jQLCo==1) { echo ('</tbody></table></p>');} } ?>