Postcode Lookup

[cybernetic]

I have a postcodes tabel in mysql database and a form requiring peoples details. After clicking on a "Find Address " link the street and housenumber or the postcode and house number will be looked up in the database and the form reloaded with the remainder of the form completed. however when I try to relaod using met refresh I keep getting a warning. Can anyone help me with this?

Thanx

 

[vasah20]

what's the error code that you're getting? leo

------------
Leo Mendoza
lmendoza@garbersoft.net

 

[cybernetic]

I am getting a Warning page but was putting the warning in the URL bar.

I was trying to do something like:

function postcodes () {

if ($streetname&&$houseno) {

$conn=mysql_connect("localhost","name","password"
$db=mysql_select_db("agency"
$sql="Select * from postcodes where houseno=$houseno and streetname=$streetname";
$res=mysql_query($sql,$conn);
$postcode=mysql_result($res,0,"postcode"

echo &quot;<meta http-equiv=\&quot;refresh\&quot; content=\&quot;3;
url=&quot;self.php?postcode=$postcode&&streetname=$streetname&&houseno=$houseno&quot;>&quot;;

}

The form should load with the values in the form cells. Any ideas?

 

[vasah20]

have you tried rawurlencoding the values before you put them in the meta tag?

$postcode = rawurlencode($postcode)
etc..

you of course need to rawurldecode them in the ensuing page

$postcode = rawurldecode($HTTP_GET_VARS[&quot;postcode&quot;])

I know that NN will break on malformed URLS.

http://www.php.net/manual/en/function.rawurlencode.php

hth leo

------------
Leo Mendoza
lmendoza@garbersoft.net