Jump to content


Photo

Text Fields


  • Please log in to reply
No replies to this topic

#1 Tommy Allitt

Tommy Allitt
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 October 2006 - 02:39 PM

Hello

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

"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;

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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users