[code] <?php //$result = mysql_query("SELECT image_name from photo_album WHERE file_name=".$_GET['username'],$db); //$result = "SELECT * FROM zen_orders_total Where orders_id='15' AND class='ot_shipping' //UNION //SELECT * FROM zen_orders_total Where orders_id='1' AND class='ot_total'"; $result = "select orders_id, (select value from zen_orders_total where orders_id=15 and class='ot_total') as total, (select value from zen_orders_total where orders_id=15 and class='ot_shipping') as shipping from zen_orders_total where orders_id"; //$result11 = mysql_query($result) or die (mysql_error()); $row = mysql_fetch_array($result) ?> <?php $shipping_total=$result['shipping']; $transfer_total=$result['total']; if ($shipping_total>0) { echo "<a target='_blank' href='https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=carrellcustom@sbcglobal.net&item_name=Online_Order&item_number=&amount=$transfer_total&no_shipping=2&no_note=1¤cy_code=USD&bn=PP-BuyNowBF&charset=UTF-8'>Please click here to Pay.</a>"; echo $shipping_total; echo $transfer_total; }else{ echo 'Your shipment total has not been updated.'; echo $shipping_total; echo $transfer_total; } ?>[/code]