Delete Record But Have an err0r

Question

luweegee 0 Junior Poster in Training

13 Years Ago

The function of delete record is working, but you need to double click the Delete Button to successfuly delete the record...can anyone help me pls

<?php
$con = mysql_connect("localhost","root","");
$sql = mysql_select_db("luweegee",$con);
$sel = mysql_query("SELECT * FROM resume");

?>
<html>
	  <body>
	  <table border=1 align='center' width=800 cellpadding=20 cellspacing=0>
	 <tr>
	<td colspan=2><h1>Delete Record</h1>
	</td>
	</tr>

<tr>
<td>
<ul>
<a href='View.php'><li>View Record</li></a>
<a href='Add.php'><li>Add Record</li></a>	
<a href='Edit.php'><li>Edit Record</li></a>
<a href='Delete.php'><li>Delete Record</li></a>
</u>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</td>


<td>
<table border=2 width=550 cellpadding=7 cellspacing=0>

<?php

	for($x=0;$x<=100;$x++)
		{
			if($_POST[del.$x])
			{
			$delete = mysql_query("DELETE FROM resume WHERE id=$x");
			echo "record has been deleted";
			}
			}

echo "<table border=0 align='center' width=>
<form method='post' action='View.php'>
<tr>
<td><center>Name</center></td>
<td><center>Age</center></td>
<td><center>Sex</center></td>
<td><center>Mobile</center></td>
<td><center>Action</center></td>
</tr>";

while($data=mysql_fetch_array($sel))
		{
			echo "
			<tr>
			<td><center>$data[name]</center></td>
			<td><center>$data[age]</center></td>
			<td><center>$data[sex]</center></td>
			<td><center>$data[mobile]</center></td>
			<td><input type='submit' value='Remove' name='del$data[id]'></td>
			</tr>";
		}






echo "</table>";
?>


<tr>
<td colspan=2 align='center'>
Copyright&copy;2011,
</tr>
</td>
</table>
</body>
</html>

php

Edited 13 Years Ago by luweegee because: n/a

3 Contributors
6 Replies
163 Views
22 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by luweegee

smantscheff 265 Veteran Poster

13 Years Ago

DELETE the record before you SELECT it, otherwise it will appear in the result list of the select (line 4) before your delete in line 42 kills it.

smantscheff 265 Veteran Poster

13 Years Ago

You need to click twice because your action sequence is wrong. Change it and you will have to click once only.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

luweegee 0 Junior Poster in Training · Answer 1 · 2011-02-08T23:17:30+00:00

DELETE the record before you SELECT it, otherwise it will appear in the result list of the select (line 4) before your delete in line 42 kills it.

I think u did not understand...i mean this code is working as i said before i can delete record normally but u need to click twice the DELETE button...what i want is 1 click then poof delete record...sorry sir i did not get what your point here peace ^^

y2kshane -2 Light Poster · Answer 2 · 2011-02-09T01:17:59+00:00

totally agree with smantscheff

u use select sql command to query the resume table @ line 4
then delete record in the resume table @ line 42
and @line57 u display the result($sel) that u get from select sql command @line 4

actually what happen in here is when u click the Delete Button record is delete successfuly. but u display the result(which is contain in $sel variable ) that u created in line4 .

u have to delete the record before the select query or query after the delete

hope this will help u :)

y2kshane -2 Light Poster · Answer 3 · 2011-02-09T01:25:59+00:00

use this script

<?php
    $con = mysql_connect("localhost","root","");
    $sql = mysql_select_db("luweegee",$con);
   
     
    ?>
    <html>
    <body>
    <table border=1 align='center' width=800 cellpadding=20 cellspacing=0>
    <tr>
    <td colspan=2><h1>Delete Record</h1>
    </td>
    </tr>
     
    <tr>
    <td>
    <ul>
    <a href='View.php'><li>View Record</li></a>
    <a href='Add.php'><li>Add Record</li></a>
    <a href='Edit.php'><li>Edit Record</li></a>
    <a href='Delete.php'><li>Delete Record</li></a>
    </u>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    </td>
     
     
    <td>
    <table border=2 width=550 cellpadding=7 cellspacing=0>
     
    <?php
     
    for($x=0;$x<=100;$x++)
    {
    if($_POST[del.$x])
    {
    $delete = mysql_query("DELETE FROM resume WHERE id=$x");
    echo "record has been deleted";
    }
    }
     
    echo "<table border=0 align='center' width=>
    <form method='post' action='View.php'>
    <tr>
    <td><center>Name</center></td>
    <td><center>Age</center></td>
    <td><center>Sex</center></td>
    <td><center>Mobile</center></td>
    <td><center>Action</center></td>
    </tr>";


    $sel = mysql_query("SELECT * FROM resume");
     
    while($data=mysql_fetch_array($sel))
    {
    echo "
    <tr>
    <td><center>$data[name]</center></td>
    <td><center>$data[age]</center></td>
    <td><center>$data[sex]</center></td>
    <td><center>$data[mobile]</center></td>
    <td><input type='submit' value='Remove' name='del$data[id]'></td>
    </tr>";
    }
     
     
     
     
     
     
    echo "</table>";
    ?>
     
     
    <tr>
    <td colspan=2 align='center'>
    Copyright&copy;2011,
    </tr>
    </td>
    </table>
    </body>
    </html>

luweegee 0 Junior Poster in Training · Answer 4 · 2011-02-09T10:59:55+00:00

use this script

<?php
    $con = mysql_connect("localhost","root","");
    $sql = mysql_select_db("luweegee",$con);
   
     
    ?>
    <html>
    <body>
    <table border=1 align='center' width=800 cellpadding=20 cellspacing=0>
    <tr>
    <td colspan=2><h1>Delete Record</h1>
    </td>
    </tr>
     
    <tr>
    <td>
    <ul>
    <a href='View.php'><li>View Record</li></a>
    <a href='Add.php'><li>Add Record</li></a>
    <a href='Edit.php'><li>Edit Record</li></a>
    <a href='Delete.php'><li>Delete Record</li></a>
    </u>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    <br>
    </td>
     
     
    <td>
    <table border=2 width=550 cellpadding=7 cellspacing=0>
     
    <?php
     
    for($x=0;$x<=100;$x++)
    {
    if($_POST[del.$x])
    {
    $delete = mysql_query("DELETE FROM resume WHERE id=$x");
    echo "record has been deleted";
    }
    }
     
    echo "<table border=0 align='center' width=>
    <form method='post' action='View.php'>
    <tr>
    <td><center>Name</center></td>
    <td><center>Age</center></td>
    <td><center>Sex</center></td>
    <td><center>Mobile</center></td>
    <td><center>Action</center></td>
    </tr>";


    $sel = mysql_query("SELECT * FROM resume");
     
    while($data=mysql_fetch_array($sel))
    {
    echo "
    <tr>
    <td><center>$data[name]</center></td>
    <td><center>$data[age]</center></td>
    <td><center>$data[sex]</center></td>
    <td><center>$data[mobile]</center></td>
    <td><input type='submit' value='Remove' name='del$data[id]'></td>
    </tr>";
    }
     
     
     
     
     
     
    echo "</table>";
    ?>
     
     
    <tr>
    <td colspan=2 align='center'>
    Copyright&copy;2011,
    </tr>
    </td>
    </table>
    </body>
    </html>

Thanks sir y2kshane this code is really work... more people need your help cheers :D