Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP


MoisesZaragoza

Recommended Posts

I need to combine this 2 query into one

 

 

$query_exelOrder = "SELECT orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value FROM orders";
$exelOrder = mysql_query($query_exelOrder, $MaxInt) or die(mysql_error());
$row_exelOrder = mysql_fetch_assoc($exelOrder);
$totalRows_exelOrder = mysql_num_rows($exelOrder);


$query_Recordset1 = "SELECT orders_products_id, orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity FROM orders_products";
$Recordset1 = mysql_query($query_Recordset1, $MaxInt) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

 

 

Thanks

at the end of the day the code will be good

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...