mysql query where condition working on int but not on string

Question

the query is

$sql = "update students set status = 'active', student_password='{$password}' where student_id ='".$_GET['id']."'";

it showing the result as

update students set status = 'active', student_password='50d0d53f546b7' where student_id ='112s23dd'

the error comes

Unknown column '112s23dd' in 'where clause'

when i put any int value in the where clause it works fine but not working in the charecter the student_id is primary key varchar(30)
one more strange thing this is working on phpmyadmin when i paste it there but not work when i execute this on webpage

Hai Hai, can you display desc students because that's not normal...Try with "status" — jcho360
– jcho360, Commented Dec 18, 2012 at 20:55
Are you using a database querying library or just mysql_query()? — Alex
– Alex, Commented Dec 18, 2012 at 20:59
I think status it's a reserved work, so try to use "`" around status — jcho360
– jcho360, Commented Dec 18, 2012 at 20:59

Danilo Radenovic · Accepted Answer · 2012-12-18 21:29:23Z

1

I have made a fiddle with the data that you have provided. Your query works just fine. I think the problem might be if you have not updated the database on the website or changed the type of column 'student_id' in the meantime. Please double check your database on the server.

answered Dec 18, 2012 at 21:29

Danilo Radenovic

1,0291 gold badge11 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jcho360 · Accepted Answer · 2012-12-18 21:29:31Z

1

It looks like you have found a Bug:

http://www.sqlfiddle.com/#!2/56e3e/1

provide us the version of your Mysql also if you can try to run the code directly into PHPMyAdmin just to tested it would be better.

edited Dec 18, 2012 at 21:29

answered Dec 18, 2012 at 21:00

jcho360

3,7491 gold badge18 silver badges25 bronze badges

Comments

Ethan Webster · Accepted Answer · 2012-12-18 21:32:12Z

0

Try this:

    mysql_query("update `students` set `status`='active', `student_password`='{$password}' where `student_id`='" . mysql_real_escape_string($_GET['id']) . "'") or die(mysql_error());

By using that, you'll be given a reason for this query not executing.

answered Dec 18, 2012 at 21:32

Ethan Webster

933 gold badges3 silver badges10 bronze badges

Collectives™ on Stack Overflow

mysql query where condition working on int but not on string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related