|
|
Posted by matthud on 02/17/07 20:02
That was a good catch, unfortunately it didn't do the trick.
Here the code is updated with $row.
//GET INSERTED CHUNK ID
$getid = mysql_query("SELECT id FROM chunks WHERE chunk = '$chunk'");
$idrow = mysql_fetch_array($getid, MYSQL_ASSOC);
$chunkid = $idrow["id"].",";
$eachtag = explode(",", $tags);
foreach($eachtag as $key=>$value) {
$query = "SELECT chunks FROM tagtochunk WHERE tag = '$value'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
//CREATE NEW TAG ENTRY
mysql_query("INSERT INTO tagtochunk (tag, chunks) VALUES ('$value',
'$chunkid')");
} else {
//UPDATE CUR TAG WITH NEW CHUNKID
$row = mysql_fetch_array($query, MYSQL_ASSOC);
$updated = $row["chunks"].$chunkid;
mysql_query("UPDATE tagtochunk SET chunks = '$updated' WHERE tag =
'$value'");
}
}
[Back to original message]
|