Hi Ron,
No database servers I know will return the column name as
.. Only the column name is returned. This has nothing to do
with PHP, but is how the SQL92 standard defines it.
If you want to have nice names you can do something like this:
$query = "SELECT Role.display_Name as my_column_name fr
OOPS!...The error comes when trying to display the result in the
situtation illustrated here:
echo "$row[frole.display_name]";
>From: Herhuth, Ron
>To: [EMAIL PROTECTED]
>Sent: 10/10/2003 1:13 PM
>
>When using SQL in PHP I have run up against a small issue when working
>with larger SQL queries.