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 get the same 'Couldnt execute query :' message. As you can see the only
difference is the addition of the alias 'd' for descriptions and I dont
actually use it in the where clause; it's simple existance causes it to
fail.
Now I am using a shareware version which, perhaps, is buggy:
3.22.24-shareware-debug
Johannes Janson wrote:
> Hi,
>
> > The following statement will not work:
> >
> > $sql = "select * from sometable t1, sometable t2 where t1.field1 =
> > t2.field2";
>
> do you get an error? It should work.
>
> Johannes
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]