counting search results

[Anon]

Hi all.

I need to count some search results and assign numbers to the field names in checkboxes for users to add results to a database. The results could vary between 1 and about 50:

eg.

I need to get it to return results like this;

bob<input type=checkbox name=person[0] value="bob">
jane<input type=checkbox name=person[1] value="jane">
tarquin<input type=checkbox name=person[2] value="tarquin">
bjorn<input type=checkbox name=person[3] value="bjorn">

I can count the total and put that in the square brackets - but can't get it to assign the count number... Note the results do not come from a database!

Thanks
Beardo

[davidtaylor]

Please note, <column_name> must me specified. If you use * in $querysql instead of specifying the column name, you'll have to change the MYSQL_RESULT accordingly.

Hope this helps.

Dave...

$querysql="SELECT <column_name> FROM ...";
$execquery=MYSQL_QUERY($querysql) or die ("failed on execution");
$numrows=MYSQL_NUMROWS($execquery);
for ($count=0; count < $execquery; $count++)
{
$result=MYSQL_RESULT($execquery,<column_name>);
echo "$result<input type=checkbox name=person[$count] value=\"$result\"";
}

[Anon]

Hi Dave,

Thanks for the reply, unfortunately this isn't quite what I meant. At the moment I have this returned (not from a database):

bob<input type=checkbox name=person[] value="bob">
jane<input type=checkbox name=person[] value="jane">
tarquin<input type=checkbox name=person[] value="tarquin">
bjorn<input type=checkbox name=person[] value="bjorn">

I need to make that into this:

bob<input type=checkbox name=person[0] value="bob">
jane<input type=checkbox name=person[1] value="jane">
tarquin<input type=checkbox name=person[2] value="tarquin">
bjorn<input type=checkbox name=person[3] value="bjorn">

So that I can loop and insert into a table depending upon the user selections....The trouble is I can count the total, but can't seem to get the incremental values inserted within the []....

Sorry If I wasted your time by not making it clear.

Thank you again
Beardo

[davidtaylor]

Sorry Beardo, it's still not 100% clear to me.

Are these statements within PHP tags?
If not, then you may want something along the lines of:

bob<input type=checkbox name=<?echo "$person[0]";?> value="bob">

If you're trying to call a checkbox literally "person[0..n]" then don't. Just change the name to that of the value. Alternatively, remove the square brackets.

On the form action, you could then reference it by saying something along the lines of

FOR ($i=0; $i<$NumOfCheckboxes; $i++)
{
$array[$i]="$person$i";
}

If this still isn't what you mean, feel free to send the full source code. Use erm...
[e-mail]