MoisesZaragoza Posted September 15, 2005 Share Posted September 15, 2005 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.