[PHP-DB] SELECTS from multiple tables

[Tom Hodder]

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






-- 
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]