PHP - couldn't get my code to display 2 tables side by side

velocity27 · Joined: 19 Feb 2009 Posts: 2

Can any one help please? Sought of new to this...

Am querying & displaying data from two different MYSQL tables. And wanted this to display "side by side". But it always dispalys one after the other Sad

thanks in advance!

<?php
$con = mysql_connect("localhost","TRD","mysql");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_list = mysql_list_dbs($con);

$i = 0;

$db_count = mysql_num_rows($db_list);

echo "<table border='3' float:left; border-collapse:collapse;>
<tr>
<th>TABLE_#</th>
<th>TABLE_NAME</th>
</tr>";

while ($i < $db_count)
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td>".mysql_db_name($db_list, $i)."</td>";
echo "<tr>";

$i++;

}mysql_close($con);

?>

<?php

$con = mysql_connect("localhost","qa1","mysql");

if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("qa1", $con);

$sql_select=mysql_query("Select * from demotab");
echo "<table border='3'; float:right; border-collapse:collapse;>
<tr>
<th>Employee_ID</th>
<th>Employee_NAME</th>
</tr>";

while ($sql_rows = mysql_fetch_array($sql_select))
{
echo "<tr>";
echo "<td>".$sql_rows['ID']."</td>";
echo "<td>".$sql_rows['Name']."</td>";
echo "</tr>";
}
?>

velocity27 · Joined: 19 Feb 2009 Posts: 2

Will try it and update the post