$result = mysql_query("SELECT `termid` FROM connected_texts");
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$orig_term_tax_id = $row['termid'];
$result2 = mysql_query("SELECT * FROM term_relationships WHERE `term_taxonomy_id` = '$orig_term_tax_id'");
while ($row2 = mysql_fetch_array($result2, MYSQL_BOTH)) {
$objectid_textid = $row2[0];
if (!$bookpart) {
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$bookpart = $row3['bookpart'];
if ($bookpart == '1') {
$bookno = $objectid_textid;
$result4= mysql_query("UPDATE connected_texts SET `textid` = '$bookno' WHERE `termid` = '$orig_term_tax_id'");
}
}
}
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$result4= mysql_query("UPDATE texts SET `book` = '$bookno' WHERE `textid` = '$objectid_textid'");
}
}
$bookpart = '';
}
It's amazing what your brain can do when it's not got two tons of unhappy perched on top.
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$orig_term_tax_id = $row['termid'];
$result2 = mysql_query("SELECT * FROM term_relationships WHERE `term_taxonomy_id` = '$orig_term_tax_id'");
while ($row2 = mysql_fetch_array($result2, MYSQL_BOTH)) {
$objectid_textid = $row2[0];
if (!$bookpart) {
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$bookpart = $row3['bookpart'];
if ($bookpart == '1') {
$bookno = $objectid_textid;
$result4= mysql_query("UPDATE connected_texts SET `textid` = '$bookno' WHERE `termid` = '$orig_term_tax_id'");
}
}
}
$result3= mysql_query("SELECT `bookpart` FROM `texts` WHERE `textid`='$objectid_textid'");
while ($row3 = mysql_fetch_array($result3, MYSQL_BOTH)) {
$result4= mysql_query("UPDATE texts SET `book` = '$bookno' WHERE `textid` = '$objectid_textid'");
}
}
$bookpart = '';
}
It's amazing what your brain can do when it's not got two tons of unhappy perched on top.