There is probably a simple solution to this problem but I've been going over my code for an hour and I can't seem to figure out what is wrong. Here's my code:

PHP Code:

$sql = 'SELECT * FROM `groups` WHERE 1 LIMIT 0 , 30';
$result = mysql_query($sql);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    $groupName = $row['name'];
    $currGroup = $_POST[$groupName]; //This line is giving me trouble
    if($currGroup != '' or $currGroup != NULL)
    {
        $hasGroup = 1;
        $sql = 'INSERT INTO `'.$dbname.'`.`contacts` (`name`, `address`, `group`, `count`) VALUES (\''.$newName.'\', \''.$newAddress.'\', \''.$groupName.'\', NULL);';
        mysql_query($sql);
    }
} 


Is it acceptable to use a variable as the argument for $_POST[]? I know for a fact that $groupName is equal to the id of the form that i'm trying to retrieve data from

$_POST is not derived from the id, but the name of the input field.

<input type="text" name="This is the POST index name" />


BTW: Its uneccessary to use WHERE 1 in your sql query, you can drop it off if there are no conditions to be used.

I meant name not id, sorry. $groupName is equal to Name but it does not seem to be working still.

Print to the screen the value of $groupName to be sure of its value. Then check if $_POST[$groupName] exists.

echo '$groupName = "' . $groupName . '" and $_POST[$groupName] ' . (isset($_POST[$groupName]) ? 'exists with the value of "' . $_POST[$groupName] . '"' : 'does NOT exists');

Here is the html for the form I'm trying to get input from:

PHP Code:

<input type="checkbox" id="test group" value="test group" name="test group">test group<br>
<input type="checkbox" id="testgroup 2" value="testgroup 2" name="testgroup 2">testgroup 2<br>
<input type="checkbox" id="test group2" value="test group2" name="test group2">test group2<br>
<input type="checkbox" id="NEW GROUP" value="NEW GROUP" name="NEW GROUP">NEW GROUP<br>
<input type="checkbox" id="ANOTHER GROUP" value="ANOTHER GROUP" name="ANOTHER GROUP">ANOTHER GROUP<br> 


and here is the code that generates the code above:

PHP Code:

$sql = 'SELECT * FROM `groups` WHERE 1 LIMIT 0 , 30';
                            $result = mysql_query($sql);
                            while($row = mysql_fetch_array($result, MYSQL_ASSOC))
                            {
                                print '<input type="checkbox" id="' . $row['name'] . '" value="1" name="'. $row['name'] . '">' . $row['name'] . '<br>';
                            } 


when I check to see if $_POST['test group'] exists it doesn't... even though it should.

This may be a silly question, but are you using method="post" in your form tag?

Yeah I am

The only other thing I would think that might (not quite sure tho) break it is using spaces in the names. Maybe some browsers are encoding them as url encoded names. Try this method:

PHP Code:

$sql = 'SELECT * FROM `groups` WHERE 1 LIMIT 0 , 30'; 
                            $result = mysql_query($sql); 
                            while($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
                            { 
                                print '<input type="checkbox" id="' . $row['name'] . '" value="1" name="'. str_replace(' ', '_', $row['name']) . '">' . $row['name'] . '<br>'; 
                            } 


That didn't fix it either, but I figured it out... For some reason it doesn't like the space in the name field of the checkbox. So 'test' works, but 'test group' does not.


Thanks for the help, I can get it working from here.