php mysql search by variable?

Question

Please help me with how can I retrieve data from mysql having a variable in my sql query.. my php code is

$status=$_GET['status'];
$query="SELECT * FROM students WHERE status='$status' ";

When I run the query mysql generates

 unknown column 'Lead'

where Lead is the value of $status. I tried it with \'$status\' , '{$status}' but same error.. Please help me I'm working on it since yesterday but found no solution. I tried mysql_real_escape_string() but same error.. may be I was using it with wrong syntax.

  $query="SELECT * FROM students WHERE status=".mysql_real_escape_string($status);

Thanks in advance....

$query="SELECT * FROM students WHERE `status`='" . mysql_real_escape_string($status) . "'"; — NullUserException
– NullUserException, Commented Oct 8, 2012 at 21:04
Keep in mind: stackoverflow.com/questions/60174/… (I recommend placeholders in general to avoid having to worry about quotes - I'm lazy.) — user166390
– user166390, Commented Oct 8, 2012 at 21:05
Are you sure you don't have "where $status='$status'"? Those pesky symbols like to jump around sometimes. — aynber
– aynber, Commented Oct 8, 2012 at 21:07
@NullUserException that was an answer, you should've typed it as such! — xception
– xception, Commented Oct 8, 2012 at 21:08

Lajos Arpad · Accepted Answer · 2012-10-08 21:36:38Z

1

$status=$_GET['status'];
$query="SELECT * FROM students WHERE status='".$status."'";

and escaping is a good idea, but I think mysql_escape_string is deprecated and its usage is discouraged, you should always use mysql_real_escape_string.

answered Oct 8, 2012 at 21:36

Lajos Arpad

80.4k42 gold badges123 silver badges235 bronze badges

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

Comments

Aubin · Accepted Answer · 2012-10-08 21:12:49Z

0

I'm afraid 'status' is a reserved word for sql: see http://drupal.org/node/141051

Try:

$status = mysql_real_escape_string($status)

$query = "SELECT * FROM `students` WHERE `status` = '$status'";

answered Oct 8, 2012 at 21:12

Aubin

14.9k11 gold badges67 silver badges89 bronze badges

Collectives™ on Stack Overflow

php mysql search by variable?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related