Shopping cart: Displaying products on different pages

mancroft · Jul 7, 2003

I am doing a shopping cart and have put the products into a mysql database.

The code below displays all the products on one page.

What I want to do is display product type A (3 items) on one page, product type B (4 items) on another page, product type C (2 items) on another page and so on.

What is the best way to go about this?

Thanks for your help.

CODE BELOW>>>>>>>>

include("db.php&quot

;

// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
$result = mysql_query("select * from items order by itemName asc&quot

;

?>
<html>
<head>
<title> Product List </title>
</head>
<body bgcolor="#ffffff">
<h1>Products</h1>
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="30%" height="25" bgcolor="red">

  Product

</td>
<td width="10%" height="25" bgcolor="red">

Price

</td>
<td width="50%" height="25" bgcolor="red">

Description

</td>
<td width="10%" height="25" bgcolor="red">

Add

</td>
</tr>
<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" height="25">

<?php echo $row["itemName"]; ?>

</td>
<td width="10%" height="25">

$<?php echo $row["itemPrice"]; ?>

</td>
<td width="50%" height="25">

<?php echo $row["itemDesc"]; ?>

</td>
<td width="10%" height="25">

<a href="cart.php?action=add_item&id=<?php echo $row["itemId"]; ?>&qty=1">Add Item</a>

</td>
</tr>
<tr>
<td width="100%" colspan="4">
<hr size="1" color="red" NOSHADE>
</td>
</tr>
<?php
}
?>
<tr>
<td width="100%" colspan="4">

<a href="cart.php">Your Shopping Cart >></a>

</td>
</tr>
</table>
</body>
</html>

spookie · Jul 7, 2003

One way is to pass the variable to the script that decides which product type to display and controlling the query depending on that
eg.
$query = "select * from items where product_type='$product_type' order by itemName asc" ;

where $product_type is type 'A','B',or 'C'

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Shopping cart: Displaying products on different pages

mancroft

Programmer

spookie

Programmer

Similar threads

Part and Inventory Search

Sponsor