[Resolved] Get variable & database

[asterisk]

I want to use GET to get the variable and thus sort the data displayed from my database. Something like this:

Select * from table where type="$type" order by id desc

Where $type is the variable I want to get from the URL.

The thing is, I want to set it so that if index.php?x=normal, then type="normal", if index.php?x=strange, then type="strange", and if x is anything other than the specified types, then type would be set to all.

In other words, I want to only get the data that matched with the specific type, and if it's not set, all results from the database will be displayed.

[chyan]

after you pass your variable from your url, you can using if statement
to your query like this

if($_GET['X']=="normal")
{
Select * from table where type="normal" order by id desc
}

if($_GET['X']=="strange")
{
Select * from table where type="strange" order by id desc
}

if($GET['X']!="strange" || $GET['X']!="normal" ) // this if the x is anything other than normal & strange
{
Select * from table order by id desc
}

[asterisk]

Then I could continue with the rest of the page like normal? Like

if($GET['X']!="strange" || $GET['X']!="normal" ) // this if the x is anything other than normal & strange
{
$query = "select * from table order by id desc";
}

$result = mysql_query($query, $connect) or die
// and continue with displaying

[chyan]

Then I could continue with the rest of the page like normal?

yes, the data that you will displayed depend with the variable that your user pass from previous script

[asterisk]

Thanks.