TalkPHP - View Single Post - whats wrong? - i know i missed some simple thing but well help please :)

codefreek · 06-26-2008, 11:53 PM

now, i got a new problem,
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 '‘ AND password = ‘' at line 1

PHP Code:


			

$q = mysql_query("SELECT * FROM `users` WHERE username = ‘$username’ AND password = ‘$password’") or die (mysql_error()); // mySQL query

i tried to change it to

PHP Code:


			
'".$rest."'

but that didn't work

I FIXED THAT PROBLEM

06-26-2008, 11:53 PM	#19 (permalink)
codefreek Super Moderator Join Date: Sep 2007 Location: Near you. Posts: 791 Thanks: 241	now, i got a new problem, 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 '‘ AND password = ‘' at line 1 PHP Code: $q = mysql_query("SELECT * FROM `users` WHERE username = ‘$username’ AND password = ‘$password’") or die (mysql_error()); // mySQL query i tried to change it to PHP Code: `'".$rest."'` but that didn't work I FIXED THAT PROBLEM __________________ Codefreek's - News Letter, Tech, & some random ramblings Last edited by codefreek : 06-27-2008 at 12:14 AM. Reason: FIXED