Sol SELECT FROM TWO COLUMNS USING USER DEFINED VARIABLES

kiwi2

$query = 'SELECT FROM tablename WHERE columnname = "value" AND columnname = "anothervalue"';
now instead of a given name what is the correct syntax to use if the value must be a variable eg:
$var1 = $REQUEST['var'];
$var2 = $REQUEST['vars'];
$query = 'SELECT FROM tablename WHERE columnname = "$var1" AND columnname = "$var2"';
tthe first statement no variables works not the second.😕

dougal85

$query = "SELECT * FROM tablename WHERE columnname = '$var1' AND columnname = '$var2'";

you cant put variables in single quotes, only double quotes but you can use single quotes for the DBMS. So i just swapped them over

IE;


$msg = "World!";

echo "Hello $msg";
// OK, outputs "Hello World!"

echo 'Hello $msg';
// Not OK, outputs 'Hello $msg'

The best way to spot errors like this is to output the SQL query to check that it looks OK. Just make sure you don't on a live website 😉

esukf

$query = "SELECT * FROM tablename WHERE columnname = '$var1' AND columnname = '$var2'";

You should use $POST or $GET rather than $_REQUEST unless you intent for the values to come from both a form or querystring.

dougal85

esukf wrote:
You should use $POST or $GET rather than $_REQUEST unless you intent for the values to come from both a form or querystring.

And on that note, you need to make sure your variables are 'clean'

kiwi2

Some times when you write code, usually when you are very tired, you just can't see the simple solutions. Thanks again I don't know what I would do without PHPBUILDER.com.ps my uncle bought himself a computer with a windows vista home operating system on it, since I use my cellphone as my computer I cant help him with the hassels he is having is there a forum he can join.

bradgrafelman

Don't forget to mark this thread resolved.