Reading String from Variable for SQL Query

Question

SQL newb here...

$db_result = mysql_query("SELECT first_name FROM gamers WHERE comp_id = 'myid'"); works the way I want.

$compid1 = 'myid';
$db_result = mysql_query("SELECT first_name FROM gamers WHERE comp_id = @compid1");

does not yield the same results.

I have also tried $compid1 and various other things, but without success.

Sorry for the simple question, but the answer is still eluding me. Thanks!

UPDATE: Oh yea...the question. How can I use a prestored variable for my WHERE check?

No it won't work, a MySQL variable (prefixed with @) isn't automagically linked with a PHP variable of the same name — Mark Baker
– Mark Baker, Commented Nov 8, 2014 at 20:22

Barmar · Accepted Answer · 2014-11-08 20:24:20Z

2

You need to use $ before a variable, not @. And you need to put quotes around it since it's a string:

$db_result = mysql_query("SELECT first_name FROM gamers WHERE comp_id = '$compid1'");

However, it would be best if you stopped using the mysql extension. Use PDO or mysqli, and use prepared statements with parameters. E.g. in PDO it would be:

$stmt = $conn->prepare("SELECT first_name FROM gamers WHERE comp_id = :compid");
$stmt->bindParam(':compid', $compid1);
$stmt->execute();

answered Nov 8, 2014 at 20:24

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

2 Comments

Evorlor Over a year ago

thanks! if I run the PDO version, how would i grab $db_result?

Barmar Over a year ago

You use $stmt->fetch() to get the results. It's all in the PDO documentation.

cuSK · Accepted Answer · 2014-11-08 20:24:37Z

1

Enclose the string variable inside a pair of quotes.

$compid1 = 'myid';
$db_result = mysql_query("SELECT first_name FROM gamers WHERE comp_id = '$compid1'");

answered Nov 8, 2014 at 20:24

cuSK

85911 silver badges26 bronze badges

1 Comment

Evorlor Over a year ago

Thanks! I'd give you a green checkmark too if I had an extra, but Barmar beat ya to it.

Collectives™ on Stack Overflow

Reading String from Variable for SQL Query

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related