$query = "Select `product`, `private` as p, 'table1' as n from `table1` where `name` REGEXP '".$trimmed."' UNION ALL Select `product`, `private` as p, 'table2' as n from `table2` where `name` REGEXP '".$trimmed."' ORDER by `product`"; 

while($row = mysql_fetch_array($result))
 
 
 
                                                 {
                                                 echo "<tr>";
 
                                                 //echo "<td>" . $row['Product'] . "</td>";
                                                                // echo "<td>" . $row['Product'] . "</td>";
                                                                // echo "<td>" . $row['private'] . "</td>";
                                                                // echo "<td>" . $row['id'] . "</td>";
                                                                // echo "<td>" . $row['table1.price'] . "</td>";
                                                                // echo "<td>" . $row['table2.price'] . "</td>";
                                                                // echo "</tr>";
 
                                                 echo "<td>" . $row['name'] . "</td>";
                                                 echo "<td>" . $row['n'] . "</td>"; 
                                                 echo "<td>" . $row['p'] . "</td>"; 
                                                 echo "</tr>";
                                                 }

$query = "SELECT table1.product,table1.price,table2.price FROM table1, table2 WHERE table1.product = table2.product";
 
$result = mysql_db_query($database,$query);
while ($row = mysql_fetch_array($result))
{
     echo $row[0]." - $".$row[1].", $".$row[2]."<br>";
}

<form name='search' action='search1.php' method='post'>
<CENTER>
<TABLE>
<TR>
    <TD>Search for Product:</TD>
    <TD><input type="text" name="product" size="25"></TD>
</TR>
</TABLE>
<CENTER>
<input type='submit'  name="submit"  value="Search For Product"'> 
</form> 

<?
// your connection to the server
require("includes/dbconnect.php");
?>
<?
//post sent from search form.
if(isset($_POST['submit'])) 
{
$product = addslashes(@$_POST['product']);
}
// Begin your table outside of the array 
echo "<table width='100%' border='0' cellpadding='4' cellspacing='0'> 
    <tr> 
        <td width='10%' bgcolor='#BBDDFF'><b>ID #</b></td> 
        <td width='20%' bgcolor='#BBDDFF'><b>Product</b></td>
        <td width='30%' bgcolor='#BBDDFF'><b>Tbl #1 Price</b></td>
    <td width='20%' bgcolor='#BBDDFF'><b>Tbl #2 Price</b></td> 
    <td width='20%' bgcolor='#BBDDFF'><b>Private</b></td>
    </tr>"; 
// Define your colors for the alternating rows 
 
$color1 = "#ffffff"; 
$color2 = "#ccffff";  
$row_count = 0; 
// Perform an statndard SQL query: 
$page = $_GET['page'];
$limit = 150;
$query_count = "SELECT * FROM n inner join p on n.product = p.product WHERE n.product LIKE '%$product%' order by n.product asc";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);
if(empty($page)){
$page = 1;
}
$limitvalue = $page * $limit - ($limit);
 
$sql_events = mysql_query("SELECT * FROM n inner join p on n.product = p.product WHERE n.product LIKE '%$product%' order by n.product asc LIMIT $limitvalue, $limit") or die (mysql_error());
// We are going to use the "$row" method for this query. This is just my preference. 
 
while ($row = mysql_fetch_array($sql_events)) { 
$Id = stripslashes($row[0]);
$product = stripslashes($row[1]);
$price = stripslashes($row[2]);
$price1 = stripslashes($row[3]);
$private = stripslashes($row[4]);
 
    /* Now we do this small line which is basically going to tell 
    PHP to alternate the colors between the two colors we defined above. */ 
 
    $row_color = ($row_count % 2) ? $color1 : $color2; 
 
    // Echo your table row and table data that you want to be looped over and over here. 
 
    echo "<tr> 
    <td bgcolor='$row_color'>$Id</td>  
    <td bgcolor='$row_color'>$product</td>
    <td bgcolor='$row_color'>$$price</td>
    <td bgcolor='$row_color'>$$price1</td>
     <td bgcolor='$row_color'>$private</td>
    </tr>"; 
    // Add 1 to the row count 
    $row_count++; 
} 
// Close out your table. 
echo "</TABLE>";
echo "<center><hr color=#c0c0c0>";
if($page != 1)
        {
            $pageprev = $page-1;
            echo("<a href=\"$PHP_SELF?page=$pageprev\">PREV</a>&nbsp;&nbsp;&nbsp;");
        }
        else
            {
                echo("PREV&nbsp;&nbsp;&nbsp;&nbsp;");
            }
 
    $numofpages = $totalrows / $limit;
 
    for($i = 1; $i <= $numofpages; $i++)
    {
        if($i == $page)
            {
            echo($i."&nbsp;");
            }
        else
            {
            echo("<a href=\"$PHP_SELF?page=$i\">$i</a>&nbsp;");
            }
    }
    if(($totalrows % $limit) != 0)
    {
    if($i == $page)
        {
        echo($i."&nbsp;");
        }
    else
        {
        echo("<a href=\"$PHP_SELF?page=$i\">$i</a>&nbsp;");
        }
    }
 
    if(($totalrows - ($limit * $page)) >=0)
    {
    $pagenext = $page+1;
 
    echo("&nbsp;&nbsp;&nbsp;<a href=\"$PHP_SELF?page=$pagenext\">NEXT</a>");
    }
    else
    {
    echo("&nbsp;&nbsp;&nbsp;NEXT&nbsp;");
    }
echo "</center>";
?>