Hi.
This will probably sound simple to all of you but I am hitting my head on
a brick wall so far :-).
I need to generate a list (sorted by descending time) of different objects
referenced in multiple tables. All those objects share a key related to a
project.
This works splendidly from a single table :
$sql="select * from storyboards, where spot_id = \"$spot_id\" order by
date_posted desc";
$result=MySQL_query($sql,$db);
while($row=MySQL_fetch_array($result))
{
$qt_title = $row["title"];
$qt_duration = $row["duration"];
$qt_date_posted = $row["date_posted"]; //(timestamp)
$qt_description = $row["description"];
$qt_id = $row["quicktime_id"];
}
Is there a mysql query that would allow me to stack complete rows in
multiple tables at once (It seems more elegant because I can sort them
while extracting them) or is there a way in PHP to concatenate results in
a single array and then sort them by time... ?
I tried to use a join query, wich produced an invalid query error. (I
think it tries to produce a table with merged data, not just a stack of
rows).
$sql4="select * from quicktimes, other_images, storyboards, where
quicktimes.spot_id, other_images.spot_id, storyboards.spot_id =
\"$spot_id\" order by date_posted desc";
thank you for your help !
nicolas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
