unless you do p.a and p.b stuff, you'll have to do two queries and put them together in php - it's not hard
//assuming you've already connected to mysql and selected a table
//make two select statements
$media_sql = "SELECT * FROM media WHERE album='$id'";
$videos_sql = "SELECT * FROM videos WHERE album='$id'";
//get two results
$media_result = mysql_query($media_sql);
$videos_result = mysql_query($videos_sql);
//make blank array to merge results
$recordset = array();
//fetch an associative array for media result
while($row = mysql_fetch_assoc($media_result)){
//add the record into $recordset
$recordset[] = $row;
}
//repeat for videos
while($row = mysql_fetch_assoc($videos_result)){
$recordset[] = $row;
}
//now you have an array $recordset of arrays
//start the table
echo "<TABLE>\n";
//go through each item in the array
foreach($recordset as $record){
//open a new row
echo "<TR>\n";
//open the $record array into seperate variables
extract($record);
echo "<TD>$field1</TD>\n";
echo "<TD>$field2</TD>\n";
//etc etc
//close the row
echo "</TR>\n";
}
//close the table
echo "</TABLE>\n";
that echos all the records from both media and videos, matching album criteria, into a table
let me know whether that helps.
adam
