mysqli query not working when variable inserted

Posted by Freelancer on Stack Overflow See other posts from Stack Overflow or by Freelancer
Published on 2011-01-16T09:48:52Z Indexed on 2011/01/16 9:53 UTC
Read the original article Hit count: 232

Filed under:
|

Hi Everyone,

I need an extra pair of eyes! I have a super-simple query:

$result = $mysqli->query("SELECT post_id FROM blog_posts WHERE post_uri = 'the-test-post' LIMIT 1");
$row = $result->fetch_array();

and this gives me the post_id. However, if I insert a variable for post_uri, the result is empty. Ways I tried of which none worked:

$result = $mysqli->query("SELECT post_id FROM blog_posts WHERE post_uri = '".$post_uri."' LIMIT 1");


$result = $mysqli->query("SELECT post_id FROM blog_posts WHERE post_uri = ".$post_uri." LIMIT 1");


$result = $mysqli->query("SELECT post_id FROM blog_posts WHERE post_uri = $post_uri LIMIT 1");

I have similar query on another page working just right, so that confuses me even more. Help appreciated.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysqli