DeadTOm wrote:
There has to be an easier way to do this. I have a page with a list of 29 options utilizing checkboxes. The options that are checked get put into a mysql table as a 1 and the options not checked get entered as a 0. So the table looks like this id cs01 cs02 cs03 cs04 1 0 0 1 0 2 1 0 0 0 3 0 0 0 1 The problem I'm running into is getting these things back out of the table. I only want the columns where the answer is a 1.
Try this? [ requires mysql 4.0+ ] select id, 'cs01' as column_name from table where cs01='1' union all select id, 'cs02' as column_name from table where cs02='1' union all select id, 'cs03' as column_name from table where cs03='1' union all select id, 'cs04' as column_name from table where cs04='1'; -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
