password protecting web pages problem #3

[rosesau]

Hi,

i think i have nearly worked this out i have just two problems left. these are the problems
Warning: Supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\jpc5\jpcprotected\login.php3 on line 18

Warning: Cannot add header information - headers already sent by (output started at C:\Inetpub\wwwroot\jpc5\jpcprotected\login.php3:6) in C:\Inetpub\wwwroot\jpc5\jpcprotected\login.php3 on line 31

it has something to do with the folloing code

$MyConn=mysql_connect("ROSES","admin","little");
mysql_select_db("tbllogin.db",$MyConn);

$SQL="Select UserName, Password From tblLogin
_,Where UserName=$UserName,Password=$Password";

$RS_query=mysql_query(($SQL),$MyConn);
$RS=mysql_fetch_array($RS_query);

if (!($RS==0))
{

$allow_session=true;

header("Location: http://roses/jpc5/jpcprotected/Default.htm");
exit;
}
else
{

header("Location: http://roses/jpc5/jpcprotected/main.htm");

mysql_close($MyConn);
$RS=null;

$MyConn=null;
exit;
}

my messages are also not short 😛
does anyone have any ideas as to where i have gone wrong this time 😛

one other question does mysql support accessing a paradox database?

thanks

rose

[Anon]

It says that headers where already set because you already echoed back some html, whether it be characters or just blank spaces. Once html starts, the headers stop, and you can not add to them.

[Anon]

$RS_query=mysql_query(($SQL),$MyConn);
WTF... ($SQL) ?
whats about this, mate:

---

$RS_query=mysql_query($SQL,$MyConn);
$RS=mysql_fetch_array($RS_query);

---

huh... try mysql_query($query) or die(mysql_error());
perhaps your mysql-query is not valid, therefore resulting in an error -> no valid mysql-result-set...
OR ($SQL) could be invalid syntax...

p.s. to all the would-be-pros:
php shows the header-error because the error was outputted before the header was...

[ropic]

One of your problems is with...

$SQL="Select UserName, Password From tblLogin
_,Where UserName=$UserName,Password=$Password";

You have to use single quoutes:

$SQL="Select UserName, Password From tblLogin
_,Where UserName='$UserName',Password='$Password'";