Two Questions

blackcat25

Hi,

I'm doing my university final year project in PHP and MySQL and I've run into a couple of problems. Hopefully somebody will be able to help!

1) I am displaying a number of drop-down boxes that include values from one of my MySQL tables. The values are a person's name and a price. When a selection in one of these is made I want the page to update so that all the prices are added together and displayed on the page. How would I do this?

2) Again calling values from MySQL tables, but this time I'm displaying them in a table with headers: Name and Price. How could I code it so that when a header is clicked the table will be sorted by that value (ie. name alphabetically...)

Thanks in advance!

AstroTeg

#1: JavaScript. Otherwise you have to resort to reloading the page to recalculate the total.

#2: Think about the problem at hand. You need to change the sort order, which can be easily done with your SQL query. You'll probably want to think about a link that a user can click on which re-runs the SQL that displays the page, but this time, figure out which header the user clicked on (by specifying something unique about the header in the URL the user clicked on) as well as the desired sort order (its either ascending or descending so you can toggle this on/off, true/false, 0/1, asc/desc, etc).