Thread: how to send the some of the form fields to a custom database table

how to send the some of the form fields to a custom database table

Hi, champ.
I would love to know if there is a way to send some of the form field that the user fills in when posting an ad to a separate database table ?
i.e:
I have a custom table called "poi" inside i have the following columns that need to collect the following inputs when user submits an ad:

1. id = this is just the standard id column
2. lat = this is the Latitude that gets collected in the classipress table "tb_cp_ad_geocodes" in column "lat"
3. lng = this is the Longitude that gets collected in the classipress table "tb_cp_ad_geocodes" in column "lng"
4. title = this i need to be the default Parent Ads Categories for the particular ad that they are listing (i thing is the parent of "ad_cat" but i am not sure), if this is to hard then i can create a custom field for it with drop down of the parent categories.(it would be nice if there would be a way to add some text between fields, i would create a section where i could explain to the user that the following fields are for the map.)
5. address = this is where the following fields go in together: "cp_street", "cp_city", "cp_state", "cp_country" and "cp_zipcode"
6. url = this is where the Authors page link goes i.e: www.domainname.com.au/author/authorname
7. html = this is where the same fields: "cp_street", "cp_city", "cp_state", "cp_country" and "cp_zipcode" then line breack and then the words "Click Here To See All My Items" and that text to be linked to the Authors page i.e: www.domainname.com.au/author/authorname (but if to hard i can fill this manually)
8. category = again here it needs the Parent categorie of the particular ad
9. marker = nothing goes here.

I hope this is understandable. I know it is quaite a bit and if you think that it would be easier to add some text in the midle of the form (i don't know if that is posible) and say "this are fields for Home page map" and then ill create custom fields for all this, then let me know.
To get a better understanding go to my website here: www.swapnshop.com.au and look at the map on the home page, click on the categorie "clothing & Jewellery" and when the icons show up click on it to see exactly what i mean and what i need it for.
I am doing this manually wright now, but as more users are signing up it is becoming hard to keep up with it.
This will be a life saver.
Thank you soooooo much.