My php code only shows only 1 item in the table from my database it should show 2, the mysql statment shows 2 if typed in the prompt
<?php
require_once('./config.inc');
$page_title = 'Digital Eye';
include_once('./header.html');
?>
<div id="pagecel1">
<?
$dothis=intval($_GET['action']);
require_once ('./mysql_connect.php');
if($dothis==0){
$result=mysql_query("SELECT * FROM products WHERE make='Acer' AND type='Pc'") 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="30%"><b><font color="#000066">Description</font></b></td>
<td align="right" width="20%"><b><font color="#000066">Price</font></b></td>
</tr>';
$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>";
}
?>
</div>
<?php
include_once('./footer.html');
?>
My mysql table looks like this
CREATE TABLE products (
product_id INT(4) NOT NULL AUTO_INCREMENT,
product_name VARCHAR(60) NOT NULL,
price DECIMAL(6,2) default NULL,
description TEXT default NULL,
image_name VARCHAR(30) default NULL,
make VARCHAR(60) NOT NULL,
type VARCHAR(60) NOT NULL,
PRIMARY KEY (product_id),
KEY product_name (product_name),
);
