PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Error: 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 'Resource id #5' at line 1 with query Resource id #5
But no idea what its trying to explain to me to fix... its the same query as used in the "elseif" part of my if statement which works 100% yet the exact same when copy n pasted doesnt lol!
How ever i have a second query in this "if" region which i guess could be it... can any one tell me what i have done wrong? Heres the 2 only possible queries that it could be:
$CheckUserID = mysql_query("SELECT * FROM userregistrationWHERE UserID='$UserID'");
$GetUserID = mysql_query($CheckUserID) or die("Error: ". mysql_error(). " with query ". $CheckUserID);
If (!($row = mysql_fetch_assoc($CheckUserID)))
{
die('This Username does not exist!');
}
$CheckUserID = mysql_query("SELECT * FROM userregistrationWHERE UserID='$UserID'") or die(mysql_error());
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
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 '='47'' at line 1
"47" is the input value that i put in myself to check
EDIT never mind its working .. i missed out a space to seperate the WHERE