Link to home
Start Free TrialLog in
Avatar of shruti A
shruti A

asked on

php code to generating id on click button event

here i need to generate jod_id  which will be same for all the rows which we 'll insert on one click of submit button as same for next job it should be increment by one

I want output like as below

id       job_id        name
1          1                   a
2          1                  b
3          1                  c
4          2                  a
5           2                 b
6           2                 c
7           2                d


for new job new id should be created
so Please let me know the solution for this

Thank you
ASKER CERTIFIED SOLUTION
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shruti A
shruti A

ASKER

thank you i 'll try this
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@Julian Hansen i don't want add description in jobs table ,just id , created_date , in another table description should be added
@Ryan Chong i'm using phpmyadmin
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ya i got to know thanks for your support thank you all
I vote to split as follows or delete.