Hi I am pretty new to MySQL and database work in general. I was hoping that someone
good answer two easy questions.
1. How would I select the row that has the highest value in one of the fields?
2. How to I update a record?
I am sorry I have to ask questions like this.
If any one is curious I am building a php web page that has a lets users vote on the
best user submitted lyrics that I have in a database. I want to add one to the vote
field when a user votes for a lyric and post the lyric of the week in at the top of an
chronologically ordered list of lyrics.
Thanks alot!
the table structure is as follows..
flowno int, flow char(50), vote int, email char(20)
