If i run command 0 it works fine but i try to run command 1 and it dosn't show anything
<?
$dothis=$_REQUEST['action'];
require_once ('./mysql_connect.php');
if($dothis==0){
$result=mysql_query("SELECT * FROM make, products, type WHERE make.make_id = products.make_id AND type.type_id = products.type_id AND make.make='Acer' AND type.type='PC' ORDER BY product_name ASC") or die(mysql_error());
echo '<table border="1" bordercolor="black" width="100%" cellspacing="3" cellpadding="3" align="center" rules="rows" frame="hsides">
<tr>
<td align="left" width="15%"><b><font color="#000066">Make</font></b></td>
<td align="left" width="20%"><b><font color="#000066">Product Name</font></b></td>
<td align="left" width="20%"><b><font color="#000066">Description</font></b></td>
<td align="right" width="20%"><b><font color="#000066">Price</font></b></td>
</tr>';
while($row=mysql_fetch_array($result, MYSQL_ASSOC)) {
// Display each record.
echo " <tr>
<td align=\"left\">{$row['make']}</td>
<td align=\"left\">{$row['product_name']}</td>
<td align=\"left\"><a href=\"view_product.php?pid={$row['product_id']}\">Click here for details</td>
<td align=\"right\">£{$row['price']}</td>
</tr>";
}
if($dothis==1){
$result=mysql_query("SELECT * FROM make, products, type WHERE make.make_id = products.make_id AND type.type_id = products.type_id AND make.make='Aires' AND type.type='PC' ORDER BY product_name ASC") or die(mysql_error());
echo '<table border="1" bordercolor="black" width="100%" cellspacing="3" cellpadding="3" align="center" rules="rows" frame="hsides">
<tr>
<td align="left" width="15%"><b><font color="#000066">Make</font></b></td>
<td align="left" width="20%"><b><font color="#000066">Product Name</font></b></td>
<td align="left" width="20%"><b><font color="#000066">Description</font></b></td>
<td align="right" width="20%"><b><font color="#000066">Price</font></b></td>
</tr>';
while($row=mysql_fetch_array($result, MYSQL_ASSOC)) {
// Display each record.
echo " <tr>
<td align=\"left\">{$row['make']}</td>
<td align=\"left\">{$row['product_name']}</td>
<td align=\"left\"><a href=\"view_product.php?pid={$row['product_id']}\">Click here for details</td>
<td align=\"right\">£{$row['price']}</td>
</tr>";
}
}
}
?>
