Interview Question in SQL Server Indexing
Interview Question :: PHP: different tables, same column name problem
Here is my SQL statement:
"SELECT albums.title, albums.ID, artists.title, artists.ID FROM albums, artists WHERE albums.artistID = artists.ID "
when i echo this: $row_randAlbQuery['albums.ID'];
i get this error:
Notice: Undefined index: albums.ID in C:\sites\premium18\purposebuilt\webroot\... on line 166
any idea why? is there a way of doing it without using AS everwhere?
Loading ...