Error to do with mysql result

[SirChick]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\homeloginvariables.php on line 22

 

 

Im getting this error but im unsure why...

 

 

its relating to this part of the code:

 

$result = mysql_query($sql);

 

$row = mysql_fetch_assoc($result);

$UserId = $row["UserID"];

 

 

 

its meant to put the field from the table row into the the variable... :/

[lemmin]

There is an error in your query. Change this:

$result = mysql_query($sql);

 

to:

$result = mysql_query($sql) or die(mysql_error());

 

This will print the error that mysql is returning.

 

If you show the value of your $sql string, we might be able to help you debug it.

[SirChick]

Ok i got this result:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM userregistration WHERE userstatus = 1' at line 2

 

 

even though line 2 is the connect to DB code

[MadTechie]

do you have the table userregistration  and with the field userstatus ?

[SirChick]

WHERE  userstatus = 1

 

 

i guess it means online/offline? But weren't sure what it meant so i kept it there but ill remove it