Login script that redirects browser

[southo]

I am trying to figure out how to write a login page where the user enters his login/pass combination. Then a database is queried for the username and pass. If a match is found in the database a URL is "pulled" out of the record and the browser will get redirected to that URL. Sounds simple enough but I'm no php coder. I've seen some login scripts that look like they would do most of the job. The part I can't figure out is the redirecting of the browser. Am I over-complicating this or is it easy for you php guys.

Thanks for any help,
southo

Feel free to spam me with offers to do this for me.

[Duey]

welll im not going to spam you but i can give u some hints.

<?
$conn = mysql_connect("host", "user", "pass");
mysql_select_db("dbname");
$query= "select * from users where username = '$posted_user'";
$result = mysql_query($query);
$row=mysql_fetch_object($result);
if($posted_pass == $row->password){
header("Location: securepage.php");
}
else{
echo "you dam hackers always trying to find out passwords gezzz";
}
?>

well it looks like i did tell you the whole thing.

[Mce]

After passing the login just use the header function (it helps if you turn on output buffering (first line of the script being ob_start(); ) )

header("Location:[url]http://url.forredirect.com/blah/foo/[/url]")

Hope this helps,
-Mce