[insert_php]
if(!function_exists(getConn) )
{ include_once(ABSPATH . ‘wp-content/custom-php/AJAX-UtilityFunctions.php’); }
$connection = getConn();
$result = hgQuery( “SELECT jobs.Name, jobs.JobNumber, jobs.rateTable, rateTables.tableName FROM jobs LEFT JOIN rateTables on jobs.rateTable=rateTables.tableId”, $connection );
if( $result !== false )
{
$list_one = “”;
$list_two = “”;
while( $row = mysqli_fetch_row( $result ) )
{
$list_one .= ““;
$list_two .= ““;
}
echo ““;
}
else { echo ““; }
[/insert_php]
Notes
QTY | Job | Item | Unit Price | Transfer Rate | Net | GST | Purchase Order | Invoice |
---|---|---|---|---|---|---|---|---|
To Contractor | From Client | |||||||