Passing url variable not working for me....help

[Jpizzolato]

<?php
$base="db";  

$connect=mysql_connect('localhost','username','password') or die("Could not connect to database!!!!");
mysql_select_db($base,$connect) or die("Count not find database table!");

if(isset($_POST['zip'])){
	$zip=htmlspecialchars(mysql_real_escape_string($_POST['zip']));
	$res=mysql_fetch_assoc(mysql_query("SELECT url FROM redirect WHERE zip='$zip'"));
	header('Location: '.$res['url']);
	exit;
}

else{ 
	header('Location: http://www.mywebsite.com/not-listed.html');
}
?>

I've got three columns in my database id zip and url. Each time I run the script in search it automatically redirects me to the else location.

[Rabbit]

Please use code tags when posting code or formatted data.

That means your post array doesn't have a key named zip.

[Jpizzolato]

Can you give me an example?

[Jpizzolato]

Ahhh you know what you're absolutely right. I named it zipcode in the array.... Stupid of me thanks

[Rabbit]

No problem, everyone makes these mistakes

[Jpizzolato]

Can you check my other post? I'm still having issues.