Something like:
SELECT name, title, description from videos, actors, links where
actors.ID = links.ID and videos.ID=videoID, and videos.ID = 20; ?
But in just want one row? You could return all the names in one row (I
think) using MySQL (I assume?) string functions... I have a funny
feeling you need a sub select, which mysql doesn’t support...
Ray Hilton
-
[EMAIL PROTECTED]
http://rayh.co.uk
-----Original Message-----
From: Simon Kimber [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 14:57
To: [EMAIL PROTECTED]
Subject: [PHP] Multipe Tables, Single Query Problem
Hi all,
I have three tables in my (mysql) database:
videos - ID, title, description, etc..
links - ID, videoID, actorID
actors - ID, name, dateofbirth, gender, etc...
what i need to do is return a particular video and all it's staring
actors with just one query returning just one row, ie. with all the
actor names in one field... is this possible? or do i have to get the
video data first and then the actors separately?
Simon Kimber
Funny.co.uk - The Comedy Portal
http://www.funny.co.uk/
Now Incorporating: The UK Live Comedy Directory
FREE promotion for UK Comedy Acts and Venues
http://www.funny.co.uk/uklive/
eml. [EMAIL PROTECTED]
icq. 16156911
