So here is my problem, I am creating categories for my website; however, I don't want all the categories to show up under my left nav bar, just a few select ones. Is there a way I could change this code to pick certain category ids, say 30 , 31, 33, and 35 to only show up? Your help is greatly appreciated!
<?php
// get categories
$sql = mysql_query("select * from categories where id != 1");
$count = mysql_num_rows($sql);
if(
$count > 0){
while(
$row = mysql_fetch_assoc($sql)){
$name = $row['name'];
print
'<a href="c.php/'.$name.'/" style="margin-top: 2px; font-size: 12px; font-family: verdana">'.$name.'</a><br />';
}
}
else{
print
'There are currently 0 categories. Please login to your admin panel to manage categories.';
}
?>
Greg K posted this at 17:08—15th February 2008.
He has: 1,595 posts
Joined: Nov 2003
SELECT * FROM `categories` WHERE `id` IN(30,31,33,35);'And to elaborate more to be easier to change:
<?$goodCats = array(30,31,33,35);
$sql = "SELECT * FROM `categories` WHERE `id` IN(" . implode(',',$goodCats) . ")";
// get categories
$result = mysql_query($sql);
$count = mysql_num_rows($result);
if($count > 0){
while($row = mysql_fetch_assoc($result)){
$name = $row['name'];
print ''.$name.'';
}
} else {
print 'There are currently 0 categories. Please login to your admin panel to manage categories.';
}
?>
'
-Greg
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
greg posted this at 18:06—15th February 2008.
He has: 336 posts
Joined: Nov 2005
Another option is if you have a descriptive column in the DB, such as product_name, you might benefit from using those instead of id numbers.
That way when you are looking at your code it is more clear what you are selecting from the database, rather than remembering what id numbers are for what product or having to view the DB
i.e. SELECT * WHERE product_name = books, dvd's
You can use pretty much anything in the query select to get from the DB. Just make sure you are selecting something that is unique, because it will list everything it finds for the criteria you tell it (unless you know you will be listing dupe results for a specific reason)
It all depends on what information you are wanting to show. You might want to display your 10 cheapest product prices. Or the first ten members who joined your site. The possibilities are (almost) endless.
www.imagehost-4u.com