Script Select user and add data
- Thread starter mraresh
- Start date
Marcel Freiberg
Junior Member
- Aug 6, 2017
- 171
- 71
Maybe you can add some further information.
Which Database do you use?
Which script language do you want to use?
What should be the userinterface for the search?
Best luck
Mf
Which Database do you use?
Which script language do you want to use?
What should be the userinterface for the search?
Best luck
Mf
- Sep 10, 2010
- 11,805
- 26,657
OK, so?
Marcel Freiberg
Junior Member
- Aug 6, 2017
- 171
- 71
This is a classic 1-to-many relationship with every person can have many cars but one car is only linked to one person. (Otherwise you would have a n-to-m relationship which would need an other table to join both entities)
Easiest way for the simple scenario is to add a user ID (autoincrement / sequel) to table user and to add it also to the table cars.
Easiest way for the simple scenario is to add a user ID (autoincrement / sequel) to table user and to add it also to the table cars.
Veil123
Elite Member
- Jun 13, 2012
- 1,839
- 3,357
If you use MYSQL Database then the most easiest way for such query is:
(the variables can be different depending in what language you want to use it).
P.S. I had to put an image because BHW is giving me "You have been blocked" message if I enter the code directly.
(the variables can be different depending in what language you want to use it).
P.S. I had to put an image because BHW is giving me "You have been blocked" message if I enter the code directly.