linking to a page to display data

[Anon]

I connected to my database and get a list with different categories as a href displayed on my website. Now I like to be able an click that link to go to a new page and list all the products in that categorie. Is that possible?
Is anybody able to give me a hint on how to go about this?
thanx
petra

[plutarck]

Insert into the html link GET variables, such as:

script.php?view=blenders

Then ensure that the data entered is free from malicious coding (you'll probably want to use a regex to strip out any undesirable data, probably using "\W" in your regex), then do something like:

$sql = "select * from table_name where category='$blenders';
$result = mysql_query($sql);

Then you can just work with the results as you please, probably by using mysql_fetch_rows in a while loop.

[Anon]

can you explain that in more depth please?
What is regex?
and what get variables to use? Sorry I am just on the beginning side of PHP.
Ta
petra

[stephanie]

Petra,

this is what i used to generate a navigation based db categories (similar to previous post I answered you)

<?
//display category nav

$query = "select * from category order by category_id";
$result = MYSQL_QUERY($query);
$total_categories = MYSQL_NUMROWS($result);

for ($i=0; $i<$total_categories; $i++){
$category_id= mysql_result($result,$i,"category_id");
$cat_name = mysql_result($result,$i,"cat_name");
echo "<br><a href=\"category_page.php?category_id=$category_id\">$cat_name</a> ";

}

then now you need to create the category page 'category_page.php' where you should have a query like that:

$query = "select * from whatever_table where category_id = '$category_id' limit 0,10";

//this should give you the 10 first result found in that category

Hope that helps.

?>