[smithygotlost]

heya guys

ok what im doing is a comp on offering, the more offers u out in the higher you get. i have 1 table with all ursers details called stats and one with all the offers in called offer_comp.

now i list it using this

PHP Code:

<table border="1" cellspacing="5" cellpadding="5">

<?php

$offer_result = mysql_query("select * from `stats` where `admin` = '0' and `suspend` ='0' limit 0,500")or die(mysql_error());

$i = 0;

while($row=mysql_fetch_array($offer_result)){

$i += 1;

$offer_id = $row["id"];

$name = $row["charname"];

$hash = $row["attackhash"];

$offer_grab = mysql_query("select * from `offer_comp` where `userid`='$offer_id'");

$ammount = mysql_num_rows($offer_grab);



if($cheat !=0){

echo "<tr><td>$i.</td>    <td><a href=\"profile.php?id=$offer_id&hash=$hash\">$name</a></td><td> $cheat </td></tr>";

} else {

echo "";

}

}

?>

</table>

but what i need to do is sort it by the ammount of offers variable $ammount

how do i got about this ?

thanks in advanced
Mike

[therocket954]

If I understand correctly, you're wanting to sort by the number of records (rows) retrieved by the query? I'm not sure what organization this would provide you since this has no connection with the fields of the DB's table. Maybe try putting a field in your table labelled "amount" and sort ASC or DESC by that?

[Jcbones]

PHP Code:

<table border="1" cellspacing="5" cellpadding="5">

<?php

$offer_result = mysql_query("select * from `stats` where `admin` = '0' and `suspend` ='0' limit 0,500")or die(mysql_error());

$i = 0;

while($row=mysql_fetch_array($offer_result)){

$i += 1;

$offer_id = $row["id"];

$name = $row["charname"];

$hash = $row["attackhash"];

$offer_grab = mysql_query("select * from `offer_comp` where `userid`='$offer_id'");

$ammount = mysql_num_rows($offer_grab);



if($cheat !=0){

$storage[$ammount] = "<tr><td>$i.</td>    <td><a href=\"profile.php?id=$offer_id&hash=$hash\">$name</a></td><td> $cheat </td></tr>";

} else {

echo "";

}

}

ksort($storage);

$storage = array_reverse($storage, true);

foreach($storage as $value) {

    echo $value;

}

?>

</table>



This may work, is untested so who knows.  The way things have been lately, I wonder about myself.