I am not sure if this is the right place to ask for help with my final project or if I should use a more general programming forum, but hopefully you guys can help me out.
How do you modify the HTML of a web page using information stored in a SQL table once the user selects a specific row (presumably with Java Script DOM)?
In my case I am building a site about college football teams. I already have a SQL table that has all the teams listed along with details such as team colors (hex codes) and a URL for an image of their logo. I want the user to be able to select any team from a list and then make colors and logo on the page change based on their selection. I have already created a drop down menu with all the team names by using Flask application.py to query the SQL table and Jinja to set the template. Once the users has selected a specific teams how do I go about accessing the corresponding information in that specific row of the table and then use that information to modify the HTML on the page?