[99SIVTEC]

K, so looking at the results, it would seem that its commenting out the if and else statements that display the price.

PHP Code:

<td style="width:17%; font-size:18px;"> <!--?    
                if(empty($record['price_sale']) || $record['price'] <= $record['price_sale'])
                { 
                    //we don't do anything 
                    ?--> <p style="padding-bottom:15px;"><span>$<span>50.17</span></span></p> <!--?
                }
                //otherwise strike-through Price and list the Price_Sale
                else
                { 
                    ?--> <p style="padding-bottom:3px;"><span style="text-decoration: line-through;">$50.17</span></p> <p style="padding-bottom:15px;"><span><font color="#cc6600">$<span></span></font></span></p> <!--? 
                } 
                ?--> <a rel="nofollow" href="www.satelliteguys.us/product.php?q=Monster Cable HDMI A/C - Type C Mini HDMI - Type A HDMI Cable- 6ft" onclick="javascript:document.location='http://prosperent.com/store/product/401335-2154-0/?k=Monster+Cable+HDMI+A%2FC+-+Type+C+Mini+HDMI+-+Type+A+HDMI+Cable-+6ft&amp;m=Mwave.com&amp;p=b14bc82e7b5257399d818714aed72ce5&amp;referrer=http%3A%2F%2Fwww.satelliteguys.us%2F&amp;location=http%3A%2F%2Fwww.satelliteguys.us%2Fproduct.php%3Fq%3Dhdmi%2Bcable&amp;query=Hdmi+Cable';return false;"><img src="http://community.prosperent.com/img/visit_store_button.gif"></a> </td> 


So its included <!-- --> where the PHP statements should be. Check your code, and see if you can add

PHP Code:

<td style="width:17%; font-size:18px;">
                <?php    
                if(empty($record['price_sale']) || $record['price'] <= $record['price_sale'])
                { 
                    //we don't do anything 
                    ?>
                    <p style="padding-bottom:15px;"><span>$<span><?php echo $record['price']?></span></span></p>
                    <?php
                }
                //otherwise strike-through Price and list the Price_Sale
                else
                { 
                    ?>
                    <p style="padding-bottom:3px;"><span style="text-decoration: line-through;">$<?php echo $record['price']?></span></p>
                    <p style="padding-bottom:15px;"><span><FONT COLOR="#cc6600">$<span><?php echo $record['price_sale']?></span></FONT></span></p>
                    <?php 
                } 
                ?>
                <a href="<?php echo $_SERVER['HTTP_HOST']; ?>/product.php?q=<?php echo $record['keyword']?>" onclick="javascript:document.location='<?php echo $record['affiliate_url']?>';return false;"><img src="http://community.prosperent.com/img/visit_store_button.gif"></a>
            </td>

It may have gotten affected, but if that doesn't work, probably the best thing to do for the moment would be to take out the code inside that

<td></td>

statement and put

<p style="padding-bottom:15px;"><span>$<span><?php echo $record['price']?></span></span></p>

Let me know if either of those fix the issue. And as for the price sorting, that's a very good idea, I'll start working on that.