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

Reply via email to