DaveMate

Thanks guys, It was like a penny dropping... I think I understand now.... This is what I ended up with just for the record: mysql_query ("INSERT INTO logins (UserID, URL, Time) VALUES ('1', '2',' 3')"); Onwards and upwards... Dave.

Hi Ober, Erm Busted, yeah that was all my code (it's an include in the pages I wanted to have secure / loged) So I need to call the query even with an insert? Is that the same as with a select of different? Thanks Dave..

Hi all, I'm trying to autherise users, and then log activity, so I thought that this type of thing would work, but it's just not any ideas? <? require( "common.php" );  // where the vars for database login are stored $auth = false;  if (isset ($_SERVER['PHP_AUTH_USER'] ) && isset( $_SERVER['PHP_AUTH_PW']  )) { mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM usernamepassword WHERE User = '".$_SERVER['PHP_AUTH_USER']."'AND Pass = '".$_SERVER['PHP_AUTH_PW']."'"; $result=mysql_query($query); $num=mysql_numrows($result); if ( $num != 0 ) { $auth = true;     } } if ( ! $auth ) {     header( 'WWW-Authenticate: Basic realm="Private"' );     header( 'HTTP/1.0 401 Unauthorized' );     echo 'Authorization Required.';     exit; } else { $query = "INSERT INTO log_user_activity ('UserID', 'URL', 'Time') VALUES ('1', '2',' 3')"; } mysql_close(); ?> I was just trying to get the values 1, 2, and 3 into the database, and then work from there to get the userID the page and the time using system vars at a later date... Is there somethig obvious that I've missed, or can anyone think of a better / more simple way.. Thanks in advance... Dave