Not sure how to do this but I have a table which looks like: CREATE TABLE cm_sessions ( session varchar(255) NOT NULL default '', ipaddy varchar(30) NOT NULL default '', host varchar(255) NOT NULL default '', pages longtext NOT NULL, referrer varchar(255) NOT NULL default '', hck varchar(15) NOT NULL default '', nrml varchar(15) NOT NULL default '', hour varchar(15) NOT NULL default '', date_stamp varchar(255) NOT NULL default '', PRIMARY KEY (session), UNIQUE KEY session (session) ) TYPE=MyISAM;
Now everytime a new page is reached I want to update only the 'pages' field, here is the current sql statement that overwrites the contents of the 'pages' field. UPDATE $table SET pages = '".$PHP_SELF."' WHERE session = '$holy_cow' any help on this would be great. Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
