Jump to content

Tommy Allitt

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Tommy Allitt's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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
×
×
  • 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.