-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On September 11, 2002 07:57, Dave Rosenberg wrote: > 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
Hi Dave, You can also do this in your SQL query. For example: If your table contains this: +----------+---------+ | contract | amount | +----------+---------+ | Jillco | 1000000 | | Jackco | 10000 | | ChrisInc | NULL | +----------+---------+ The the following select: SELECT contract, IFNULL(amount, "Fee Based") amount FROM contracts; will return: Jillco 1000000 Jackco 10000 Chrisinc Fee Based Cheers! - -- Zak Greant <[EMAIL PROTECTED]> MySQL Community Advocate Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr "Gosh, Batman! The nobility of the almost-human porpoise." --Robin -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9f6iab6QONwsK8bIRAjoJAJ9rswcUKNzR5z9wD7HaKqJ42raiwgCeOzVs TMSVwY5J18Y3zeEmRut9Wyg= =G1gi -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php