Display only if greater than zero

[kndsharp]

Hello, hoping someone can help me get this php "if" statement correct.

I have a table driven by mysql db and I would like to only show the value of my sale price ['Prod_Sale'] when it is greater than "0".

My current statement:

<?php echo $row_Recordset1['Prod_Sale']; ?>

pulls the field value just fine, but the "if" statements I've tried to designate print only if "> 0" have not been successful.

Any help is appreciated.

[Habtom]

<?php $row_Recordset1['Prod_Sale']>0?echo $row_Recordset1['Prod_Sale']:""; ?>

[kndsharp]

Thank you, it's working now.