[RESOLVED] Category Navigation System

[rutin]

I was wondering if any1 can help me in making of this type navigation style

Firs page, list of categories.
If you click on one of the categories, its shown like this:

Category > Art & Antiques

this is what i have.... it doesnt show right.

<?



$sql = "SELECT * FROM gallery_category ORDER BY category_id  DESC";
$rezultati = mysql_query($sql, $db) or die(mysql_error());

while ($polje = mysql_fetch_array($rezultati)) {
$kategorija = $polje['category_name'];

echo "<BR>$kategorija<P>";
}

?>

Thanks

[kakki]

i think this should be sufficent

first_script:
show the categories:

$sql = "SELECT * FROM gallery_category ORDER BY category_id DESC";
$rezultati = mysql_query($sql, $db) or die(mysql_error());

while ($polje = mysql_fetch_array($rezultati)) {
$kategorija = $polje['category_name'];

echo '<a href="http://secondScript?kategoija='.polje[ 'kategorija' ].'">'.$polje['category_name'].'</a>';
}

in the second Script, you can access the category with $REQUEST[ 'kategoija' ]
( something like : "SELECT * FROM ??? WHERE kategorija=$REQUEST[ 'kategoija' ]" )
.... dont forget 2 escape the $_REQUEST-Variable ( so you would not get any "SQL-INJECTIONS" ) ....

[rutin]

 $sql = "SELECT * FROM gallery_category ORDER BY category_id";
$rezultati = mysql_query($sql) or die(mysql_error());

while ($polje = mysql_fetch_array($rezultati)) {
$kategorija = $polje['category_name'];
echo '<p><a href="gal.php?kategorija='.$polje[ 'category_id' ].'">'.$polje['category_name'].'</a>';

 }

Thanks