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
printf('List: $%s<br />', number_format(mysql_result($result,
printf('Your Price: $%s', number_format(mysql_result($result,
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php