Jump to content
Glasstream

FileMkaer to PHP

Recommended Posts

I am pulling data out of FileMaker 10 server to a web page and displaying numbers in a table, everything works great! until a number goes over 9,999.00 then it just doesn't display at all. Anyone have any idea what is causing this and how to fix it? I assume it would lay in my php code since the number 11,000.00 is showing in the database, just not in my table on the web page.

My code: <?php echo '$'.number_format(round($Number_row->getField('iAverage'),2),2); ?>

Any help would be much appreciated! 

Share this post


Link to post
Share on other sites

I figured it out, it seems Filemaker wants the straight number 10000 instead of entering 10,000.00. It shows the same in the database, but when carried over to the web page it doesn't.

Share this post


Link to post
Share on other sites

Hi Glasstrean,

version 10 lacks a lot of the finer formatting tools through the Inspector (introduced in version 11). Go to the Menu Bar >> Format >> Number and you will see the menu like the attached.

HTH

Lee

Format Num.jpg

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

By using this site, you agree to our Terms of Use.