Originally Posted by whizard
I would change how the DB was designed. You may not have this luxury, but I would set up another table which simply had two fields: movieIDs and your "name" field from above.
Then you could just
SELECT name FROM linkTable WHERE movieID = :id
That's exactly how it is set-up...
The result I posted is generated by the query. I have a films table:
and a cast table:
The query pulls them together into one result set. And I've always been told I shouldn't be running two individual select queries.