How can I auto increment checkbox names?

dalton

Hi, I want to insert checkboxes next to each query result with each checkbox name incrementing by one for each result. For example in the printf part of the code below I want compare1 to be compare2 for the next returned record and so forth.

The check boxes are in a single form that when submitted will limit the query to the checked records by their id. If anyone knows what code I can add to the following to autoincrement each checkbox name I would much appreciate it. I guess the checkbox name could just as well be 1, 2, 3 instead of compare1, compare2, compare3 if it makes it any easier Thanks!

if ($search) {

$result = mysql_query("SELECT * FROM tablename WHERE (keywords LIKE '%$keywords%')",$db);

if ($myrow = mysql_fetch_array($result)) {

echo " HTML table header stuff;

do {

printf("< tr >< td >< input type = checkb0x name=compare1 value=%s>< /td >< td >< a href=\"details?id=%s\">%s< /a >< /td >< td >%s< /td >< td >%s< /td >< td >\$%s< /td >< td >\$%s< /td >< td >\$%s< /td >< /tr >", $myrow["id"], $myrow["id"], $myrow["sitename"], $myrow["category"], $myrow["traffic"]);

}

while ($myrow = mysql_fetch_array($result));

}
else {
echo "Sorry there were no sites found in our database that matched your keywords.";
}
}

Anon

if ($search) {
$nr=0;
$result = mysql_query("SELECT * FROM tablename WHERE (keywords LIKE '%$keywords%')",$db);
while($myrow = mysql_fetch_array($result)) {
$nr++;
echo " HTML table header stuff
<table>";
printf (< tr >< td ><input type = 'checkbox' name='compare$nr' value=%s>< /td >< td >
< a href=\"details?id=%s\">%s< /a >< /td >< td >%s< /td >< td >%s< /td >< td >\$%s< /td >< td >\$%s< /td >< td >\$%s< /td >< /tr >,
$myrow["id"], $myrow["id"], $myrow["sitename"], $myrow["category"], $myrow["traffic"]);

while ($myrow = mysql_fetch_array($result));

}
else {
echo "Sorry there were no sites found in our database that matched your keywords.";
}
}

so each checbox name is incremented by one like compare1, compare2 and so on

dalton

Thanks Lauri I got it working. I had tried something similar to what you suggested before but must of had the auto increment variable outside of the loop as it was not working. Thanks again for your help!

Anon

Hi there,

I am having the same problem (solved now) but do you know a routine that I can use to check for these names on the results page?

For example if you ticked compare1, compare2 and compare3, these variables would be passed to the results pages as "on". How do I check which variables have been set to "on"?

Best regards

David