Hi, I have a form of which one element is a series of checkboxes. I want to be able to tick multiple checkboxes and have the values stored in the db. I'm guessing I need to turn them into an array somehow, but I don't really know how to do it and if I'd need to change my function code?

Here's what I have:
PHP Code:
<?php
// Add a record
    
function add_record($params)
    {
      
$connection db_connect();        
      
$query sprintf("insert into records set 
                                         Name = '%s',
                                         Number = '%s',
                                         Colours = '%s'"

                            
mysql_real_escape_string($params['Name']),
                            
mysql_real_escape_string($params['Number']),
                            
mysql_real_escape_string($params['Colours'])
                            );        
      
$result mysql_query($query);
        if (!
$result)
        {
          return 
false;
        }
        else
        {
          return 
true;
        }        
    
?>
<input type="checkbox" name="Colours" value="Red"  />Red
<input type="checkbox" name="Colours" value="Blue"  />Blue
<input type="checkbox" name="Colours" value="Green"  />Green
<input type="checkbox" name="Colours" value="Yellow" />Yellow
<input type="checkbox" name="Colours" value="Black"  />Black
<input type="checkbox" name="Colours" value="White" />White