Location: PHPKode > projects > WorkOrder TS > workorder-ts/include/customer_serv_contracts.php
<?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&amp;serv_cont=1&amp;Ticket_ID=SC'.$_jQlfC['ID'].'&amp;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>');} } ?>
Return current item: WorkOrder TS