Jump to content

@global vars


Destramic

Recommended Posts

im having a problem with executing this query if anyone can help me please

 

SET @rank := 0;
SET @points := 0;
SET @drawing := 0;
@rank := IF(@points=points, IF(@points = '0', @rank + 1, @rank), @rank+1), 
     @points := points,
     @drawing := IF(@points=points, IF(@points = '0', @drawing = '0', @drawing = '1'), @drawing = '0'),
     IF(@drawing = '1', @rank + 1, @rank) as rank,
     @drawing := 0;

Link to comment
https://forums.phpfreaks.com/topic/241576-global-vars/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.