PHP Query Not Understanding Integer

Question

Here's my code:

    function display_name1($s){
        global $db;
        $query1 = 'SELECT Name From Drink where P_Key = $s';
        $r = $db->prepare($query1);
        $r->execute();
        $result = $r->fetchColumn();
        return $result;

        }

$s contains the result returned from the P_Key, an auto incremented column. I want to be able to give the query the P_Key and it will return whatever variable from that row I want. For some reason, this isn't working. It returns nothing. Now if I return $s, then it does display the numbers like it should, so the problem isn't with the $s variable itself. If I take the $s out of the query, and replace it with a number, then it returns the name of the drink just like it should, so the problem isn't with the database or the query. The problem seems to be that $s is being interpreted incorrectly.

I've tried converting it to an integer ahead of putting it into the query, no dice. Any ideas?

Is there a reason you aren't using parameterized queries?

Daedalus
– Daedalus

2013-03-26 04:14:23 +00:00
Commented Mar 26, 2013 at 4:14 — Daedalus
– Daedalus, Commented Mar 26, 2013 at 4:14

Hanky Panky · Accepted Answer · 2013-03-26 04:09:28Z

3

Try to use double quotes.Single quote didn't interpret the variables."SELECT Name From Drink where P_Key = $s"

Reference: PHP String Parsing

edited Mar 26, 2013 at 4:09

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

answered Mar 26, 2013 at 4:04

Mahmood Rehman

4,3377 gold badges43 silver badges76 bronze badges

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

1 Comment

Marcel Marino Over a year ago

Well done. That did it. I'll select it as the answer as soon as the site lets me.

M.I.T. · Accepted Answer · 2013-03-26 04:12:37Z

0

use like this

"SELECT Name From Drink where P_Key = ".$s.""

you can find difference using echo $query1

answered Mar 26, 2013 at 4:12

M.I.T.

1,0422 gold badges17 silver badges34 bronze badges

Collectives™ on Stack Overflow

PHP Query Not Understanding Integer

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related