Getting certain info in variables


#1

I have a form where a user selects up to 4 options out of 50 or so possible answers. They are possible teaching endorsments, and a teacher may have no more than 4. They are credential codes ie 001, 002, 003 etc. I have my database setup so that these codes are the names in the database. When they select the answers an X gets put in the database. Now my question, What would be an efficient way of getting the 4 entries in the database with an X into variables?

Thanks for any tips.


#2

I don’t understand your database design. Please show your create statement and reexplain with examples.


#3

Ok I just have a table the name of the fields are codes (100, 101, 102 etc)
On the form they have the option of checking these codes and if they do check it an X gets put in the database for that field (ie if they check the 100 box then and X gets put into the table in the 100 field).

A person will only choose 4 out of 50 of these options. I am creating a page that will list the ones that they chose only (ie if they chose 100,200,303 and 404 boxes then I will just list those on the page) My problem is I do not know how to get just the fields that the user selected (with an X in it).

Thanks.


#4

"My problem is I do not know how to get just the fields that the user selected (with an X in it). "

No, your problem is your database design. Instead, do it like this:
Have four columns: num1,num2,num3,num4
Put the four checked numbers in these columns. Problem solved (I assume you know how to do the query now).


#5

Ok assuming that would work (have to think it through some more) how would I get num1 -num4 populated with the 4 they choose?

thanks!


#6

I really don’t see the problem. It is a very simple query.
“INSERT INTO tabelname (‘num1’,‘num2’,‘num3’,‘num4’) VALUES (’$num1’,’$num2’,’$num3’,’$num4’)”;

I may have a small syntax error, but that is the theory right there.


#7

I understand the sql side of it but if I have a list of 50 or so options how do I get the options they selected into the num variables.


#8

Best thing to do when you need help: Google for others with the same problems. You need to know how to get the checkbox info into PHP:
http://www.webmasterworld.com/forum88/3620.htm


#9

In other words, I’m currently too lazy to parse all that for you, I think some reading will do you good.

This is, of course, what I do with problems - I don’t know the answer to that many off by heart, but Google and php.net are powerful tools. I can usually solve the problem pretty quickly with them before resorting to asking the gurus like Bane and Monk.


#10

Thanks.