Is there any way I can shorten the query or use better way to write the query
The Best way to check the fields are not empty and print it.
Thank you.
<?
// field is not empty
function notEmpty($value)
{
if(!empty($value))
{
echo $value."\n";
}
}
$paypalTran_sql = "SELECT firstName ,lastName ,shipToName ,shipToStreet ,shipToStreet2 ,shipToCity ,shipToState ,shipToCntryCode ,shipToZip
FROM paypal WHERE order_id='". $orderID . "';";
$paypalTran_res = mysql_query($paypalTran_sql);
if(!$paypalTran_res)
{ die(" Could not query the database: <br/>". mysql_error() ); }
$paypalTran_row = mysql_fetch_assoc($paypalTran_res);
echo ucfirst($paypalTran_row['firstName'])." ".($paypalTran_row['lastName']);;echo "\n";
notEmpty($paypalTran_row['shipToName']);
notEmpty($paypalTran_row['shipToStreet']);
notEmpty($paypalTran_row['shipToStreet2']);
notEmpty($paypalTran_row['shipToCity']);
notEmpty($paypalTran_row['shipToState']);
notEmpty($paypalTran_row['shipToCntryCode']);
notEmpty($paypalTran_row['shipToZip']);
?>