Re: [PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
Since it works for you then it MUST be a version thing. How odd that it works from the command line. It would have been a pain to do an upgrade just to find out the problem didnt go away. I appreciate your taking the time to test it for me. Thanks again Johannes Janson wrote: > I'm not

Re: [PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
[EMAIL PROTECTED] (cameron walker) wrote: > > > Now I am using a shareware version which, perhaps, is buggy: > > 3.22.24-shareware-debug > > Given that MySQL is currently well into the 3.23.* series, getting an > upgrade would certainly be a good place to sart. As fo

Re: [PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
My specific return is Couldnt execute query : select dtype, dloc, iprice from descriptions d, items i where d.iid = i.iid ; If I reduce this to select dtype, dloc, iprice from descriptions d, items where descriptions.iid = items.iid; I

[PHP-DB] do table alias's work in PHP?

2001-05-16 Thread cameron walker
The following statement will not work: $sql = "select * from sometable t1, sometable t2 where t1.field1 = t2.field2"; Reason being that the PHP doesnt appear to be able to handle the table alias's t1 and t2. Since I have to do a self-join to make my real code work properly I really need for this