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
[SOLVED]simple sql statement
Moderator: General Moderators
-
pinehead18
- Forum Contributor
- Posts: 329
- Joined: Thu Jul 31, 2003 9:20 pm
well, that's exactly how to do it 
another way is :
another way is :
Code: Select all
$var = 'name';
$var2 = 'Bob';
$sql = "SELECT * FROM DB WHERE ".$var." = '".$var2."'";
Last edited by infolock on Sat Jan 17, 2004 6:53 pm, edited 1 time in total.