Forums

hello
1) i need to create a new table by using some of the entries of table which is created by filling in the data on form using chronoform. For this i need to add sql querries. So can anybody pls tell me where i can write this php codes in chronoform. and how to create this new table so enteries can be inserted into it..
Note: i know a table can be linked to your chronofrom but i want to create a new table by using this already created table

Hi muskan,

Plese can you give us a real example - it's hard to understand what you need to do. I can't think of a situation where you'd need to create new tables from forms. It's possible though.

Bob

hi
I need to make a form in chronoform which asks for user name, city, area, item(clothes,shoes etc..), brands, email-id, phone etc......Based on these entries i need to send emails to users(consumers) about merchants selling those items of that particular brand.....And i need to create a database for consumers storing details of consumer(like his/her name, ph no and email)
So actually i am facing 2 problems right now
1) How to retrieve data from form submitted by user/consumer and check from my database containing information about merchants to look for relevant merchants.
2) How to insert values into my consumer database containing information about consumers.(this consumer table is not required to have item,brand etc demanded by user in the form....thats why cannot use the same table created by form)

i know how to use sql querries to check for data in tables and insert new values into it.....but don't know how to implement the same using chronoconnectivity and chronoform.....

Hi muskan,

for #1, I think you need something like a "search" for records ? there is a post here for how to make a search for Connectivity!
#2- isn't this a normal record insert which can be done easily using Chronoforms ?

Cheers
Max