Text Fields

[Tommy Allitt]

Hello

I am currently using the following query in php to access a mysql database:

[code]"SELECT * FROM order_headers AS a INNER JOIN order_details AS b USING(order_id) INNER JOIN customers AS c USING(customer_id) INNER JOIN customer_addresses AS d ON a.customer_id = d.customer_id AND a.delivery_address = d.address_id WHERE a.order_id=".$orderid;[/code]

I convert the results to an array and all works beautifully until I try to use a text field (notes). This doesn't appear. If I remove the * and use a.notes it appears without any problems.

Can anyone help point me in the right direction as to what is going on please?

Thanks in advance

Tom