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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to