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 Quote 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] Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.