SELECTS from multiple tables
| From: | Tom Hodder | Date: | Mon, 13 Aug 2001 15:01:44 +0000 |
| Subject: | SELECTS from multiple tables | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11292@lists.php.net to get a copy of this message | ||
Hi,
If I do a select from multiple tables like so
SELECT * FROM,
candidates,
clients,
jobs
WHERE
candidates.ID = clients.candidate_ID
etc etc....
i then do
$row = mysql_fetch_array( $results )
or die(mysql_error() );
is there any way to explicitly reference table columns ie [candidates.ID] in
the result set like you can in ASP. As due to poor table column naming,
there are numerous column name duplications across the tables and it would
take ages to add the
SELECT candidates.ID as canID, client_ID as cliID
to the queries.
Regards
Tom Hodder