This is what I am trying to do

OK. Using chrono forms here is what I am trying to do. I am trying to make a form where registered users can build a data list of two different fields of text. One is the name, two is the short explanation of that name. I want it to submit this to a database and save it and let them add different entries to build it up. Then if they want to search the list they can use a form to search the database table it is in. Searching by field 1 (name) and retrieve the explanation part or many explanation parts if there is many for that name. I also need it to store multiple but different entries of the explanation part for the same 1st(name part). I understand finally how to access the user ID assigned to a user who registered on my site and how to get it from the session so I can identify each user and use that to access their specific database table.(For instance the user id is 43 so my first data table is named 43. I am trying really hard to learn this stuff but I need some nudges. Could someone explain to me what they might do to accomplish what I am trying for?

Hi tigger4444 ,

You need a table with (at least) four columns: 'id' a primary key which will be autoincremented when a new record is added; 'name', to record the name; 'user_id', to record the user who added the explanation; and 'explanation' to record one explanation for this name. (You may also have some other columns used for housekeeping - ChronoForms adds some if you use the Create Table icon.)

This will give you records like this:

1 :: name_1 :: 99 :: some text
2 :: name_2 :: 88 :: some other text
3 :: name_1 :: 77 :: still more text
. . .

Bob



Bob

Thank you. I will try again in a little bit to see if I can git it right.

Does this look correct for setting the fields for the table?




I have the forth field so it saves the user ID of the user making the entry that way it can be used as a search term for querying the table along with the reqname part that way it only returns the hitdescr when the two fiels are met. Is this right?

edit😛lease help me get this working. If you say you will help get me through it I will 'buy you some beer' now and even more later =] I am just a noob. fair warning but I definitely have commen sense =]

Hi tigger4444 »,

The INT vales are OK except that the length of 101 is enormous, Just INT should be good.

The Explanation should probably be of type TEXT unless you have a size limit set.

The VARCHAR needs a length, 128 is probably good.

Bob

Thank you. I now have the table I need thanks to you. Starting to understand a little bit more how they work and get set up. As promised I bought you a tequila sunrise =] Only $5 but it is a start. I will be back with more questions and money as I try to get my plan working.
sent to:
Paid to
Revell and Janes Ltd
Many thanks for you trying to help me. Look forward to getting this workin. Probably be back with more questions in a bit.. lol..

This is how it looks now..



The 1st field is the id for each entry and I have it increment with each entry
the 2nd field is where I will have it save the specific logged in user ID that posted the sata be.
the 3rd field is the name also to be used when going to this table to get entries.
the 4th field is the description of the name which is the data I will need pulled on search queries.

I am now trying to figure out how to implement the form so it gets the user id from joomla session (it is just an integer)and puts it in this table along with the other data it submits. Ideas?

OK OK. I was making this way harder than it was. I am succcessfully using the forms manager to create the form and make the table. Wow I feel dumb. I WILL be buying the full version on this soon as I get this working correctly. I will probably have more questions though and will happily pay for answers =] is worth it to me. be talking to you again soon!