mySql and a single form

Anon

This is what I'm doing:

I have a table with several columns,
select * from table1.

I'm putting all tha information on a page, generating a checkbox for every record, this will allow the users to select several records and click the go button to have them(the selected records) analized.

The checkbox name are generated as follow:

$i=0;
while (......)
{

$sl='a'.$i;
< .... name='$s1' ......>
}

The problem is (once the select the records and click "go" how do I know which records were selected in the previous page, I may have $a0, $a2, $a7 or I may have none of them,
Please I need help, if you guys dont get the picture, I can be more explicit, I've been thinking about this for days, Thanks hope to hear from you.

jcleary

If you have a only a few fields you can do this

if ($a1 != "") {

do stuff

}

But in general its better to loop through the $HTTP_GET_VARS or $HTTP_POST_VARS array, and do the processing from there. If you need more info, let me know what your trying to do exactly and I'll see if I can help.

Anon

This is the code I have, once the user hits the "go" button, I need to go back to the data base and grab the rest of the information for the selected records.

.....select * from table1....
while($myrow = mysql_fetch_array($result))
{

$id = $myrow["id"];
$desc = $myrow["desc"];

echo "...$id .... $ desc";
}

I want to display the information for the previous selected records only, so I have to test for the variable inside the loop if I do this:

if ($a1 != "") {

do stuff

}

I will get the same record repeated as many times as I go thru the loop, since they will always satisfies the condition.

I need to know how to build the variable name dinamically inside the loop.

My data base have few records (less than 50), but not a fix number of them , so at a given point in time I dont know how many were displayed (I do know that they were less than 50).

Thanks for your help. It's greatly app.

Thanks sanddy

jcleary

Try this:-

$query = "select * from table where ";

foreach ($HTTP_GET_VARS as $key => $value) {
if (substr($key,0,1) == "a") {
$query .= "id = '" . substr($key,1) . "' ";
}
}

Note: You will have to use $HTTP_GET_VARS or $HTTP_PUT_VARS depending on weather you use the get method or put method.
I haven't tested this code, its just an example - hope it helps