SQL not updating all fields

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 not updating all fields

Post by pinehead18 »

Ok, this script will not update the approve field but it updates the mainpic field.

Any ideas?

Thank you
Anthony
ilovetoast
Forum Contributor
Posts: 142
Joined: Thu Jan 15, 2004 7:34 pm

Post by ilovetoast »

The emperor has no clothes.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

WHo, what,where,when,why?

wheres the script?
pinehead18
Forum Contributor
Posts: 329
Joined: Thu Jul 31, 2003 9:20 pm

Post by pinehead18 »

$sql = "UPDATE users SET ".$keepmyvar."='$newname', approve='no' WHERE user='".$name."'";

-- Sorry apparently i was retarted last night
Post Reply