[passing the id of inserted data to next page]

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