Another two questions, small ones though :)

[itandme]

Lets say that i am writing in some form variables into a mysql table. But at the same time, i need the auto_increment ID as the user need to have it.

But as the id is created in the mysql table, how can i get reach of it? I need to mail it to the user in the same code, thats why.

Should i make it complicated and send a new question to the table and asking for the id WHERE name = $name? Thats not very accurate if two users have the same name 😕

And also, how do I use php to redirect the page to another? I i remember right, it is something with header()...?

[volleytotal_ch]

if you have a table with an id (autoincrement), you can use the mysql_insert_id() function to get the last id inserted.

example:

  $res = mysql_query("INSERT INTO users VALUES ('','username')",$conn);
  if($res)
  {
     // user was successfully saved in db:
      $new_id = mysql_insert_id();
     // Send user his new ID: (which is stored in $new_id)
      mail(.....);
  }

hth

[itandme]

thx

[volleytotal_ch]

to improve the script, you can check if the user was really saved or not, just by checking wheter $new_id is empty or not!