Tommy Allitt Posted October 11, 2006 Share Posted October 11, 2006 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 advanceTom Link to comment https://forums.phpfreaks.com/topic/23672-text-fields/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.