sql statement

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
pinehead18
Forum Contributor
Posts: 329
Joined: Thu Jul 31, 2003 9:20 pm

sql statement

Post 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?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

$oldpicname = $row[$keepmyvar];
Post Reply