Member Avatar for toasty525

I have a mysql table with the following data in it:

user_id score
1234 28
4654 -15
5986 15
3657 10

If i have PHP select the score column for user 5986 how could i then have PHP calculate the next highest score in the MySQL table ?

  • 2 Contributors
  • 1 Reply
  • 141 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Use this query. Replace 15 with the actual score from your user.

select score from table where score > 15 order by score asc limit 1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.