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