I need to know the best way to update a record based on something like the session id being the same, except the other fields are not. Any examples of this would help...
$table = "cm_sessions"; $sql_insert_form = "INSERT INTO $table (session,ipaddy,host,referrer,hck,nrml,hour,date_stamp) VALUES ('$holy_cow','$ipaddy','$host','$domain_b','$hck','-','$hour','$date')"; $result = @mysql_query($sql_insert_form,$dbh) or die(MYSQL_ERROR()); or $sql_insert = "UPDATE $table WHERE session = "$HTTP_SESSION_VARS['session']" or if the session vars are the same it would insert a new row? I hope I am asking the question correctly. Any help, examples would be great! TIA Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php