Refering to array variables from mysql

[SJH]

Hey all,

Say I have a query such as the following:

SELECT orders.*, customers.* FROM orders, customers WHERE orders.id = customers.last_order

If I execute this using PHP and then use the mysql_fetch_array() function with the intention of displaying the data, how are the array keys determined?

I have tried:

$row['orders.quantity'];
$row['quantity'];

and none of these seem to display anything. What should I be using?

Thanks in advance

-Sam

[grahowler]

You will be able to acces them by field name but perhaps you should name the fields in your query..

SELECT 
orders.id AS order_id, 
orders.quantity AS order_quantity, 
orders.whatever AS order_whatever,
customers.id AS customer_id, 
customers.name AS customer_name, 
customers.last_order AS customer_last_order
 
FROM
orders, customers 
 
WHERE orders.id = customers.last_order

Then you can access...

$row['order_id];
$row['customer_id];

etc...

Hope that helps

[SJH]

Good point, I hadn't thought of that!

Thanks for the help

-Sam