Sql query returns empty. But not

Question

my sql query returns empty

$sql = $wpdb->get_results('SELECT * from table1 WHERE id = ' .$bransId);

And im sure that $bransId is not empty. ( i checked)

Did you define global $wpdb? Does the table1 exist? Does the id exist in that table? — Emetrop, Jul 20 '15 at 22:01

shanebp · Accepted Answer · 2015-07-20 22:34:16Z

0

If you can answer 'yes' to the questions in Emetrop's comment, then try:

$sql = $wpdb->get_results('SELECT * from table1 WHERE id = $bransId');

answered Jul 20 '15 at 22:34

shanebp

4,3375 gold badges22 silver badges36 bronze badges

1

I'm afraid this won't work, since the variable isn't inside double quotes. Additionally we shouldn't trust the user input and use $wpdb->prepare(). – birgire Jul 21 '15 at 0:58

Add a comment |

1 Answer 1