Link to home
Start Free TrialLog in
Avatar of Bruce Gust
Bruce GustFlag for United States of America

asked on

What am I missing with this query?

This code works:

$querystate = "select download_playlist.id, download_playlist.contestant_id, download_playlist.playlist_name, registration.id, registration.first_name, registration.last_name, registration.song_title from download_playlist, registration where
                              download_playlist.contestant_id = registration.id order by registration.song_title";

But when I try to retrieve the download_playlist.id value using:

echo $row['download_playlist.id'], I get nothing.

If I put, echo $row['id'], I'll get the id from the registration table, but I need to get the id from the download_playlist table. How?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial