Page 1 of 1

sql statement

Posted: Tue Jan 20, 2004 1:58 pm
by pinehead18
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?

Posted: Tue Jan 20, 2004 1:59 pm
by markl999
$oldpicname = $row[$keepmyvar];