Sorry, but this forum and another one are my "classrooms" for php/mysql, lol.
Ok, so if I had a form to post points to create new records for my members and I have several different types of points - then the actual points for the types are in their own tables - I could possibly do something like this?
I have a "type" table and 4 "points" tables, I want the form to be used to insert data into a "records" table
something like this:
if type = A connect to point1 table, put data in array, then display that array as a dropdown list for user to choose the appropriate point
elseif type = B use point2 table, same thing
elseif type = C use point 3 table, same thing
else use point4 table (which would be the one used most often)
I learned Structured Cobol many many years ago and we approached conditional statements from the negative.
I don't want the code to waste it's time going thru the IF's so if the most likely selection is point4 table, should that be in the first if? If condition 1 is true I want it to process the data and not run thru the other IF's.
Also would this possibly need to be a multipage form?
Thanks,
Barb