complete and utter noobie help with DB

scotte

I have the querys i want, and i know simple php. But this is far beyond me. And i have no idea how to post information that i have called.

Can somone show me how

A) I can calculate the totals

and

😎 how to echo the results like a table ie.

$query_product $query_model $query_price $query_cost $total_cost $total_price

Also i was wondering does this query allow for multiple results. In other words will the totals work if there is more than one value @oder_id

heres the code.

$customer_number_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['order_id'])) . "'");

$query_product = "SELECT product_name FROM orders_products WHERE order_id='$customer_number_query'";
$query_model = "SELECT product_model FROM orders_products WHERE order_id='$customer_number_query'";
$query_price = "SELECT final_price FROM orders_products WHERE order_id='$customer_number_query'";
$query_prod_id = "SELECT products_id FROM orders_products WHERE order_id='$customer_number_query'"; //this is so i can query the next line
$query_cost = "SELECT products_cost FROM products WHERE products_id='$query_prod_id";


$total_cost = "all of the $query_cost added together";
$total_price = "all of the $query_price added together";

Thanks so much for anyone who can help me, this is really important. Thanks again

Scott

luke9_20

You can get all the information and not need to do so many individual queries...

$customer_number_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '".  tep_db_input(tep_db_prepare_input($HTTP_GET_VARS ['order_id'])) . "'");

$query = "SELECT * FROM orders_products WHERE order_id='$customer_number_query'";
if ($result = mysql_query($query)) {
   while ($row = mysql_fetch_array($result)) {
        $product_name = $row['product_name'];
        $product_model = $row['product_model'];
        $final_price = $row['final_price'];
        $products_id = $row['products_id'];
        $total_price += $final_price;
   }
}

$queryb = "SELECT products_cost FROM products WHERE products_id='$products_id'";
if ($resultb = mysql_query($queryb)) {
   while ($row = mysql_fetch_array($resultb)) {
        $products_cost = $row['products_cost'];
        $total_cost += $products_cost;
   }
}

echo "Total cost: $total_cost";
echo "Total price: $total_price";

scotte

Thats awesome, thanks!!

Just one quick question, how do i get the DB information to echo onto the page??

I know it won't echo like this

echo "$product_name";

Cheers

Scotte

luke9_20

Actually, it will echo like this

echo $product_name;

as long as you do that echo statement INSIDE the loop.

scotte

THANKYOU!!!

You rule, i want to take a course in this language at the end of the year (im finishing school!!)

Got any pointers for learning it, or where to go (like courses??)??

Cheers

Scotte

luke9_20

I learn everything from just stumbling around the net and researching everything I want to do, kinda like you are now. I haven't been doing this for very long. Forums like this are a good source of knowledge though.