Jump to content

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.



Format Num.jpg

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

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