[Help] MySQL phpMyAdmin [Help]

[smokzz]

Hi, i need help guys.

How can i make there on my Database when user is registred 'user_id' is AUTO_INCREMENT and i have two tables in on database.

Database name: pelqimetemia
Table 1: users

Table 2: balance

 

and what i want is a new registred user goes to users, i need to automatically send user_id from users to user_id bilance. same user_id in table users same for user_id bilance for that user.

Thanks
 

 

 

 

[Mr_KoKa]

You can user trigger (example: http://www.techonthenet.com/mysql/triggers/after_insert.php ) just after inserting your user you can get last insert id and insert new balance row with new user id, it somehow depends on language you use and driver but, I say kind of because mysql has a function  LAST_INSERT_ID that you can use in a query and it will return last inserted id per client, so even if your driver doesn't wrap it up you can use it directly by.