Hello All,

I'm new to FX.php and am working on a registration database system. What I'd like to do is to create a registration php page (which has been successfully created) and then show the serial number created in FileMaker back to php page.

I've tried several methods that looked to solve this problem but no luck.

I'm using FM7 Server Advanced under OS X Server & FX.php.

I'm using FMView process to enter form data, then create the record with FMNew when submitted, and want to create another page showing back the serial number assigned in FileMaker back to the web, so the people who register can note their registration number which is the same as in FileMaker...

Any help would be greatly appreciated...

Thanks.

Hi,

OK. Firstly you do not need to use FMView to enter the form data. If you are using value lists from FM then yes, this would be valuable.

Now, on your action page for the form where you create the record with FMNew you can show any of that information to the visitor.

Following your

$Result = $Query->FMNew();

with

$value = current($queryResult['data']);

now you can echo $value['YourSerialField'][0];

to that page.

HTH

Hi andygaunt!

Thanks for the reply, and wow, it worked!!

I was trying to make this work for about three days, and your solution solved it in like 2 minutes... really thanks.

I'm still new to PHP, so need to brush up more!

Thanks so much!

You are very welcome.

And remember if you want to see FileMaker on the web jsut stop by the FMPug site at http://www.fmpug.com. This site is FileMaker Server 8 powered (courtesy of our pals over at Adatasol) running FX.PHP

You may want to check out the newly updated Business Directory. This has some nice new features on it.