[RESOLVED] Displaying multiple results in one html table

[obrienkev]

Hi all,

How do I select files from 2 tables with same field names and display the results into the one table?

Below are my queries.

Thanks.

$query = "SELECT id, name, file_date ".
			 	 "FROM mergers";

$result = mysql_query($query) or die(mysql_error());

$query = "SELECT id, name, file_date ".
			 	 "FROM centralised_archive.mergers";

$result = mysql_query($query) or die(mysql_error());

[Andrew_W_Peace]

$query = "SELECT id, name, file_date ".
                  "FROM mergers";
$result1 = mysql_query($query) or die(mysql_error());


$query = "SELECT id, name, file_date ".
                  "FROM centralised_archive.mergers";
$result2 = mysql_query($query) or die(mysql_error()); 

print '<table>
	<tr>
	<td><b>ID</b></td>
	<td><b>Name</b></td>
	<td><b>File Date</b></td>
	</tr>';

while($array = mysql_fetch_array($result1))
{
	print '			<tr>
		<td>$array['id']</td>
		<td>$array['name']</td>
		<td>$array['file_date']</td>
		</tr>';
}

while($array = mysql_fetch_array($result2))
{
	print '			<tr>
		<td>$array['id']</td>
		<td>$array['name']</td>
		<td>$array['file_date']</td>
		</tr>';
}

print '</table>';

Think this'll do it. Let me know!

//EDIT
Woops, I made an error in the code

[obrienkev]

Thanks Andrew. Works a treat! 🙂

[obrienkev]

Any ideas why the download doesnt work correctly Andrew?

Think its to do with headers. The file save window opens with test as the name.

if(!empty($_GET))
{
		// Connect to database
    include('../../db_connect.php');

	// declare variables 
$id = $_GET['id'];
	$id2 = $_GET['id2'];
	$id3 = $_GET['id3'];
	$id4 = $_GET['id4'];

	// check which file selected
	switch(TRUE)
	{
	 		case ('$id'):
				 		$query   = "SELECT name, type, size, content ".
					 	 					 	 "FROM centralised_archive.mergers ".
						 						 "WHERE id = '$id'";
							break;

	 		case ('$id2'):
				 		$query   = "SELECT name, type, size, content ".
					 	 					 	 "FROM centralised_archive.rights ".
						 						 "WHERE id = '$id2'";
							break;	

	 		case ('$id3'):
				 		$query   = "SELECT name, type, size, content ".
					 	 					 	 "FROM centralised_archive.spin_offs ".
						 						 "WHERE id = '$id3'";
							break;

	 		case ('$id4'):
				 		$query   = "SELECT name, type, size, content ".
					 	 					 	 "FROM centralised_archive.splits ".
						 						 "WHERE id = '$id4'";
							break;

			default:
							echo 'None selected';
							break;						 

	}
//echo $query.'<br />';
		$result  = mysql_query($query) or die(mysql_error());
    list($name, $type, $size, $content) = mysql_fetch_array($result);

	// Set Headers
   if(isset($_SERVER['HTTP_USER_AGENT']) && preg_match("/MSIE/", $_SERVER['HTTP_USER_AGENT'])) 
	 {
       // IE Bug in download name workaround
       ini_set( 'zlib.output_compression','Off' );
   }    

   header('Content-type: ' . $type);
	 header('Content-length: '. $size);
   header("Pragma: public");
   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
   header('Content-Disposition: attachment; filename="' . $name . '"');
   print($content);

   exit;

}

[Roger_Ramjet]

Sorry lads but that is the dumbass way to do it. If you want the results from 2 tables in 1 recordset then you use a UNION query. Only need 1 query, get 1 resultset, and use 1 loop.

$sql = "SELECT id, name, file_date FROM mergers
              UNION 
            SELECT id, name, file_date FROM centralised_archive.mergers";

Then just process with 1 While loop