Jump to content


Photo

DELETE query in sql


  • Please log in to reply
4 replies to this topic

#1 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 25 March 2006 - 07:39 AM

guys,

i need help. i am setting up a CMS for my site. and there's a page
wherein i wanted to delete a specific item...
i can't make it work.
if i click on the delete button, the item is still there.

here is my script for the first page:
=================
<script LANGUAGE="JavaScript">
<!--
function confirmSubmit()
{
var agree=confirm("Do you really want to delete this?");
if (agree)
return true ;
else
return false ;
}
-->
</script>
<table width="475" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<form name="frmUsers" method="POST" action="feedbackdelete.php">
<table width="610" border="1" cellspacing="0" cellpadding="0">
<?
include '../db_connect.php';

$uSql = "SELECT news_title, news_content, news_sender, news_date, newsid FROM news ORDER by news_date DESC";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}
else{
$currentTitle = "";
while($uRow = mysql_fetch_row($uResult)){
if($currentTitle != $uRow[0]) {
$currentTitle = $uRow[0];
echo "<tr><td class='bodytext3'>";
echo "<br>";
echo "<b>$currentTitle</b>";
echo "<br><br>";
echo "</td></tr>";

}?>
<tr>
<td width="606"><table width="612" border="0" cellspacing="0" cellpadding="0">

<tr>
<td width="481"><span class="bodytext">Message:</span><span class="bodytext6">
<?= $uRow[1]?>

</span></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Sender:</span> <i><span class="bodytext6">
<?= $uRow[2]?>
</span></i></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Date posted:</span><span class="bodytext6">
<?= $uRow[3]?>
<input type="hidden" name="nid" value="<?= $uRow[4]?>">
</span></td>
<td width="116"><input name="delete" type="submit" value="Delete Feedback" onclick="return confirmSubmit()" /></td>
</tr>
<tr><td colspan="2" class="bodytext"> -----------------------------------------------------------------------------</td> </tr></table></td></tr>
<?
}
}
?>
</table></form>
</td>
</tr>
</table></td>
</tr>
</table>
===========================
and here is my script for the feedbackdelete.php

===========================
<?
session_start();

if (session_is_registered("username")){

if($_SESSION['user_level'] == 0){

include '../db_connect.php';

$bid = $_POST['nid'];

$dusql="DELETE from news WHERE newsid='$nid'";
mysql_query($dusql) or die("error:".mysql_error());

echo '<script language=javascript>top.location = "feedback.php";</script>';
}
else{
echo '<script language=javascript> alert("You are not authorized to access this page!");top.location = "main.php";</script>';
}
}

else{
echo '<script language=javascript>top.location = "index.php";</script>';
}

?>
======================

hope you can help me with this....
thanks in advance!!!

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 25 March 2006 - 07:45 AM

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?
session_start();

if (session_is_registered("username")){

if($_SESSION['user_level'] == 0){

include '../db_connect.php';

$bid = $_POST['nid'];

$dusql="DELETE from news WHERE newsid='$_POST[nid]'";
mysql_query($dusql) or die("error:".mysql_error());

echo '<script language=javascript>top.location = "feedback.php";</script>';
}
else{
echo '<script language=javascript> alert("You are not authorized to access this page!");top.location = "main.php";</script>';
}
}

else{
echo '<script language=javascript>top.location = "index.php";</script>';
}

?>[/quote]

You didnt use $_POST on the nid by the looks of it mate
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 25 March 2006 - 05:01 PM

bro,

its still not working.
for the $nid its just a typo
normally from my script its
========
<?
session_start();

if (session_is_registered("username")){

if($_SESSION['user_level'] == 0){

include '../db_connect.php';

$nid = $_POST['nid'];

$dusql="DELETE from news WHERE newsid='$nid'";
mysql_query($dusql) or die("error:".mysql_error());

echo '<script language=javascript>top.location = "feedback.php";</script>';
}
else{
echo '<script language=javascript> alert("You are not authorized to access this page!");top.location = "main.php";</script>';
}
}

else{
echo '<script language=javascript>top.location = "index.php";</script>';
}

?>
=====================

hope you can help me fix the problem.
because on my add section, i can successfully add and update items.
its just on the delete section wherein i am getting problems.

thanks!


#4 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 25 March 2006 - 05:23 PM

bro,

please check my script on the first page?
do you think the problem is in the first page?
==============

<script LANGUAGE="JavaScript">
<!--
function confirmSubmit()
{
var agree=confirm("Do you really want to delete this?");
if (agree)
return true ;
else
return false ;
}
-->
</script>

<table width="475" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="455"><table width="624" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<form name="frmnews" method="POST" action="feedbackdelete.php">
<table width="610" border="1" cellspacing="0" cellpadding="0">
<?
include '../db_connect.php';

$uSql = "SELECT news_title, news_content, news_sender, news_date, newsid FROM news ORDER by news_date DESC";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}
else{
$currentTitle = "";
while($uRow = mysql_fetch_row($uResult)){
if($currentTitle != $uRow[0]) {
$currentTitle = $uRow[0];
echo "<tr><td class='bodytext3'>";
echo "<br>";
echo "<b>$currentTitle</b>";
echo "<br><br>";
echo "</td></tr>";

}?>
<tr>
<td width="606"><table width="612" border="0" cellspacing="0" cellpadding="0">

<tr>
<td width="481"><span class="bodytext">Message:</span><span class="bodytext6">
<?= $uRow[1]?>

</span></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Sender:</span> <i><span class="bodytext6">
<?= $uRow[2]?>
</span></i></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Date posted:</span><span class="bodytext6">
<?= $uRow[3]?>
<input type="hidden" name="nid" value="<?= $uRow[4]?>">
</span></td>
<td width="116"><input name="delete" type="submit" value="Delete Feedback" onclick="return confirmSubmit()" /></td>
</tr>
<tr>
<td colspan="2" class="bodytext"> -----------------------------------------------------------------------------</td></tr></table></td></tr>
<?
}
}
?>
</table></form></td></tr></table></td></tr></table>


#5 pixeltrace

pixeltrace
  • Members
  • PipPipPip
  • Advanced Member
  • 577 posts

Posted 25 March 2006 - 06:53 PM

guys,

i think the second page (feedbackdelete.php) is working.
the problem is on the first page (f#@k!) its late that i noticed
that i has already deleted 100 of of 250 items on my database because its deleting
the wrong item. what i mean is,
let say i was supposed to delete item with an id of 104, id 104 will not be deleted
instead id 45 is deleted
i also tried clicking on the other delete button and its deleting the same id (45)
instead of its respective ids.

this is the script on my first page
==========
<script LANGUAGE="JavaScript">
<!--
function confirmSubmit()
{
var agree=confirm("Do you really want to delete this?");
if (agree)
return true ;
else
return false ;
}
-->
</script>
<table width="475" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="455"><table width="624" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="624"><?
include '../db_connect.php';

$uSql = "SELECT news_title, news_content, news_sender, news_date, newsid FROM news ORDER by news_date DESC";
$uResult = mysql_query($uSql, $connection);
if(!$uResult){
echo 'no data found';
}
else{
while($uRow = mysql_fetch_row($uResult)){

?>
<table width="610" border="1" cellspacing="0" cellpadding="0">
<form name="frmnews" method="POST" action="feedbackdelete.php">
<tr>
<td width="606"><table width="612" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="481" class="bodytext3"><?= $uRow[0]?> </td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Message:</span><span class="bodytext6">
<?= $uRow[1]?>
</span></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Sender:</span> <i><span class="bodytext6">
<?= $uRow[2]?>
</span></i></td>
<td width="116">&nbsp;</td>
</tr>
<tr>
<td><span class="bodytext">Date posted:</span><span class="bodytext6">
<?= $uRow[3]?>
<input type="hidden" name="nid" value="<?= $uRow[4]?>">
</span></td>
<td width="116"><input name="delete" type="submit" value="Delete Feedback" onclick="return confirmSubmit()"></td>
</tr>
<tr>
<td colspan="2" class="bodytext"><img src="../images/spacer.gif" width="10" height="15" /></td></tr></table></td></tr>
<?
}
}
?>
</form></table> </td>
</tr>
</table></td>
</tr>
</table>
=========

need help please!!!

thanks!!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users