[Resolved] populating a check box from a db

[scambro]

This seems like a fairly straightfoward concept, but I can't seem to get mine to work, or find a good tutorial on it.

This is the basic skeleton of what I'm trying to do:

Table1:
table1_id,table1_disp

Table2:
table2_id,table1_id,table3_id

I populate an html table on a web page with all the values from table 1 with checkboxes next to them. What I want to do is have them default to being checked if they exist in table2 for that particular record.

So right now I have this, and it deffinitly doesn't work :o

$sql = "SELECT table1.tabl1_id, table1.table1_disp
		FROM table1
		WHERE table1.active_ind = '1'
		ORDER BY 'table1_disp'";
$results = mysql_query($sql) or die(mysql_error());
while ($row=mysql_fetch_array($results))
{
	$table1_id = $row['table1_id'];
	$mgr_sql = "SELECT table1_id,table3_id
			FROM table2
			WHERE table1_id = '".$row['table1_id']."' AND table3_id = '".$_GET['table3_id']."'";
	$mgr_results = mysql_query($mgr_sql) or die(mysql_error());
	while ($row2=mysql_fetch_array($mgr_results))
	{
		if ($row2['table1_id']==$table1_id)
		{
			$table1_checked = " CHECKED";
		}else{
			$table1_checked = "";
		}	
	}
	if ($nbrow % 5 === 0) 
	{ 
		echo "</tr><tr>\n";
	}
	$nbrow++;
	echo '<td class="tableleft">';
	echo '<p align=right><input type="checkbox" value="'.$row['table1_id'].'"'.$table1_checked.' name="table[]">'.$row['table_disp'];
	echo "\n";
}

Where am I going wrong (I realize it might be in quite a few places....)? Thanks!

[bpat1434]

Well what doesn't work? The checking, the queries, the new rows? What?

First thing I see is:
Are you sending the value 'table3_id' through the URL?

~Brett

[scambro]

Originally posted by bpat1434
Well what doesn't work? The checking, the queries, the new rows? What?

First thing I see is:
Are you sending the value 'table3_id' through the URL?

~Brett

As soon as I hit one box that should be checked, the rest of them are also checked. So I'm screwing something up when I compare the two.

When I print_r my two arrays (row, and row2), I get what I expect, so I think my two queries are working properly. Yes, table3_id is being passed through the URL.

Thanks!

[bpat1434]

try unsetting the variable $table1_checked after the echoing of the checkbox.

unset($table1_checked);

Also, try switching the order of your if() statement:

if($row['table1_id'] == $row2['table1_id'])

And, one last thing, write in some code to show what place you're in with the if() else() statement.

if($row['table1_id'] == $row['table1_id'])
{
echo "Check the checkbox";
}
else
{
echo "Not checked.";
}

~Brett

[scambro]

Originally posted by bpat1434
try unsetting the variable $table1_checked after the echoing of the checkbox.

unset($table1_checked);

Also, try switching the order of your if() statement:

if($row['table1_id'] == $row2['table1_id'])

And, one last thing, write in some code to show what place you're in with the if() else() statement.

if($row['table1_id'] == $row['table1_id'])
{
echo "Check the checkbox";
}
else
{
echo "Not checked.";
}

~Brett

Sorry it took me so long to get back on this, but the unset did the trick. I included it after the last "}" in my above php code.

Thanks for the help!