bumdeal2 Posted April 11, 2010 Share Posted April 11, 2010 the rest of the error line is as so "to your MySQL server version for the right syntax to use near 'WHERE user= 'b'' at line 1" Hey Guys i seem to be getting an error in the same spot here, but i dont know what im doing wrong ?could u please help $isql1="UPDATE average SET ave=".$score." WHERE user= '".$user."' "; Link to comment https://forums.phpfreaks.com/topic/198193-1064you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds/ Share on other sites More sharing options...
Mchl Posted April 11, 2010 Share Posted April 11, 2010 Most likely $score variable is empty. Try echoing query before running it and see how it looks. Link to comment https://forums.phpfreaks.com/topic/198193-1064you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds/#findComment-1039890 Share on other sites More sharing options...
bumdeal2 Posted April 11, 2010 Author Share Posted April 11, 2010 argghhh!your right, had a feeling my syntax was correct and it might've had something to do with that, Thanks for the help!:-) truely appreciated. Link to comment https://forums.phpfreaks.com/topic/198193-1064you-have-an-error-in-your-sql-syntax-check-the-manual-that-corresponds/#findComment-1039897 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.