denoteone Posted March 25, 2009 Share Posted March 25, 2009 $visitor_ip = $_SERVER['REMOTE_ADDR']; $visitor_day = date("d"); $visitor_page = curPageURL(); //function that gets the page they are visiting. mysql_select_db($database_visitors, $visitors); //my table is named visitor_list I would like to do something like the following. $sql = update 'visitor_list' where visitor_ip and visitor_date are = to $visitor_ip and $visitor_date, append visitor_page with $visitor_page; $result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR); Quote Link to comment https://forums.phpfreaks.com/topic/151100-append-data-in-a-db-field/ Share on other sites More sharing options...
denoteone Posted March 25, 2009 Author Share Posted March 25, 2009 let me ask this differently. how do I add the to the contents of a database field named "info" where the field "visitor" and "date" are both equal to $visitor and $date Quote Link to comment https://forums.phpfreaks.com/topic/151100-append-data-in-a-db-field/#findComment-793837 Share on other sites More sharing options...
The Little Guy Posted March 25, 2009 Share Posted March 25, 2009 http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat Quote Link to comment https://forums.phpfreaks.com/topic/151100-append-data-in-a-db-field/#findComment-793906 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.