PHP / SQL Query and PHP Variables

Question

I have this query below:

$msgg = mysql_query("SELECT *
FROM mytable
WHERE time>$time
AND id='someid'
ORDER BY id ASC
LIMIT $display_num",$myconn);

see this line: AND id='someid' <-- someid ...

OK, the query above returns 2 results as expected...

Now for the problem....

-- I have a variable myVar and it's content is "someid" (without quotes)...same as the string 'someid'

When I do this:

$msgg = mysql_query("SELECT *
FROM mytable
WHERE time>$time
AND id=myVar
ORDER BY id ASC
LIMIT $display_num",$myconn);

See: myVar <-- this variable contans .. someid

The second query returns no results.

Update: When using ... AND id='$myVar' it sees $myVar as empty for some reason.

SteAp · Accepted Answer · 2011-11-24 23:43:06Z

4

Put a $ in front of myVar:

$msgg = mysql_query(
"SELECT *
   FROM mytable
  WHERE time > $time
    AND id   = '$myVar'
  ORDER BY id ASC
  LIMIT $display_num", $myconn
  );

answered Nov 24, 2011 at 23:43

SteAp

12k12 gold badges56 silver badges96 bronze badges

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

Comments

Evan Mulawski · Accepted Answer · 2011-11-24 23:44:04Z

0

You forgot the dollar sign and the single quotations:

AND id='$myVar'

Additionally, you may want to consider using heredoc:

$query = <<<MYSQL
SELECT *
FROM mytable
WHERE time>$time
AND id='$myVar'
ORDER BY id ASC
LIMIT $display_num
MYSQL;

$msgg = mysql_query($query, $myconn);

answered Nov 24, 2011 at 23:44

Evan Mulawski

55.5k16 gold badges122 silver badges147 bronze badges

Collectives™ on Stack Overflow

PHP / SQL Query and PHP Variables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related