Creating Dynamic Queries using URL Parameters

Kevcamp

Friends,

I have a page that I would like to have display results from simple queries. I know how to hard code the query into a page, but what if the variables are being passed from a URL? See this page for details:

http://shadow.econ.duke.edu/working_papers.php

Each of the links at the top should pass variables that create the queries dynamically. But how? Do I pass the variables to another page? Please help!

TheDefender

Given the following URL:
http://shadow.econ.duke.edu/working_papers.php?order=title&dir=ASC

They call the variables out of the GET array and use them in their query.... So their query is something like:

$query = "SELECT * FROM thetable ORDER BY ".$_GET['order']." ".$_GET['dir']";

// So echoing $query would echo something like:
// SELECT * FROM thetable ORDER BY title ASC

There are many ways to do this, but these are the basics...