| Categories |
|
|
|
|
$sql = "select itemid, catname from cbd_cat order by itemid";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
echo "".$row['catname']." ";
}
?>
| |
|
|
|
| |
$sql = "select p.name, p.imgurl, p.catid, c.catname from cbd_prod p, cbd_cat c , cbd_index i where i.prodid = p.itemid and p.catid = c.itemid order by i.itemid";
$result = mysql_query($sql);
$i=0;
while ($row = mysql_fetch_array($result))
{
if ($i==0)
echo "";
echo " | ";
echo "";
echo " ".$row['catname']."";
echo " | ";
$i++;
if ($i==4)
{
echo " ";
?>
|
|
|
$i=0;
}
}
?>
|
|
|