Getting values back out of a URL
| From: | Danialle Wiltsie | Date: | Thu, 23 Jan 2003 13:39:19 +0000 |
| Subject: | Getting values back out of a URL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25070@lists.php.net to get a copy of this message | ||
I am trying to get my values back out of a URL that has been passed from a page with a form. Here's what the URL looks like.
searchresult.php?number=01&owner=smith&Submit=Submit
My mySQL query is working properly if I hard code a value in, but I can seem to extract the values of number and owner. Here is the code I was told to try previously:
<?
while (list($var, $value) = each($HTTP_POST_VARS)) {
${$var} = $value;
}
?>
And here is my mySQL query:
$parcel_query = "SELECT * FROM land01_02_03 WHERE (PelNumber LIKE '${number}%') AND (OnerName1 LIKE '${owner}%') ";
If anyone could help me out, it would be really great.
Thanks,
Danialle
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail