Dear all, i have a question for a project that i must do form my high school.
I try to expalin the problem that i have.
I have 3 DB:
first db [name_db]
2 table (id and names)
id name
1 mike
2 tod
second db name is the first name of the first row of the first DB
second db [mike_db]
2 table (id and cars)
id cars
1 BMW
2 AUDI
third db name is the second name of the second row of the first DB [name_db]
third db [tod_db]
2 table (id and colors)
id colors
1 Red
2 Green
i have also 4 db BMW_db, AUDI_db, Red_db, Greem_db
So i have the index that through a PHP file must reed vale in the second table of the name_db and create a buttons for each names in the column.
After that if the webuser click on the MIKE button i must generate other button with the name of the cars in the table CARS in the mike_db
So i have now 2 button in the html page. After the user click on the BMW button and in the BMW_db i store (with a insert SQL command) the data and the time when the user click the button.
so the BMW_db with 3 column:
id data time
can you help me to understand how to genereta the button from a select sql and reuse the button to generate other button?
thanks lot best regards
Marco