Re: [PHP-WIN] RE: handling SQL dot notation in PHP

2003-10-10 Thread Frank M. Kromann
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

[PHP-WIN] RE: handling SQL dot notation in PHP

2003-10-10 Thread Herhuth, Ron
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.