select table1.colOne as one, table2.colOne as two from table1,
table2 where some condition...
Later fetch the values with names one and two.
Sie schrieben am Freitag, 20. Juli 2001, 23:55:45:
> I have two tables and both tables have a field name thats the same. I
> need to display
> both those field names back to the browser using PHP. I have used php to
> display all
> the other fields but I can't display these fields, because of the
> identical name. I know you can us the Select statement with the keyword
> AS to rename the fields to something else, but I can't get the syntax
> right. I hope someone can send me an example, my email is
> [EMAIL PROTECTED]
> --
> #########################################
> Kory Wheatley
> Academic Computing Analyst Sr.
> Phone 282-3874
> #########################################
> Everything must point to him.
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php