Jump to content


Photo

Deleting a row from the database. *SOLVED*


  • Please log in to reply
31 replies to this topic

#1 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 04:23 AM

I created a script where users can send messages to eachother back and forth, like a PM type thing. I have it so it displays all the messages in their inbox and has a checkbox that if they check it and press delete it is supposed to delete the message. The problem I am having is it won't delete the message when the click delete. Here is the script:

<?
include 'header.php';

if ($_POST['delete']){
	mysql_query("DELETE * FROM message WHERE messageID='$delete'");
}



print<<<HERE

<form action="inbox.php?action=delete">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE 

receiver='$sid'";
$result= mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete"></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] 

. '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . 

$row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center"><font color="red">' . $row['read'] . '</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="C8F6C8">' . $row['read'] . 

'</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>

The delete boxes and codes are all in different spots in the script, so I thought it would be easier if I just posted the entire script. Any help would be appreciated =D Thanks.

#2 High_-_Tek

High_-_Tek
  • Members
  • PipPipPip
  • Advanced Member
  • 72 posts

Posted 26 July 2006 - 04:33 AM

if ($_POST['delete']){
mysql_query("DELETE * FROM message WHERE messageID='$delete'");
}

to

if ($_POST['delete']){
mysql_query("DELETE * FROM message WHERE messageID='".$_POST['delete']."');
}

#3 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 04:53 AM

High Tek - I switched my code to your code and the screen went blank, so I tried this:

if ($_POST['delete']){
   mysql_query("DELETE * FROM message WHERE messageID='$_POST[delete]'");
}

The screen came back, but it still won't delete the message =(

#4 corbin

corbin
  • Staff Alumni
  • Advanced Member
  • 8,129 posts

Posted 26 July 2006 - 04:58 AM

Try adding echo "<form action=\"\" method=POST>";  above while ($row = mysql_fetch_assoc($result)){
Why doesn't anyone ever say hi, hey, or whad up world?

#5 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 05:33 AM

Corbin - Nope =/ That didn't work either.

#6 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 26 July 2006 - 05:36 AM

post the code you got so far and add the database lol..........


That a terrable way to delete can not beleve it lol..............

just add a link were the delete button is of example

You got to make a link but do the link to suit your needs ok.

echo"<a href='delete.php'?playerID=$row[senderID]&cmd=delete'>delete</a>":

delete.php
<?

database connection

if($_GET[cmd]==$delete) {
$query="DELETE * FROM message WHERE playerID=$row[senderID]");

$result_mysql($query);

heder("localtion: back_to_where_ever.php";

}

?>

this is an example only but should work with the correct delete settings and id on the link.

good luck.

my way or the high way lol................
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#7 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 05:49 AM

Code:
<?
include 'header.php';

if ($_POST['delete']){
   mysql_query("DELETE * FROM message WHERE messageID='$_POST[delete]'");
}



print<<<HERE

<form action="inbox.php?action=delete" method="post">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE receiver='$sid'";
$result= mysql_query($sql);

while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete"></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] . '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . $row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center" bgcolor="788D7A"><font color="5D0B0B">' . $row['read'] . '</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="1D221D">' . $row['read'] . '</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>

I don't think there is a need for the database stuff...there should be enough information there.

#8 vinny_bc

vinny_bc
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 26 July 2006 - 05:55 AM

Your checkbox should be of the form:

<input type="checkbox" name="delete[]" value="$messageID">

Then $_POST['delete'] will be an array of checked $messageIDs.
Note: if the user didn't check anything, then calling isset($_POST['delete']) will return FALSE.



#9 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 06:15 AM

Vinny_bc - That didn't work either =/

Here is the updated code:

<?
include 'header.php';

if ($_POST['delete']){
   mysql_query("DELETE * FROM message WHERE messageID='$_POST[delete]'");
}



print<<<HERE

<form action="inbox.php?action=delete" method="post">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE 

receiver='$sid'";
$result= mysql_query($sql);

while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete[]" value='. 

$row['messageID'] .'></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] 

. '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . 

$row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center" bgcolor="788D7A"><font color="5D0B0B">' . $row['read'] . 

'</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="1D221D">' . $row['read'] . 

'</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>


#10 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 26 July 2006 - 06:16 AM

what does the ecohed delete query say please cheers.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#11 vinny_bc

vinny_bc
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 26 July 2006 - 06:21 AM

You will need to change your SQL code from:

if ($_POST['delete']){
  mysql_query("DELETE * FROM message WHERE messageID='$_POST[delete]'");
}

To:

if(isset($_POST['delete'])){
  foreach($_POST['delete'] as $i => $message_id){
    mysql_query("DELETE * FROM message WHERE messageID='$message_id'");
  }
}

Remember, $_POST['delete'] is now an array and not a scalar value.

If this doesn't work either, can you please post the HTML that is output by your script - there may still be issues with how your form is being output as HTML.

Cheers


#12 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 26 July 2006 - 06:26 AM

correct

i want to see your delete query

the where cluase might and think is wrong ok.

you can make it a lot simple then above use a session example

<? session_start();

$id=$_SESSION['id']=$row['message_id'];

then in the delete where clause use this ok

if(isset($_POST['delete'])){

    mysql_query("DELETE * FROM message WHERE messageID='$id'");
  }
}




Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#13 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 06:48 AM

vinney_bc - That didn't work either =/

redarrow - I don't think I want to do the session idea. It is to confusing, and I already have sessions set up in the header file.

New code:

<?
include 'header.php';

if(isset($_POST['delete'])){
  foreach($_POST['delete'] as $i => $message_id){
    mysql_query("DELETE * FROM message WHERE messageID='$row[messageID]'");
  }
}



print<<<HERE

<form action="inbox.php?action=delete" method="post">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE 

receiver='$sid'";
$result= mysql_query($sql);

while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete[]" value='. 

$row['messageID'] .'></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] 

. '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . 

$row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center" bgcolor="788D7A"><font color="5D0B0B">' . $row['read'] . 

'</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="1D221D">' . $row['read'] . 

'</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>

What do you guys mean by my 'delete query'? Is it now in the script?

#14 vinny_bc

vinny_bc
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 26 July 2006 - 06:57 AM

You didn't follow my code exactly :)

You had:

if(isset($_POST['delete'])){
  foreach($_POST['delete'] as $i => $message_id){
    mysql_query("DELETE * FROM message WHERE messageID='[color=red][b]$row[messageID][/b][/color]'");
  }
}

Whereas I had:

if(isset($_POST['delete'])){
  foreach($_POST['delete'] as $i => $message_id){
    mysql_query("DELETE * FROM message WHERE messageID='[b]$message_id[/b]'");
  }
}



#15 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 05:06 PM

Nope =/ That didn't work either.

#16 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 26 July 2006 - 09:36 PM

Anyone else have any ideas?

#17 vinny_bc

vinny_bc
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 26 July 2006 - 11:14 PM

can you post your code as it stands at the moment.
And can you also give us a sample of your DB.

#18 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 27 July 2006 - 04:41 AM

My code is where exactly how it is when I first posted. There were so many ideas flying around, and I couldn't get any to work, so I guess we will have to start fresh again. So here is the code again:

<?
include 'header.php';

if ($_POST['delete']){
	mysql_query("DELETE * FROM message WHERE messageID='$delete'");
}



print<<<HERE

<form action="inbox.php?action=delete">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE 

receiver='$sid'";
$result= mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete"></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] 

. '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . 

$row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center"><font color="red">' . $row['read'] . '</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="C8F6C8">' . $row['read'] . 

'</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>

Here is the database information:

Table name - message

Fields:
messageID
sender
receiver
senderID
subject
body
time
read

#19 sanfly

sanfly
  • Members
  • PipPipPip
  • Advanced Member
  • 344 posts
  • LocationNew Zealand

Posted 27 July 2006 - 05:11 AM

Okay, I see two things wrong here.  Of course I could be completely wrong on either of these, but anyway....


1.  In the delete query

mysql_query("DELETE * FROM message WHERE messageID='$delete'");

you dont need the *, infact if i remember correctly, it prevents the delete query from working. 

2.  In the checkbox to delete, I dont think your passing the value for the messageID

<input type="checkbox" name="delete">

I dont use checkboxes that often, I may be wrong here, but try adding the messageID as the value

<input type="checkbox" name="delete" value="' . $row['messageID'] . '">

Also, Im assuming this is generating a list of messages, and you can select more than one to delete?  If this is the case, you will need to change the delete checkbox to this:

<input type="checkbox" name="delete[]" value="' . $row['messageID'] . '">

([] after the name, puts the values into an array)

and then when you submit the form, you need to extract the values as an array, and use either a for or foreach loop (I always have trouble with foreach, and forget when it can and cant be used so it might be better to use count() to find out how many items in the array, then use a for loop) to delete each one

ROUGH EXAMPLE, WILL NEED REFINING, IS ONLY HERE TO GIVE YOU AN IDEA:

if ($_POST['delete']){
	$delMessages = $_POST['delete'];  // $delMessages or maybe $delMessages[] ?????
	$num = count($delMessages);
	for($i = 0; $i < $num; $i++){
		$messageID = $delMessages[$i];  // not so sure on this....
		mysql_query("DELETE FROM message WHERE messageID = '$messageID'");
	}
}

If you're not part of the solution, you're part of the precipitate

#20 pocobueno1388

pocobueno1388
  • Members
  • PipPipPip
  • Advanced Member
  • 3,369 posts
  • LocationPalm Beach, Florida

Posted 27 July 2006 - 05:52 AM

Sanfly - I put in everything you had put, and I couldn't get it to work. Here is the code with all your stuff added:

<?
include 'header.php';

if ($_POST['delete']){
	$delMessages = $_POST['delete'];  // $delMessages or maybe $delMessages[] ?????
	$num = count($delMessages);
	for($i = 0; $i < $num; $i++){
		$messageID = $delMessages[$i];  // not so sure on this....
		mysql_query("DELETE FROM message WHERE messageID = '$messageID'");
	}
}



print<<<HERE

<form action="inbox.php?action=delete" method="post">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE 

receiver='$sid'";
$result= mysql_query($sql);

while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete[]" value="' . 

$row['messageID'] . '"></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] 

. '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . 

$row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center" bgcolor="788D7A"><font color="5D0B0B">' . $row['read'] . 

'</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="1D221D">' . $row['read'] . 

'</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>

Here is the original code again, if anyone else would like to give it a shot:

<?
include 'header.php';

if ($_POST['delete']){
   mysql_query("DELETE * FROM message WHERE messageID='$_POST[delete]'");
}



print<<<HERE

<form action="inbox.php?action=delete" method="post">
<center><h2>INBOX</h2><p>
<h3><a href="sendmessage.php">Send a message</a></h3>
</center>

<table border=1 bordercolor="black" width="85%" align="center">

<th align="center" bgcolor="49614A">Delete?</th>
<th align="center" bgcolor="49614A">Subject</th>
<th align="center" bgcolor="49614A">From</th>
<th align="center" bgcolor="49614A">Time</th>
<th align="center" bgcolor="49614A">Read?</th>

</tr>
HERE;

$sql1 = "SELECT `playerID` FROM players WHERE playerID='$row[senderID]'";
$result1= mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);

$sql = "SELECT `messageID`, `subject`, `sender`, `time`, `read`, `senderID` FROM message WHERE receiver='$sid'";
$result= mysql_query($sql);

while ($row = mysql_fetch_assoc($result)){
        echo '<td align="center" bgcolor="788D7A"><input type="checkbox" name="delete"></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="sendmessage.php?id=' . $row['messageID'] . '">' .  $row['subject'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A"><a href="viewprofile.php?profileid=' . $row['senderID'] . '">' .  $row['sender'] . '</a></td>';
        echo '<td align="center" bgcolor="788D7A">' . $row['time'] . '</td>';

if ($row['read'] == no){
        echo '<td align="center" bgcolor="788D7A"><font color="5D0B0B">' . $row['read'] . '</font></td></tr>';
} else {
echo '<td align="center" bgcolor="788D7A"><font color="1D221D">' . $row['read'] . '</font></td></tr>';

}//end if
}//end while


print<<<HERE

</table>
<p>

<table width="85%" align="center">

<td align="left"><input type="submit" name="delete" value="delete"></td>
</table>
</form>

HERE;

?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users