Jump to content

Text Fields


Tommy Allitt

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

Link to comment
https://forums.phpfreaks.com/topic/23672-text-fields/
Share on other sites

Archived

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

×
×
  • Create New...

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.