|
|
Posted by ZeldorBlat on 10/13/05 17:39
select * is fairly dangerous -- only because you don't know what you
are (or aren't getting). If you explicitly list out your columns you
can alias them and get to them that way:
SELECT v.venue_id,
v.name venue_name,
v.address1,
...
v.url,
s.name status_name
FROM venues v, status s
WHERE s.status_id = v.fk_status_id
Here I called venue.name venue_name and status.name status_name. So in
your row, you can do $row['venue_name'] and $row['status_name'].
Navigation:
[Reply to this message]
|