assign integers as variables

Question

Generic topic I know. Its hard to be specific in a topic. Anyway I have problem with this sql logic:

"SELECT * FROM imagecomment WHERE filename = :filename ORDER BY comment_timestamp DESC LIMIT '$min', '$max'";

When I try the same logic but with integers directly in the sql logic it works. The variables min and max are integers:

int(10) int(20) I get this when var_dump() them. I also tried to bindValue() the variables (as I usually do) to two parameters but it still didn't work.

do not escape your LIMIT values

silly
– silly

2012-10-18 12:52:52 +00:00
Commented Oct 18, 2012 at 12:52 — silly
– silly, Commented Oct 18, 2012 at 12:52
Don't need single quotes around them

Jason
– Jason

2012-10-18 12:54:01 +00:00
Commented Oct 18, 2012 at 12:54 — Jason
– Jason, Commented Oct 18, 2012 at 12:54

Dustin Moorman · Accepted Answer · 2012-10-18 12:59:38Z

You're using this in a PDOStatement, right? (since you're using :filename)

$db = new PDO(); //assume you have this set

 $stmt = $db->prepare( "SELECT * FROM imagecomment WHERE filename = :filename ORDER BY comment_timestamp DESC LIMIT :min, :max"; $stmt->bindValue(':filename', $filename); $stmt->bindValue(':min', $min); $stmt->bindValue(':max', $max); $stmt->execute();

And you should be able to fetch your results, If that doesn't work, let me know what error you're getting back from the PDOStatement.

I'm not getting any result set when using parameters instead of integers directly in the sql logic "SELECT * FROM imagecomment WHERE filename = :filename ORDER BY comment_timestamp DESC LIMIT :min, :max"; and bind the values to the parameters exactly as you've done. I've also been told before that I should just insert integers directly. Whats your thoughts about this?

solaimuruganv · Accepted Answer · 2012-10-18 12:57:08Z

 "SELECT * FROM imagecomment WHERE filename = :filename ORDER BY comment_timestamp DESC LIMIT $min, $max";

Collectives™ on Stack Overflow

assign integers as variables

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related