Jump to content

Archived

This topic is now archived and is closed to further replies.

Tommy Allitt

Text Fields

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

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.