SELECT query...question?

[invision]

Hello,

I have seen on some sites the address bar looks like ...

http://www.jim.com/footwear.php?type=footwear&stype=nike 

How does this work? I mean, the two parameters in the query string, how does it work with the SQL SELECT query, does it change?

I basically have a link on my site that I want users to click so that it will only show stuff from the database where type equals footwear and stype is nike...is it easy to do ?

$query2 = "SELECT i.id, i.type, i.stype, t.id, t.type, s.id, s.stype, i.name, i.description, i.price, i.date, i.largeimageone FROM items as i, type as t, stype as s WHERE i.type = t.id AND t.type = $type AND i.stype = s.id AND s.stype = $stype LIMIT 40";

Any ideas ?

[aerodude]

if address

http://www.jim.com/footwear.php?type=footwear&stype=nike

Then to query database:

$type=$_GET['type'];
$stype=$_GET['stype'];
$query="SELECT * FROM table_name WHERE type='$type' AND stype='$stype'"; 

Easy as pie

[The Little Guy]

$type = $_GET['type'];
$stype = $_GET['stype'];

$query2 = "SELECT i.id, i.type, i.stype, t.id, t.type, s.id, s.stype, i.name,
 i.description, i.price, i.date, i.largeimageone FROM items as i, type as t, stype
as s WHERE i.type = t.id AND t.type = $type AND i.stype = s.id AND s.stype = $stype LIMIT 40";