[RESOLVED] For loops

[matthewod]

I am building a form so I can select multiple items from the same data. I am getting the data from the db but I am running into issues with the output not incrementing. Here is what I have:

<?
$sql_a="SELECT * FROM $tablename order by date DESC";
$result_a = @($sql_a, $connection) or die(mysql_error());
$num_rows_a = mysql_num_rows($result_a);

for ($i = 1; $i <= $num_rows_a; $i++) {

//echo"$num_rows_a";

//echo"$i";

if (mysql_num_rows($result_a) >0 ) {
while ($row_a = mysql_fetch_array($result_a)) {
$ida = $row_a['id'];
$datea = $row_a['date'];
$titlea = $row_a['title'];

$date_a = date("n j, Y", strtotime($datea));

$alist .="<input name=\"audio$i\" type=\"radio\" value=\"$ida\">$date_a $titlea<br>";

	}
}

}

?>

$i before the while loop will show 1234 (4 rows so far), but the audio$i is only showing 1. I have tried the for loop inside the while loop and that is not working.

I am sure this is an easy fix for someone with more experience in this area.

Thanks in advance.

Matt

[shu]

If you want to duplicate the same data n times, why not use string repeat function instead of a for loop?

$alist = str_repeat($alist, $num_rows_a);

If you insist using a for loop, you need to reset the mysql result before each while loop:

mysql_data_seek($result_a, 0);

[matthewod]

Thanks for the reply, but that is not what I am looking for. I have a form that I want to select multiple radio buttons that have the name audio$i and the value is the rowid of the audio file. So I am pulling the audio info from the DB and an output of the html: <input name="audio$i" type="radio" value="$ida">$date_a $titlea. So each radio button is going to be different according to how many audio files there are in the database.

The mysql_data_seek function does not apply here because I am pulling all data from the database and allowing selection of all available files or just one or two, etc.

Thanks for the help.

Matt

[bradgrafelman]

I'm not quite understanding what you're trying to do, but it sounds like you would be better off using checkboxes in an array fashion, like so:

<input type="checkbox" name="audio[]" value="$ida">

No need for a for() loop that way.

Then, in your processing script, you can find out what the user selected by doing something like:

if(!isset($_POST['audio']) || !is_array($_POST['audio'])) {
    // uh oh, they didn't select anything...
} else {
    foreach($_POST['audio'] as $id) {
        // this foreach loop will give you all of the id's they selected
    }
}

[matthewod]

We are getting warmer. I have the POST functions done and ready to go. It is a matter of having the functions to select mulitple files at the same time. Here is what I mean when I get the data from the table I need to display in the form this:

<input type="radio" name=audio1 value=1234>title 1
<input type="radio" name=audio2 value=1235>title 2
<input type="radio" name=audio3 value=1236>title 3
<input type="radio" name=audio4 value=1237>title 4
<input type="radio" name=audio5 value=1238>title 5
<input type="radio" name=audio6 value=1239>title 6
etc . . .

So now once several files names are selected then the next step of getting the info is no problem. Maybe using foreach with the $id as index would work, but can I still use $i as audio$i for the name?

Thanks

[matthewod]

I did some more reach and actually found this post that answered my question:

http://www.phpbuilder.com/board/showthread.php?t=10308070

Thanks for all the suggestions.

Matt