[Resolved] Pulling a data from array of checkboxes

[sharapov]

I am passing a value of checkboxes on a form to a new page like this (see example here: http://www.gibsonusa.com/test/check/)
In a new page how can I pull the data from a MySQL database according to each value I passed from a previous page? In other words: Assume that the value of a checkbox equal to the ID of the record in a database. The value of checkbox 1 (for example) is 12345 and the value of checkbox2 is 67890. After passing those values to a new page how can I pull the rest of the information from a database?

[roneill]

IF you have named your checkboxes in your HTML code like this:

name="id[]" value='565656' (or string from db)

Then your id values will be contained in $id as an array when passed to the SUBMIT page.

e.g. $id[0] = 64547, id[1] = 83738

Your next job is to count how many elements there are in the id array using:

$num = count($id);

So you can then use a for loop to generate your query.

for($i = 0; $i <= $num; $i++);
{
$sql = "SELECT name, age FROM tablename WHERE id = '$id[$i]' ";

$result = mysql_query($sql, $link);

while($row = mysql_fetch_array($result)){
$name = $row['name'];
$age = $row['age'];

echo $name;
echo $age;
}
}

HTH

Ryan

[roneill]

Alternatively look up serialize() and unserialize()