lilman Posted November 22, 2006 Share Posted November 22, 2006 If I want to update more than one column would I seperate them by AND or commas or some other way. For instance:SET column_name = new_value AND column_name = new_value Link to comment https://forums.phpfreaks.com/topic/28049-updating-more-than-one-column/ Share on other sites More sharing options...
Philip Posted November 22, 2006 Share Posted November 22, 2006 Taken from: http://www.phpfreaks.com/mysqlref/12.php[code]UPDATE $dbtable SET u-last-login='$s_datetime', u-logins='$u-logins' WHERE u-id='$u_id'[/code][i]Edit: changed underscores to hyphens for viewing purposes[/i] Link to comment https://forums.phpfreaks.com/topic/28049-updating-more-than-one-column/#findComment-128332 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.