Selecting second, third highest?

[Rifts]

hey all how would I do this.. I'm guessing I need to go four different SELECT queries

 

I have prices in my DB

 

I need to select the highest price one echo it

select the second highest price echo it

select third highest echo it

then select everything else and echo them

 

I have this so far but i dont know how to get the second, third, ext highest.

$result = mysql_query("SELECT * FROM stuff ORDER BY price DESC LIMIT 1");
while($row = mysql_fetch_array($result))
{
	echo $row['image'] . " " . $row['link'];
	echo "<br />";
}

 

[Zurev]

Right now you are ordering them by highest price first, followed by 2nd, third, fourth, etc.

 

So what you're doing will accomplish your goal just fine, except you're adding LIMIT 1 so it's only selecting 1 row, happening to be the highest, just do limit 10 or so, and it will order them by highest price first.

[Rifts]

No I can't do that this way I need them to have individual vars to I can use them later

[jcbones]

Yes, you can.

 

$result = mysql_query("SELECT * FROM stuff ORDER BY price DESC LIMIT 1");
while($row = mysql_fetch_array($result)) {
echo $row['image'] . " " . $row['link'];
echo "<br />";
$prices[] = $row['price'];
}
rsort($prices,SORT_NUMERIC);

echo 'Highest price: $' . $prices[0] . '<br />';
echo 'Third Highest Price: $' . $prices[2] . '<br />';

[Rifts]

I love you

[Rifts]

nvm worked it out thanks