make image title array

[jrahma]

I am using the following code to populate images from MySQL database. I want to have image_title for every image which will be a textbox below the image. I know how to populate it but how can I make it named so when user changes the title it will only change for the specific image?

<?php
    $mysql_command = "CALL sp_populate_member_article_media(:param_article_guid, :param_member_id)";
    $mysql_query = $mysql_connection->prepare($mysql_command);
    $mysql_query->bindParam(':param_article_guid', $_GET["aid"], PDO::PARAM_STR);
    $mysql_query->bindParam(':param_member_id', $_SESSION["volow_member_id"], PDO::PARAM_STR);
    $mysql_query->execute();

while($mysql_row = $mysql_query->fetch())
{
    list($width, $height) = getimagesize($_SESSION["volow_absolute_path"] . "/gallery/members/" . $_SESSION["volow_member_guid"] . "/" . $_SESSION["volow_channel_guid"] . "/" . $_GET["aid"] . "/". $mysql_row['file_name'] . ".png");

    if ($width > 650) { $width = 650; };
    if ($height > 271) { $height = 271; };
?>
<tr><td align="right" valign="top"><img src="<?php echo $_SESSION["volow_domain_name"]; ?>gallery/members/<?php echo $_SESSION["volow_member_guid"]; ?>/<?php echo $_SESSION["volow_channel_guid"]; ?>/<?php echo $_GET["aid"]; ?>/<?php echo $mysql_row['file_name']; ?>.png" width="<?php echo $width; ?>" height="<?php echo $height; ?>" /></td></tr>
<tr><td><hr></td></tr>
<?php } ?>

Thanks,
jassim

[bradgrafelman]

I normally do this by adding the value of a primary key to the textboxes' names.

For example, if you had an AUTO_INCREMENT column and were processing image ID number 1234, you could output HTML such as:

<input type="text" name="img_name[1234]" value="current_name.png">

When you process the form, $_POST['img_name'] will be an associative array where the key values correspond to the ID value in the database that the name value is paired with.