<?php
$dbname='yourdbname';//
$tablename='yourtablename';//
$linkID = @mysql_connect("localhost", "login", "password");//
mysql_select_db($dbname, $linkID);//
$resultID = mysql_query("Select * FROM $yourtablename", $linkID); //
print "<TABLE BORDER = 1><TR><TH>Login Name</TH>";
print "<TH>Password</TH>";
for ($x=0; $x <= mysql_num_rows($resultID); $x++)
{
$row = mysql_fetch_assoc($resultID);
if (($row[LoginName]==$LoginName)&&($row[Password]==$Password))
{
print "<TR><TD>$row[LoginName]</TD>";
print "<TR><TD>$row[Password]</TD>";
**this is where i want the redirect*
}
else
{
print "<tr><td>Invalid Login Name.</td>";
}
}