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
