posted 7 years ago
create dest.jsp
i have this tables on mysql :
and i need from the user to fill the form on the "create dest.jsp " and the data from (country,city,url) to match in Dest table and the checkoboxes results to match in Dest_has_categories on idCategories (in order the values = 1,2,3 to match as foreign key on categories table to winter , christmas,summer)
my create-dest-code .jsp (have some faults on checkboxes for sure):
for example user giving this data to form : Spain,Madrid, "a url" and check max 2 checkboxes that user thinks that madrid belongs , i need now to take the "Spain,madrid,Url" at dest table (i can do it) and take the results of checkboxes on table categories_has_categories on (id category) in order to match with table category as foreign key , so how can i insert the checkboxes results and do these connections with tables?
PS: sorry for my bad syntax...