Check boxes with PHP

[NathanS]

Hi guys,

 

Tearing my hair out over this one! Currently returning a list from a database of customers, via an array. It displays without a problem - what I need to be able to do, is add a checkbox by each one, so someone can tick it and click submit, and it'll update the database for that record.

 

How would I go about linking it in with the ID so that this would be possible?

 

Any help on this would be greatly appreciated!

 

Thanks,

 

Nathan.

[able]

set the html element name to ids[]

set the value for each box to the id

 

You'll then get an array $_POST['ids'] that contains the id's of all checked which you can use.

[NathanS]

Still stuck on exactly how to achieve this: this is what I have now:

 

first page:

 

		echo "<TD WIDTH=70>";
	echo "<font color='#FF6633'>";
	echo "<INPUT TYPE='checkbox' ID='NEWID[]' VALUE='$id'>";
	echo "</TD>";
	echo "</font>";

 

update page:

 

$sql = "UPDATE customer_insured_party SET ACTIONEDYN  = '".$_POST["ACTIONEDYN"]."' WHERE cip_id = '".$_POST["NEWID"]."'";

 

Am i missing something major?

 

Thanks.