Tommy Allitt
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Text Fields
in PHP Coding Help
Posted
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