counting checks

[redzzzon]

Hi Everyone

I am brainstorming with a goal.

The Algorithiam is as follows

1. a list is generated from a query.

2 The accoc is dumped into a dynamic table.

---

each row has a first column with a check box element.

---

3. A user is asked to check the check box to add a entry to their freind list.

4. The user submits the form with all the check boxes

Here is the start of the learning curve

5. A count of each checked with a value dumped by the first query.

6. A query of the data based on value of a checked box.

6a. Data from that row where attribute of database = value

7. Enter the result into dynamic table

8. checks to see if number of runthrough of database meets the number of true value of check box by user

8a If yes stop

8b If no go to step 5.

---

I do not know how to count the number of check boxes at this time. If there is another method please suggest.

Thanks Tom

[jannoy]

assume you have table name
mycheck
Id | value
1 | hello
2 |yes
3 | world
4 | what
5 | olrayt

then let us use forms method="post"
<form name="form1" method="post" targer="count.php"
// let us display here
<?
$query=mysql_query("select * from mycheck")
while ($result=mysql_fetch_object(($query) )
{
echo '<input type="checkbox" name="check[]" value="$result->id">'.$result->value; // you will notice that the name compose of array check[]
echo ' <input type="submit" name="Submit" value="Submit">';
}

?>

</form>

and in your count.php
<?
$checkmany=$_POST['check'];
$x=0;
// since check variable is in array then we count how many check
for ($x=0;$x<sizeof($checkmany);$x++) {
echo $checkmany[$x]."<br>";
}
?>

there might be an error in this script, I didnt test it

[redzzzon]

Thanks

Now how do I loop throught to query a database of the values taken from the users marl of the check box.

Tom

[jannoy]

for ($x=0;$x<sizeof($checkmany);$x++) {
echo $checkmany[$x]."<br>";
$id=$checkmany[$x];
// then let us do searching here
$query=mysql_query("select * from yourtable where value='$id'");
$while ($result=mysql_fetch_object($query)) {
echo yourdata here;
}

}