Checkbox help needed

TCovert

I have no idea how to do this, so help me out if you can.

I have a search page, the brings back the results in atable format. Each row in the table gives the data for each row in the database that was pulled. To the left of this row, there is a checkox, its name and value are realted to the records id. For instance, if the record id is 200, then the checkbox name will be "select200" and its value will just be "200".

NOw, what I need to know, is how, after selecting the ones I want to continue with, and submit the page, I can take the ones that are checked and display them on a new page.

I figure if I can have some way to get a count of how many are checked, and the values of the ones that are checked, then I can take that data to make a loop and select the data out of the database, and re-display it.

But, I do not know how to see if a checkbox is checked in the code.

Any heelp would be great. Thanks.

g7ibby

If I understand correctly with what you are doing , when you press submit to continue you will not be able to count what boxes are checked because the boxes that are not checked will not exist as variables. Only checked boxes will be passed to the next page.

Im personaly not exactly sure how to count the existant variables but i think that might be where you should start.

If its possible im sure another senior member could fill us in where to go from here.

Hope that helps

barand

You need to have an array of checkbox values passed to the next form. Easiest way is name them like

In your next form, $select = $_POST['select'] gives an array of selections.

hth

batman

You are on the right track. On the first results page give all the check boxes the same name, just different values. Now on the second results page you will have to do something similar.

Set your checkboxes like: <input type=checkbox name="selected[$id]">


$selected = $_POST['selected']

if(isset($selected))
{
while ($line = $selected) {
foreach ($line as $value)
}
}

//then query the ones checked
$sql = "SELECT * FROM table name WHERE id='$value'";
$result = mysql_query("$sql") or die("Query failed");
$totalrows = mysql_num_rows($result);
if($totalrows==0){echo"<br><br><p align=\"center\">The product you are trying to view no longer exists in our database!</p>";}
if($totalrows!==0){
	  while ($row = mysql_fetch_array($result))
      {
          $var1 = $row["var1"];
          $var2 = $row["var2"];
          $var3 = $row["var3"];
          $var4 = $row["var4"];
      }

Then just print out the variables associated with that product however you want.
-Blake