sql statement
Posted: Tue Jan 20, 2004 1:58 pm
OK check at what i'm trying to do here.
$sql = "SELECT * FROM users WHERE user='$name'";
$result = mysql_query($sql,$con);
$row = mysql_fetch_array($result);
$oldpicname = $row['".$keepmyvar."'];
I want to dynmically pic the field to select from depending on what $keepmyvar says.
However, that does not work. Any suggestions?
$sql = "SELECT * FROM users WHERE user='$name'";
$result = mysql_query($sql,$con);
$row = mysql_fetch_array($result);
$oldpicname = $row['".$keepmyvar."'];
I want to dynmically pic the field to select from depending on what $keepmyvar says.
However, that does not work. Any suggestions?