Variable in the SQL query

Question

Variable in the SQL query

Navigation

#1 by (3 votes)

0

Well, I'm trying to query with a variable I'm getting, but it's not working. Any suggestions?

$model = $_REQUEST['model'];
$customer = $_REQUEST['customer'];
SELECT * FROM sistema WHERE concluido <> 1 AND site='$site' AND $model='X'

php mysql sql

asked by anonymous 21.07.2015 / 20:46

1 answer

Problems inserting Emoji in mySQL How to store different ids for EditTexts with the same name?

score 3 · Accepted Answer

Work out as follows:

$model = $_REQUEST['model'];
$customer = $_REQUEST['customer'];

$consulta = "SELECT * FROM sistema WHERE concluido <> 1 AND site = '{$site}' AND {$model} = 'X'";

Do not forget to check if the variables are coming correctly and if the comparison signal is actually <> , you might want to use = '1' .