Problem with reading data from two tables

[newbie69]

$sql = "select s.id,s.first_name,s.last_name,s.subject,s.fk_id_speaker_cat,cat.catName,cat.id from speakers as s,speaker_cat as cat where s.suspend = '0' and s.fk_id_speaker_cat = '$speakerCatId' and  cat.id = s.fk_id_speaker_cat  order by first_name";

 

 

the problem i'm having is when i try to retrive the information:

 

echo $row['s.id'];

 

nothing prints to screen. I'm suspecting that the problem is in the $row['s.id']. When iuse a  sql statement that querys one table, theres no problem, but when i include 2 tables in the query and specifying a name to each table eg. speakers as s, speaker_cat as cat, thats where i think the problem is.

 

Is there another way of doing this?

 

Thanks alot!

 

[fenway]

The table alias isn't part of the column name that comes back... it's still just "id".  Which will cause a collision with "cat.id" -- so use column aliases (e.g. cat.id AS catID) and you'll be fine.

[newbie69]

thanks alot! this works!