MySQL查询使用带引号的$ _GET

Question

I am having trouble finding a syntax that works in this query to receive JSON data:

$info ='".mysql_real_escape_string ($_GET['clientlist'])."';
$result = mysql_query("SELECT clientname FROM `cms_client` WHERE clientname ='$info' ORDER BY clientname ASC");

When I put this in my browser: http://mydomain.com/myfile.php?clientname=Redbox

I get an empty response.

When I change my query to:

//$info ='".mysql_real_escape_string ($_GET['clientlist'])."';
$result = mysql_query("SELECT clientname FROM `cms_client` WHERE clientname ='Redbox' ORDER BY clientname ASC");

When I put this in my browser: http://mydomain.com/myfile.php

The database responds with "Redbox"

Could someone please help me with the correct syntax?

Answer 1

change it to:

$info = mysql_real_escape_string ($_GET['clientlist']);

Else you have double quotation marks in your query.

And the url must be http://mydomain.com/myfile.php?clientlist=Redbox and not ?clientname=