0

Hi,

I am trying to set up a section on a site where the results that are shown come from a table.

I want to get the number of the 'current_round' then subtract 1 from it and use that value.

I have looked up MySQL dev site, and assume that I should be using the `-` symbol. but my query isn't working, it jsut keeps displaying the 'current_round' and not the row thats 'current_round'-1.
EG. if the current round is 10, then I want to display round 9.

Here is my query:

"SELECT * FROM rounds WHERE `round`<=>`current_round`-1";

Do you know what I am doing wrong?


Thanks for your help.

Cheers,

QWaz

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by urtrivedi
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.