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,
It's hard to comprehend how this is a MySQL problem as my SQL commands work
perfectly when entered at the command line. This fact is a pretty strong
pointer to PHP being the culprit. Why empirical test would suggest otherwise?
CC Zona wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED]
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'm not sure but couldn't it really be that this is
due to the MySQL version? PHP is just passing
a string which is then executed by MySQL. I think
I recall having no problems with aliases. I don't quite
remember which version it was but I think it was 3.23.*.
Now I am using a shareware version
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (cameron walker) wrote:
It's hard to comprehend how this is a MySQL problem as my SQL commands work
perfectly when entered at the command line. This fact is a pretty strong
pointer to PHP being the culprit. Why empirical test would suggest
you have to specify what table you are selecting each of the fields from
select dtype, dloc, iprice from descriptions d,
items i where d.iid = i.iid ;
should be
select d.dtype, d.dloc, i.iprice from descriptions d, items i where d.iid
= i.iid ;
At 03:49 PM