The PHP version plays no part in this, since the SELECT statement
below is passed directly to MySQL. And, yes, this should work on that
MySQL version - it's a pretty simple statement.
Were you experiencing a problem with it? If so, post the relevant PHP
code & the error message you're getting.
The only thing that might conceivably be a problem is the table alias
syntax. What you have _should_ work, but you could also try
Select a.field, b.field from table_one AS a, table_two AS b
where a.id = b.id
- steve
At 1:48 PM -1000 6/20/01, William Poarch wrote:
>Hi,
>
>Does "Select a.field, b.field from table_one a, table_two b where a.id =
>b.id" work in PHP3/MySQL 3.22.32?
>
>Client's running PHP3, and I'm on 4.
>
>thanks.
> - - - - - - - - - -
> Scott Poarch
> www.globalhost.com
> - - - - - - - - - -
--
+------ Factoid: Of the 100 largest economies in the world, 51 are ------+
| Steve Edberg University of California, Davis |
| [EMAIL PROTECTED] Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ |
+--- corporations ------ http://www.ips-dc.org/reports/top200text.htm ---+
--
PHP General 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]