Page 1 of 1

[SOLVED]simple sql statement

Posted: Sat Jan 17, 2004 6:40 pm
by pinehead18
Ok basically i need to know how to use a var to specify a field in sql.

example $sql = "SELECT * FROM db WHERE $var='$var'";

Thanks
Anthony

Posted: Sat Jan 17, 2004 6:51 pm
by infolock
well, that's exactly how to do it ;)

another way is :

Code: Select all

$var = 'name';
$var2 = 'Bob';
$sql = "SELECT * FROM DB WHERE ".$var." = '".$var2."'";

Posted: Sat Jan 17, 2004 6:52 pm
by pinehead18
thank you