Not working o.O?

[3raser]

Here is my code:

 

<?php

//display data
$get = mysql_query("SELECT * FROM items ORDER BY changeprice DESC");
while ($row = mysql_fetch_assoc($get))

{
// get data
$changeprice = $row[changeprice]; 

if ($changeprice > 0) {

} else {
echo '<tr class="row_b"> 
<td> 
<img name="object" src="'. $row[imagelink] .'" alt="'. $row[name] .'"> 
</td> 
<td> 
<a href="http://domination.comyr.com/viewitem.php?id='. $row[itemid] .'">'. $row[name] .'</a> 
</td> 
<td>'. $row[price] .'</td> 
<td class="t5"> 
<span class="rise"> 
'. $row[changeprice] .'
</span> 
</td> 
</tr>';
}
} ?>

 

I'm trying to make it so it only echoes out the price RISES. But when I test it, it still echoes out the ones that are below 0 (-2 is one of them.) Any reasons why?

[Buddski]

If I were you I would only grab the price rises from the database.. I will clean up the code a bit..

$get = mysql_query("SELECT * FROM items WHERE changeprice > 0 ORDER BY changeprice DESC");
while ($row = mysql_fetch_assoc($get)) {
echo '<tr class="row_b"> 
<td> 
<img name="object" src="'. $row[imagelink] .'" alt="'. $row[name] .'"> 
</td> 
<td> 
<a href="http://domination.comyr.com/viewitem.php?id='. $row[itemid] .'">'. $row[name] .'</a> 
</td> 
<td>'. $row[price] .'</td> 
<td class="t5"> 
<span class="rise"> 
'. $row[changeprice] .'
</span> 
</td> 
</tr>';
}

It may also fix your problem.. I fear it is because the values being pulled from the database are strings NOT integers or a number..

[3raser]

Ok, it's partly working now.

 

When I change it to greater than 0, it sends out the ones below zero....and when I change it to smaller....nothing comes out.

[3raser]

Wait, nvm. I think it's solved now..