Problem Deleting Messages From Database

[auctiontrader]

Hi,

I am setting up an auction site, at www.auctiontrader.co.nz ..

one of our features in a built in message system.. ie- i ask a question on your auction and a message is sent to your inbox in your members area. the problem i am having is that these messages cannot be deleted.

I have two copies of my site.
one is the original code, and there is no problem with that version.

the second copy is my modified version and this is the one I am having problems on.

No doubt, during my modifications to the site I have stuffed up something to do with this, but I can't figure out what.

Perhaps one of you php experts could let me know exactly what functions my site is using to deleted these messages and offer a possible solution.

below is the code from the main php files.

<?
$getOpenMessages = mysql_query("SELECT * FROM my_messages WHERE is_this_question=1 AND seller_id='".$SESSION['memberid']."' ORDER BY post_date");
$nbOpenMessages = mysql_num_rows($getOpenMessages); ?>
<!-- // THIS REMOVES THE QUESTIONS FROM BIDDERS AND BUYERS -->
<? if (isset($POST['removeQuestion'])) {
if (count($POST['delete'])>0) {
for ($i=0;$i<count($POST['delete']);$i++) {
$deleteQuestion=mysql_query("DELETE FROM my_messages WHERE id='".$delete[$i]."' AND seller_id='".$SESSION['memberid']."' AND is_this_question=1");
$deleteAnswer=mysql_query("DELETE FROM my_messages WHERE seller_id='".$SESSION['memberid']."' AND is_this_question=0 AND belong_to_question='".$delete[$i]."'");
}
}
echo "<br><p align=\"center\"><b>MESSAGE(S) BEING DELETED FROM THE LIST...</b></p>";
$link = "mymessages.php";
echo "<script>window.setTimeout('changeurl();',2500); function changeurl(){window.location='$link'}</script>";
} else {
header7("<b>".$lang[memarea_title].":</b> ".$lang[memarea_hello]." ".$SESSION['membername']);
include("membersmenu.php");
} ?>
<!-- // THIS REMOVES AN ANSWER - FROM THE LIST OF ANSWERS -
// BUT WONT DELETE IT IN ORDER FOR IT TO STAY AFTER A SELLER
// INSERTED ITS QUESTION AND ANSWER INTO SELLER"S ITEM LISTING -->
<? if (isset($POST['removeAnswers'])) {
if (count($POST['delete'])>0) {
for ($i=0;$i<count($POST['delete']);$i++) {
$updateAnswers=mysql_query("UPDATE my_messages SET answer_read=1 WHERE id='".$delete[$i]."' AND buyer_id='".$SESSION['memberid']."' AND is_this_question=0");
}
}
echo "<br><p align=\"center\"><b>ANSWER(S) BEING REMOVED FROM THE LIST...</b></p>";
$link = "mymessages.php";
echo "<script>window.setTimeout('changeurl();',2500); function changeurl(){window.location='$link'}</script>";
} else {
//header7("<b>".$lang[memarea_title].":</b> ".$lang[memarea_hello]." ".$SESSION['membername']);
//include("membersmenu.php");
} ?>
<form action="mymessages.php" method="post" name="mymessages" >
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="contentfont">
<tr align="center" class="c1">
<td colspan="4"><?=$lang[mymessages_title]?></td>
</tr>
<tr style="font: bold; color: #666666;">
<td width="15%" align="center" style="font-size: 10px;">From</td>
<td width="65%" align="center" style="font-size: 10px;">Subject</td>
<td width="15%" align="center" style="font-size: 10px;">Received</td>
<td width="5%" align="center" style="font-size: 10px;">Mark or<br>Unmark</td>
</tr>
<tr class="c5">
<td colspan="4" background="images/pixel.gif"><img src="images/pixel.gif" width="1" height="1"></td>
</tr>

<!-- THIS SHOWS MESSAGES FROM ADMIN -->
<tr bgcolor="#CAE4FF">
<td colspan="4" align="center" class="smallfont">Messages from <?=$setts['sitename']?>.</td>
</tr>

<? $getAdminMessages = mysql_query("SELECT * FROM my_messages WHERE from_admin=1 AND is_this_question=1 ORDER BY post_date"); ?>
<? while ($adminMessages=mysql_fetch_array($getAdminMessages)) { ?>
<tr class="<? echo (($count++)%2==0) ? "c2":"c3"; ?>">
<td align="center" class="smallfont"><?=$setts['sitename']?></td>
<td align="center" class="smallfont"><b><a href="mymessages-step11.php?id=<?=$adminMessages['id'];?>"><?=$adminMessages['admin_subject'];?></a></b></td>
<td align="center" class="smallfont"><?=$adminMessages['post_date'];?></td>
<td align="center" class="smallfont">n/a</td>
</tr>
<? } ?>
<!-- END OF THIS SHOWS MESSAGES FROM ADMIN -->

<!-- THIS SHOWS QUESTIONS FROM BIDDERS AND BUYERS -->
<tr class="c5">
<td colspan="4" background="images/pixel.gif"><img src="images/pixel.gif" width="1" height="1"></td>
</tr>
<tr bgcolor="#CAE4FF">
<td colspan="4" align="center" class="smallfont">Questions from Bidders/Buyers.</td>
</tr>
<? while ($messages = mysql_fetch_array($getOpenMessages)) { ?>
<input type="hidden" name="ownerid[]" value="<?=$_SESSION['memberid'];?>">
<input type="hidden" name="buyerid[]" value="<?=$messages['buyer_id'];?>">

<tr class="<? echo (($count++)%2==0) ? "c2":"c3"; ?>">
<td align="center" class="smallfont"><?=$messages['buyer_name'];?></td>
<td align="center" class="smallfont"><b><a href="mymessages-step1.php?id=<?=$messages['id'];?>"><?=$messages['item_name'];?></a></b>
<? if ($messages['question_answered']==0) { ?>
<img src="images/check-mark-red.gif" width="20" height="18">
<? } else { ?>
<img src="images/check-mark-green.gif" width="20" height="18">
<? } ?>

<? if ($messages['put_in_auction']==0) { ?>
&nbsp;
<? } else { ?>
<img src="images/check-mark-blue.gif" width="20" height="18">
<? } ?>

</td>
<td align="center" class="smallfont"><?=$messages['post_date'];?></td>
<td align="center" class="smallfont"><input name="delete[]" id="delete[]" type="checkbox" value="<?=$messages['id'];?>"></td>
</tr>
<? } ?>

<? if (($nbOpenMessages)>0) { ?>
<tr align="right" bgcolor="#BBBBBB" class="smallfont">
<td colspan="4"><input name="removeQuestion" type="submit" id="removeQuestion" value="Delete"></td>
</tr>
</table>
<? } ?>
</form>
<!-- END OF THIS SHOWS QUESTIONS FROM BIDDERS AND BUYERS -->

<!-- THIS SHOWS ANSWERS FROM SELLERS -->
<form action="mymessages.php" method="post" name="mymessages2" >
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="contentfont">
<tr class="c5">
<td colspan="4" background="images/pixel.gif"><img src="images/pixel.gif" width="1" height="1"></td>
</tr>
<tr bgcolor="#CAE4FF">
<td colspan="4" align="center" class="smallfont">Answers from Sellers.</td>
</tr>
<? $getAnswerMessagez = mysql_query("SELECT * FROM my_messages WHERE buyer_id='".$SESSION['memberid']."' AND is_this_question=0 AND answer_read=0"); ?>
<? while ($answerMessagez = mysql_fetch_array($getAnswerMessagez)) { ?>
<input type="hidden" name="ownerid[]" value="<?=$SESSION['memberid'];?>">
<input type="hidden" name="sellerid[]" value="<?=$answerMessagez['seller_id'];?>">
<tr class="<? echo (($count++)%2==0) ? "c2":"c3"; ?>">
<td width="15%" align="center" class="smallfont"><?=$answerMessagez['seller_name'];?></td>
<td width="60%" align="center" class="smallfont"><b><a href="mymessages-step12.php?id=<?=$answerMessagez['id'];?>"><?=$answerMessagez['item_name'];?></a></b></td>
<td width="15%" align="center" class="smallfont"><?=$answerMessagez['answer_date'];?></td>
<td width="10%" align="center" class="smallfont"><input name="delete[]" id="delete[]" type="checkbox" value="<?=$answerMessagez['id'];?>"></td>
</tr>
<? } ?>

<? if (($getAnswerMessagez)>0) { ?>
<tr align="right" bgcolor="#BBBBBB" class="smallfont">
<td colspan="4"><input name="removeAnswers" type="submit" id="removeAnswers" value="Flag As Read"></td>
</tr>
</table>
<? } ?>
</form>
<!-- END OF THIS SHOWS ANSWERS FROM SELLERS -->

If someone is interested in helping and requires more information.. you can email [e-mail]

Thanks.

[RossC0]

Hi,

Thats a chunk of code - help me out here what / wheres the problem ?

does it error? - if so where?

[auctiontrader]

hi,

no there is no error.. i don't know what is wrong.

the problem is the messages are not deleted from the database.
eg.. you tick the message in the push delete, it says "deleting message" reloads the page and the message is still there.