...choice? Hello, I'm new to PHP and mySQL, and I'm trying to build a website that uses something similar to conditional formatting in Microsoft Excel. I'M NOT ASKING FOR YOU TO WRITE ME CODE! Please just let me know if this sounds possible and I can research for myself. Here's what I have so far:
1. PHP opens connection to my mySQL database and populates a drop-down list with values
2. User drops down the list, makes a selection, and clicks the Submit button
3. PHP uses $_POST to store the selection and reloads the page with the selection stored as the variable $final
What I need to know is if it's possible to do this next:
4. PHP finds the row that $final is in in the mySQL database. The other columns would either contain a 1 or a 0 for shaded or unshaded, respectively.
5. PHP loads the row from mySQL into an array
6. PHP uses a loop command to build the html table one cell at a time, shading the corresponding cells
Do I have the right idea, or is this something PHP won't be able to handle? Thanks in advance!
1. PHP opens connection to my mySQL database and populates a drop-down list with values
2. User drops down the list, makes a selection, and clicks the Submit button
3. PHP uses $_POST to store the selection and reloads the page with the selection stored as the variable $final
What I need to know is if it's possible to do this next:
4. PHP finds the row that $final is in in the mySQL database. The other columns would either contain a 1 or a 0 for shaded or unshaded, respectively.
5. PHP loads the row from mySQL into an array
6. PHP uses a loop command to build the html table one cell at a time, shading the corresponding cells
Do I have the right idea, or is this something PHP won't be able to handle? Thanks in advance!