simple but baffling

[nclemale36]

a simple sql query below has me baffled .dont take much i know.

its for spincards game in chatroom. its not selecting the correct winner.

i have narrowed it down to this statement.

$rpgd = mysql_query("SELECT id, cards FROM dave_users ORDER by cards DESC LIMIT 1");
 while($rpgds=mysql_fetch_array($rpgd))

appreciate any help ta

[crazybrumi]

what u want it to select? and what is it selectinf istead.

for the id is gona be rpgds[0] and for cards its gna be rpgds[1]

[nclemale36]

the person with highest number of cards .or the biggest number to make it simpler.

its selecting the one with the least i think as someone had 273 or sumat and the person who had 5 won. . ???

[crazybrumi]

change this

$rpgd = mysql_query("SELECT id, cards FROM dave_users ORDER by cards DESC LIMIT 1");

to this

$rpgd = mysql_query("SELECT id, cards FROM dave_users ORDER by cards ASC LIMIT 1");

[nclemale36]

ok will try that thanks

[crazybrumi]

what your code was doing was finding it but ordering the output in a decending order hence the desc beign there which means itl output the lowest value first and the greater value last, what i had done was changed this to asc which is asending which outputs the greater value first and then the least last.

[nclemale36]

i had looked at some other statements wasnt sure which on e to use. every script that has got this in is wrong then lol .

[crazybrumi]

yes and no, you can filter the values out it all depends, but i asume from your reply all is in working order.

[nclemale36]

dunno yet . am still testing it . gonna have to speed things up tho .

[nclemale36]

na not work . user with no cards won lol

[crazybrumi]

lol your like granny u are lol

[crazybrumi]

what page is this on ur site al look at it in the mornign when i ent so pisssed off

[nclemale36]

just go to chatrooms and enter spin for plusses room.

ave put it back to wot it was .

[syrus]

$rpgd = mysql_query("SELECT id, MAX(cards) FROM dave_users GROUP BY id LIMIT 1");
 while($rpgds=mysql_fetch_array($rpgd)){ echo $rpgds['MAX(card)'] }

[nclemale36]

ok found the problem wasnt anything to do with the coding. done some research about sql and the database was wrong

this is wot i used which i got off 2 other scripts

 `cards` varchar(10) NOT NULL,

now it should of been

 `cards` int(10) NOT NULL,

apparently a text value 7 is higher than 123445 but a numeric value is obvious lower in which case it was selecting the wrong winner all the time .

u learn something new everyday lol