Re: PHP3

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 | | sbedberg@ucdavis.edu Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- corporations ------ http://www.ips-dc.org/reports/top200text.htm ---+