yesm

You can access the id of data inserted to a MySQL table, by storing the value of mysql_insert_id() to a session var. Make sure the table has a AUTO_INCREMENT option assigned to it (in my case 'member_id). This way you can pass the value on to the next page. Here is a sample script: <?php // Start a session and connect to MySQL session_start(); db_connect(); // Make query $query = "INSERT INTO members ( username, password ) "; ."VALUES ( '$u', '" . md5( $p . "' )"; // Run query $result = mysql_query( $query ); if ( $result ) { // If the query was succesful // Store the row id in session var $_SESSION['member_id'] = mysql_insert_id(); $rows_aff = mysql_affected_rows(); echo "$rows_aff row affected."; } else { echo "0 rows affected."; } ?> Script to print the value on the next page: <?php // Start the session to access its values session_start(); // Print value echo $_SESSION['member_id']; ?> I hope this solve your problems