[RESOLVED] Retrieving and Updating Multiple Rows

[mpar612]

I have seen multiple posts in the forum on this, but I'm still a little confused. I'm newer to PHP and am having difficulty putting together the limited knowledge I have of arrays and populating a form.

I have information stored in a db. The code I am using to retrieve it and put it into a form so the user can update it is listed below.

My first issue is that it is not populating the radio button properly (as being checked or unchecked). It will properly check the first result from the db, but none of the others. From what I have read on the forums this problem is probably linked to not using arrays to echo the data. My first question is how do I properly retrieve the information and populate the form? This also leads to my second question, how do I submit this information to the database to update multiple rows.

Any help would be greatly appreciated. Thanks in advance.

<?php
    $propId = $_GET['propId'];
    $sql = "SELECT imageId, propId, path, title, main FROM images WHERE propId = $propId";
    $rows = $db->getAll($sql);

foreach ($rows as $row) {

$image = $row['path'];
$title = stripslashes($row['title']);
$main = $row['main'];

echo "<tr><td rowspan=\"3\"><img src=\"../$image\" height=\"80\" width=\"80\" /></td>
<td><label class=\"label\">Title: </label><input type=\"text\" name=\"title\" size=\"25\" maxlength=\"25\" value=\"$title\"></td></tr>";

if ($main == 'y') {
echo "<tr><td><label class=\"label\">Main Image: </label><input type=\"radio\" name=\"mainThumb\" value=\"y\" checked></td></tr>";
} else {
echo "<tr><td><label class=\"label\">Main Image: </label><input type=\"radio\" name=\"mainThumb\" value=\"y\"></td></tr>";
}

 if ($main == 'n') {
echo "<tr><td><label class=\"label\">Thumbnail: </label><input type=\"radio\" name=\"mainThumb\" value=\"n\" checked></td></tr>";
} else {
echo "<tr><td><label class=\"label\">Thumbnail: </label><input type=\"radio\" name=\"mainThumb\" value=\"n\"></td></tr>";
}

echo "<tr><td>&nbsp;</td></tr>
<tr><td>&nbsp;</td></tr>";
}
?>

[nocando]

Not sure I'm following you, but are you sure you want the same names on your radiobuttons - mainThumb?

And you can probably simplify this piece of code:

    if ($main == 'y') {
    echo "<tr><td><label class=\"label\">Main Image: </label><input type=\"radio\" name=\"mainThumb\" value=\"y\" checked></td></tr>";
    } else {
    echo "<tr><td><label class=\"label\">Main Image: </label><input type=\"radio\" name=\"mainThumb\" value=\"y\"></td></tr>";
    }

 if ($main == 'n') {
echo "<tr><td><label class=\"label\">Thumbnail: </label><input type=\"radio\" name=\"mainThumb\" value=\"n\" checked></td></tr>";
} else {
echo "<tr><td><label class=\"label\">Thumbnail: </label><input type=\"radio\" name=\"mainThumb\" value=\"n\"></td></tr>";
} 

...into this:

    $checked = ($main == 'y') ? " checked" : NULL;
    echo "<tr><td><label class=\"label\">Main Image: </label><input type=\"radio\" name=\"mainThumb\" value=\"y\"$checked></td></tr>";
    $checked = ($main == 'n') ? " checked" : NULL;
    echo "<tr><td><label class=\"label\">Thumbnail: </label><input type=\"radio\" name=\"mainThumb\" value=\"n\"$checked></td></tr>";

Am I wrong?

[mpar612]

Thanks for the response! That does simplify the code. I have the radio buttons named the same thing, because they are functioning similarly to a Yes/No type of application. For example, if the form asks a question and requires a Yes/No answer, you will often see two different radio buttons with the same name, but different values. I hope this makes sense and I hope I am doing it right.

I've done some more research and I think I want to change the name from "mainThumb" to "mainThumb[]".

In my database I have several rows that contain a path to an image, a title (a text field), and a value which is either 'y' or 'n' (the two radio buttons). I want my PHP script to print out these database values into a form for each row returned from the database. Then I want the user to be able to change the title and the y/n value (the radio buttons) and submit this data to update the database.

I hope I am explaining this clearly.

Thank you for your help!!!

[mpar612]

I found a different way to go about doing this. I am having the users update each row individually rather than trying to do several at once. I was trying to eliminate this step.

Thanks