RE: [PHP-DB] Getting values back out of a URL

forget that code just do this $parcel_query = "SELECT * FROM land01_02_03 WHERE (PelNumber LIKE '$_GET[number]%') AND (OnerName1 LIKE '$_GET[owner]%') "; do this for seeing the url values: print_r($_GET); 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