Displaying value different from actual value
| From: | Dave Rosenberg | Date: | Wed, 11 Sep 2002 13:57:10 +0000 |
| Subject: | Displaying value different from actual value | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-115978@lists.php.net to get a copy of this message | ||
I'm not sure this is possible, but here's what I'd like to do:
I know that in order for a set of records from MySQL to display in numerical order on a web page, you need to make the column type "Integer," but here's my situation:
I'm creating a database of contracts that my organization has. Normally, there is a dollar amount on these contracts, and I'd like to be able to sort by that value (therefore the Integer column type). However, we have some fee-based contracts, and I'd like a way to display the amount as "Fee Based" even though I can't enter this in the database because of the column type. Is there a way in PHP to have it display this although with some kind of if/then statement or something of that sort?
Contract A Fee-based
Contract B 70000 Contract C 1250 Contract D 50000