|
|
The_FedEx_Guy wrote:
When I leave the whole selection as "Any" I get this: Warning:
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/home/unitedpr/public_html/2.php on line 178
Use echo to display the SQL query. It's possible that I have made a
mistake in the code, resulting in a failed query.
Also I was wondering how do I format the displayed price as "?200,000.00" and
or if I can enter it as a currency value in the database?
As I said before, all numbers must be stored in a database with no
punctuation other than the decimal point. Use the PHP function
number_format() to format the figure.
echo '£' . number_format($Cost, 2);
http://uk.php.net/manual/en/function.number-format.php
--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
|
|