display results only where enum=1

[orionblue]

Hello,

I have a table with 10 columns in MySQL. This table is one of several in the database. The columns hold enum values 0 or 1.

Tom's answer to the question 'I have the following animals' is entered using checkboxes in a form:

<input type="checkbox" name="m_cats" value="1">
<input type="checkbox" name="m_dogs" value="1">
<input type="checkbox" name="m_birds" value="1">
<input type="checkbox" name="m_ferrets" value="1">
<input type="checkbox" name="m_horses" value="1">

If the column value is '1', the record is true and should be displayed on the page (when the query relating to that table is executed).

Ie: Select all columns for tom in the table where the value is 1.

The code I have now seems bulky:

$sql = "SELECT * FROM m_animals WHERE m_name = 'Tom'";
                $result = mysql_query($sql);

            if ($myrow = mysql_fetch_array($result)) 
	{

             do {

if($myrow["m_dogs"] ==1)							  

                        {							 echo "dogs";							 
  	 }

						 if($myrow["m_cats"] ==1)							  
                    {							 echo "cats";							 
 }							  

and so on.

Is there a better way to do this? Two considerations are that I need to be able to edit the info (right now I call the records back into check boxes, checked=1 if value=1), and that I want to be able to display the results using bullets and in 2 columns (I can sort this out myself, but just FYI).

thanks in advance for any tips...

[orionblue]

No thoughts on this? I'm hoping to learn from the experts the proper way to do this...

[Mark_Nordstrom]

$sql = "SELECT * FROM m_animals WHERE m_name = 'Tom' AND m_cats='1' OR m_dogs='1' "; 
                $result = mysql_query($sql); 

Cant you just do that then ?

[orionblue]

Thanks Mark but I don't think that will work... I want to display the name of the animal only if it = 1. There is no way to display the name in this case. Or am I really missing something simple?

[Mark_Nordstrom]

then

<?
$sql = "SELECT * FROM m_animals WHERE m_cats='1' OR m_dogs='1' ";  

                $result = mysql_query($sql);
?>

should work.

When you select it by * it selects every field as you know. This makes it so it selects all fields but only where m_cats=1 or m_dogs=1

[orionblue]

Thanks again Mark,

Yes, that query does work, but the problem I'm having is with echoing the results. So, if m_cats, m_dogs, m_horses all =1 but m_cows=0, the list will look like:

Tom has the following animals:
Cats
Dogs
Horses

Does that make sense? The table has only one id - the member name, and for each row the member name could have up to 10 true values.

thanks again for any advice.