Forums

Form field data not appearing in the table?

scott_pw 14 Jan, 2009
Hi, I am a novice at this but seemed to have no problem creating my form and connecting it to a table. However, when I test the form the records appear but the data fields do not appear in the table, only the fields cf_id, uid, recordtime,ipaddress and cf_user_id. Any suggestions what I might be doing wrong. (joomla1.5)
Many thanks.
Peter.
GreyHead 14 Jan, 2009
Hi Peter,

No idea - does the table have records for the other items? Do they have value sthat show up when you turn DeBug on?

Bob
scott_pw 14 Jan, 2009
Hi Bob,
Thanks for the prompt reply. This is the Debug output:

* Form passed first SPAM check OK
* Form passed the submissions limit (if enabled) OK
* Form passed the Image verification (if enabled) OK
* Form passed the server side validation (if enabled) OK
* Form passed the plugins step (if enabled) OK
* Debug End
_POST: Array ( [d1_fname] => dfgfdg [d1_lname] => sdfsf [d1_contact_no] => 452125 [d1_email] => [email]me@me.com[/email] [d2_fname] => sdfsdf [d2_lname] => sdfsdf [d2_contact_no] => 23652 [d2_email] => [email]me@me.com[/email] [submit] => Submit [4b6c6883d00008758e86e2d6eeb4073e] => 1 )
GreyHead 14 Jan, 2009
Hi Peter,

All that looks OK.

[sendfb][/sendfb]
Bob
scott_pw 14 Jan, 2009
Hi Bob,
Here is the form in a zip file.
Regards.
Peter.
GreyHead 14 Jan, 2009
Hi Peter,

Well, the bad news is that it works perfectly for me . . . and I don't see anything amiss with any of the code.

Are all the appropriate fields in the database table?

Bob
scott_pw 14 Jan, 2009
Oh dear!
The only fields in my database table are the first 5 up to and including cf_user_id. In other words my fields d1_ etc do not appear in the table.
Regards.
Peter.
GreyHead 14 Jan, 2009
Hi Peter,

Drop the table - on the grounds that there's no useful information in there . . .

Create it again with the Create Table icon but this time make sure that you check the appropriate boxes in the left hand column (or use the 'check all' box at the top) and set column types if you need to.

Bob
scott_pw 14 Jan, 2009
Hi Bob,
Many thanks - great support. It works great now.
Kind regards.
Peter.
This topic is locked and no more replies can be posted.