sql query not accepting a php variable

Question

I feel a little guilty about posting this because I posted a similar but different question before, but I couldn't figure out what the problem with this one is.

I am simply trying to run a SQL query with a PHP variable taking place of an integer value, but it doesn't seem to work; when I replace the variable with a simple number (like 1) it actually works, so there's nothing wrong with the query itself.

When I put in the variable $email_id at the end, it does not work.

Can anyone point out what the problem might be?

Code:

$row = Db_DbHelper::query('select subject from system_email_templates where id = '.$email_id);

you should just look at the error message if a query 'doesn't work'. — Michael
– Michael, Commented Apr 23, 2014 at 12:50

Pupil · Accepted Answer · 2014-04-23 12:49:53Z

1

You need to add single quotes around your PHP variable, so the updated code:

 $row = Db_DbHelper::query("select subject from system_email_templates where id = '".$email_id."'");

answered Apr 23, 2014 at 12:49

Pupil

24k6 gold badges49 silver badges71 bronze badges

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

1 Comment

user3408005 Over a year ago

Thanks for the answer, but it still doesn't seem to work. I tried placing double quotes around single quotes (which is an opposite of what you've done) and it also doesn't work.

Wit Wikky · Accepted Answer · 2014-04-23 12:52:24Z

0

Try this,

    $sql = "select subject from system_email_templates where id = '".$email_id."' ";
    $row = Db_DbHelper::query($sql);

answered Apr 23, 2014 at 12:52

Wit Wikky

1,5421 gold badge15 silver badges30 bronze badges

2 Comments

user3408005 Over a year ago

no, which is the strange thing. I checked the error log and it's clear

Wit Wikky Over a year ago

Well echo query and run it to your mysql tool,check query is ok.

Collectives™ on Stack Overflow

sql query not accepting a php variable

2 Answers 2

1 Comment

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Related