note 90952 added to function.mysql-insert-id

Here's an elegant way to INSERT using UPDATE syntax. <?php function insert_update($table,$fields,$id=NULL) { if($id===NULL) { $sql="INSERT INTO $table (id) VALUES(NULL);UPDATE $table SET $fields WHERE id = LAST_INSERT_ID()"; }else{ $sql="UPDATE $table SET $fields WHERE id = $id"; } return $sql; } ?> Usage: <?php $table="members"; $fields="username = 'Ultimater',userlevel = 'member'"; if(!$profile_exists) { //insert a record $sql=insert_update($table,$fields); mysql_query($sql); }else{ //update a record $sql=insert_update($table,$fields,5); mysql_query($sql); } ?> ---- Server IP: 64.71.164.2 Probable Submitter: 76.94.233.193 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-insert-id.php Edit -- https://master.php.net/note/edit/90952 Del: integrated -- https://master.php.net/note/delete/90952/integrated Del: useless -- https://master.php.net/note/delete/90952/useless Del: bad code -- https://master.php.net/note/delete/90952/bad+code Del: spam -- https://master.php.net/note/delete/90952/spam Del: non-english -- https://master.php.net/note/delete/90952/non-english Del: in docs -- https://master.php.net/note/delete/90952/in+docs Del: other reasons-- https://master.php.net/note/delete/90952 Reject -- https://master.php.net/note/reject/90952 Search -- https://master.php.net/manage/user-notes.php