quick question. I am pulling multiple records from different tables in sql query, like this:
select cinema.id, film.id from movies, film, where film.id = '1';
in translating this into PHP, what do I use to reference these fields? both are called 'ID' would I use the 'TABLE.FIELD' method, or just field?
ie: filmid = $row["film.id"];
.. or what? im not getting my code to work quite right, so any insight is great.
thx
blue