please help, simple noob question :)

[jbrill]

hey,

 

Im trying to display a list of categories for my site.

 

I would like it to display like so:

current category

other category

other category

other category

other category

 

here is my code, i just dont know how to write "display all categories except curcat"

 

<?php
$catid = $_GET['cat']; // gets the category id form the url

echo $catid; //display current category

// display all other categories except curcat
$othercat  = "SELECT * FROM categories";
$result4 = mysql_query($othercat);

while($row4 = mysql_fetch_array($result4))
{
	echo $row4['category'];
}

?>

[wildteen88]

Use a Where clause in your query:

$cur_cat = mysql_real_escape_string($catid);
$othercat  = "SELECT * FROM categories WHERE category != '$cur_cat'";

[jbrill]

i tried the following code, and it still isnt working, any other ideas?

 

// display all other categories except curcat
$cur_cat = mysql_real_escape_string($catid);
$othercat  = "SELECT * FROM categories WHERE category != '$cur_cat'";
$result4 = mysql_query($othercat);

while($row4 = mysql_fetch_array($result4))
{
	echo "<div class=\"categorylist\"><a  class=\"catlist\" href=\"products.php?cat=" . $row4['id'] . "\">" . $row4['category'] . "</a></div>";
}

[wildteen88]

What does the following bit of code display:

$catid = $_GET['cat']; // gets the category id form the url

echo $catid; //display current category

Prehaps the query is supposed to be:

$othercat  = "SELECT * FROM categories WHERE id != '$cur_cat'";

[ccrevcypsys]

i dunno if this is right but i have an idea (try it if im wrong sorry)

 

$othercat  = "SELECT * FROM categories WHERE id != "$cur_cat"";

 

it looks the same but instead of ' i used " i found that that works good for me..