Thanks Jay. How would that work into something like: printf("<b>Total Budget:</b> $%s<br>\n", mysql_result($result,0,"budget"));
or printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr><tr>\n", $myrow[0], $myrow[0], $myrow[4], $myrow[8], $myrow[9], $myrow[7], $myrow[10]); Thanks, Dave Jay Blanchard wrote: > [snip] > 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 > [/snip] > > Pseudocode > > if($contract_amount == "" || $contract_amount == NULL){ > print("Fee-based"); > } > > HTH! Peace ... > > Jay > > ***************************************************** > * Texas PHP Developers Conf Spring 2003 * > * T Bar M Resort & Conference Center * > * New Braunfels, Texas * > * Contact [EMAIL PROTECTED] * > * * > * Want to present a paper or workshop? Contact now! * > ***************************************************** > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php