Please explain to me..

Encenta.com · 09-10-2005, 04:13 PM

Hi. Please explain to me why the hell PHP is ignoring 'AND password='$password'' in the following:

PHP Code:

  $query = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");

????: NamePros.com http://www.namepros.com/programming/122602-please-explain-to-me.html
$id=mysql_result($query,0,"id");

When signing into my site, I can log in with ANY password. I have looked at my database and the password is set at ONE password.

Eric · 09-10-2005, 04:50 PM

Hmm, not sure, but try this instead.

PHP Code:

  $query = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'"); 

????: NamePros.com http://www.namepros.com/showthread.php?t=122602
$id = mysql_query($query,0,"id");

Encenta.com · 09-10-2005, 05:10 PM

Didn't work. It must be something to do with the password check

09-10-2005, 04:13 PM	THREAD STARTER #1 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	Please explain to me.. Hi. Please explain to me why the hell PHP is ignoring 'AND password='$password'' in the following: PHP Code: `$query = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'"); ????: NamePros.com http://www.namepros.com/programming/122602-please-explain-to-me.html $id=mysql_result($query,0,"id");` When signing into my site, I can log in with ANY password. I have looked at my database and the password is set at ONE password.

09-10-2005, 04:50 PM	#2 (permalink)
Eric Senior Member Join Date: Mar 2005 Posts: 4,948	Hmm, not sure, but try this instead. PHP Code: `$query = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'"); ????: NamePros.com http://www.namepros.com/showthread.php?t=122602 $id = mysql_query($query,0,"id");`

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Things you can't explain? UFOs? Ghosts?	vip-ip	The Break Room	20	07-24-2005 03:51 AM
can someone explain me ?	saigon	Domain Newbies	3	06-16-2005 05:32 AM
Delete, could you please explain...	ICQer	The Break Room	25	04-13-2005 04:14 PM
Domain Sponsors? Someone explain.	Eric	Domain Newbies	16	04-04-2005 02:14 AM
Top Level,2nd Level,3rd Level? Please explain	Dillpup	Domain Newbies	4	06-06-2004 07:06 PM

09-10-2005, 05:10 PM	THREAD STARTER #3 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	Didn't work. It must be something to do with the password check

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)