搜索多个表并显示为多个表

Question

I want my users to search my database to return data from two different tables which I have done using UNION but I want it to not only search from two tables but to also display as two tables..How can I go about doing this?

  $result .= "<table border='1'>";
    $result .="<tr><td>Cater</td><td>Part</td><td>Gids</td></tr>";
    while ($row = mysql_fetch_array($sql)){
        $result .= '<tr>';
        $result .= '<td>'.$row['Name'].'</td>';
        $result .= '<td>'.$row['Part'].'</td>';
        $result .= '<td>'.$row['Gid'].'</td>';
        $result .= '</tr>';
    }
    $result .= "</table>"; 
    $result .= "<table border='1'>";
    $result .="<tr><td>Cater</td><td>Dish</td><td>Gids</td></tr>";
    while ($row = mysql_fetch_array($sql)){
        $result .= '<tr>';
        $result .= '<td>'.$row['Name'].'</td>';
        $result .= '<td>'.$row['Dish'].'</td>';
        $result .= '<td>'.$row['Gid'].'</td>';
        $result .= '</tr>';
    }
    $result .= "</table>";

Answer 1

Your probably do have two tables but right next to each other. Try putting something visble in between. I put an HR but you can put what makes sense visually for your page. Even a BR ot table header text would work.

$result .= "<table border='1'>";
$result .="<tr><td>Cater</td><td>Part</td><td>Gids</td></tr>";
while ($row = mysql_fetch_array($sql)){
    $result .= '<tr>';
    $result .= '<td>'.$row['Name'].'</td>';
    $result .= '<td>'.$row['Part'].'</td>';
    $result .= '<td>'.$row['Gid'].'</td>';
    $result .= '</tr>';
}
$result .= "</table>"; 

$result .= "<hr />";         <=========

$result .= "<table border='1'>";
$result .="<tr><td>Cater</td><td>Dish</td><td>Gids</td></tr>";
while ($row = mysql_fetch_array($sql)){
    $result .= '<tr>';
    $result .= '<td>'.$row['Name'].'</td>';
    $result .= '<td>'.$row['Dish'].'</td>';
    $result .= '<td>'.$row['Gid'].'</td>';
    $result .= '</tr>';
}
$result .= "</table>";