mysql help needed

[rosesau]

Hi,

i am unsure what to put in this line, currectly i have the following line

$RS=mysql_fetch_array($RS_query);

but i get the following error message

supplied argument is not a valid MySQL result resource. so that statement most be total wrong.

i am trying to get a result from a row when the username and password matches in a database. the line before is as follows

$RS_query-MySQL_query(($SQL),$MyConn);

so what should i use is the $RS line that does the same job.
any help that you can give me would be great

thanks
Rose

 

[steijssen]

Okay,

You get the "supplied argument is not a valid MySQL result resource" error because the query didn't get any resultset back.

Try this;

$result = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'"
if($row = mysql_fetch_array($result))
{
print("Welcome!!"
}

Hope that helped a bit