help for dynamic button generation from php mysql

[mitico81]

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