Updating Tags: What would YOU do?

[kingnutter]

I am recalling user defined tags into an update form field for using the code below:

 

$query="SELECT moj_genre FROM genres INNER JOIN genrelinkcd ON genres.genre_id=genrelinkcd.genre_id WHERE genrelinkcd.moj_id='$id'";

$result=mysql_query($query);
$num_rows=mysql_num_rows($result);
$count=1;
while ($row = mysql_fetch_row($result))


{
echo "$row[0]";

if ($count < $num_rows)

{
echo ', ';
}

$count++;
}

 

I have a separate table linking the tags to objects. My question is, how would you manipulate the code to update the relationships?

 

Should I delete the original records and create new ones each time? This seems wasteful, but how would you retain the original relationships in order to only amend changes?

[ignace]

Instead of:

 

$num_rows=mysql_num_rows($result);
$count=1;
while ($row = mysql_fetch_row($result))


{
echo "$row[0]";

if ($count < $num_rows)

{
echo ', ';
}

$count++;
}

 

You could also do:

 

$parts = array();
while ($row = mysql_fetch_row($result)) {
    $parts[] = $row[0];
}
print implode(', ', $parts);

[The Eagle]

As posted above,

 

$parts = array();
while ($row = mysql_fetch_row($result)) {
    $parts[] = $row[0];
}
print implode(', ', $parts);

 

This should definitely work. Try this.

[kingnutter]

Very neat.

 

But how does this help me recall / remove / reinsert the amended tags where applicable when the update is submitted?

 

For instance if the original array "Rock, Pop, Soul" is changed by the user to "Rock, Jazz, Classical"?

[ignace]

<?php $genres = array();
$query="SELECT moj_id, moj_genre FROM genres INNER JOIN genrelinkcd ON genres.genre_id=genrelinkcd.genre_id WHERE genrelinkcd.moj_id='$id'";
//..

while ($row = mysql_fetch_row($result)) {
    $genres[$row[0]] = $row[1];
    //.. ?>
<input type="text" name="tag[<?php print $row[0]; ?>]" value="<?php print $row[1]; ?>"><!-- Tag:Rock -->
<input type="text" name="tag[<?php print $row[0]; ?>]" value="<?php print $row[1]; ?>"><!-- Tag:Pop -->
<input type="text" name="tag[<?php print $row[0]; ?>]" value="<?php print $row[1]; ?>"><!-- Tag:Soul -->
<?php }

if (isset($_POST['tag']) && is_array($_POST['tag'])) {
    $ids = array_keys($genres);
    foreach ($_POST['tag'] as $id => $value) {
        if (!in_array($id, $ids)) {
            //newly added tag Rock, Pop, Soul, [Jazz]
        } else if ($value !== $genres[$id]) {
            //modified a tag
        }  
    }
} ?>

[kingnutter]

Thanks so much for your detailed reply.

 

To be very honest, I'm not completely sure what's going on here, or where you're put the dot dots but I shall have a tinker and let you know how it goes.

 

Cheers.