can I use the value of a URL querystring in the sql where clause to only show records based on a passed querystring parameter?
Yes of course. The most easy way is to use a global variable in the sql: where [myparms]
In the onscriptinit you can use $_GET to get the variable and set [myparms]=$_GET(something from the url);
the final result must be a valid sql statement, obviously.