Sounds like you just want some pretty basic variable substitution? As in
the page is submitted with, say, state=T and you need to code your
select statement like eg:
$query = "SELECT * FROM tbl WHERE state = '".$_REQUEST['state']."'";
then execute this query in your DB call.
Does that help?
kc68@xxxxxxxxxxx wrote:
How do I write a link which results in a page with part of the data in
the mysql table and do that multiple times on a single php script
page? That is, I want to be able to click on state names on a single
page and bring up a page with only that state's data. I understand
use of the "where" limitation, but I don't see how to code a line
which will override the base "select" statement for the script. Thanks.
Ken
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php