Hi all,

I could use some help. I've scoured both the MySQL and PHP sites that I know of and can't find an answer to this.

        I have a price field that sometimes contains entries like this:


How can I pull just the price ($5.32 in this example) from this field to display on a web page? Is there a RIGHT function in PHP? When I search the PHP site, I'm being told there isn't one.

        Here's the code I've been using:

<?php $result = mysql_query("SELECT priceList,unitprice FROM catalog WHERE itemid='WR-1240'",$db); printf('List: $%s<br />', number_format(mysql_result($result, 0,"priceList"),2)); printf('Your Price: $%s', number_format(mysql_result($result, 0,"unitprice"),2)); ?>


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to