form code and mysql values

[nick_kirby]

Hello - I am creating a form setup where people can tick checkboxes or option buttons to express a preference.

What I want to do is have that value - either 0 or 1 stored as a db field, and then, when the client wants to print out their preferences have those binary values converted into a text value as part of the print out (bt not stored in the D😎.

For example,

A user requests soup for a first course instead of cheese. That choice is stored in a db under the users login. when they want to rpint their menu, the system prints out Soup rather than the integer value.

I know this would need each checkbox to be individually identified, but that's not problem. What I'd like to know is, is it possible?

All help gratefully received.

[Shrike]

I would create a table for the courses of food, with an id field, the name of the food, and an id_course for the name of the course. I'd then need a course_names table which would link course_id to the course name (First course, second course, desert etc).

Then when creating the form I would use radio buttons rather than checkboxes, one radio button group for each course name (first course, second course etc) on offer, with each radio button being a type of food. Then you can save the selected courses to the menu table, which would have integer fields for id (course) and course_id (course name).

Finally to create the text view of the menu, you could lookup the real names of the food by the id, and the names of the courses by the course_id.

SELECT course, course_name
FROM menu, courses, course_names
WHERE menu.user_id = $the_user_id
AND menu.id = courses.id
AND menu.course_id = course_names.course_id
GROUP BY course_name