// The following script will allow to delete an entry immediately from your database. The script is in a table for ease of use and lists all entries in your database. One click on the link and it's deleted using the script delete_links2.php


-----------------------------------------------------------------------------------------------------

<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td bgcolor="#99CC00"><font size="2" face="Arial, Helvetica, sans-serif"><strong>DELETE 
              A PROPERTY</strong></font></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><center>
  <strong><font face="Verdana, Arial, Helvetica, sans-serif" size="1"> <?php print(date("F d, Y")); ?></font></strong> 
  <br>
  
  <?php
include "config.php";

$db = mysql_connect ($Host, $User, $Password);
mysql_select_db ($DBName) or die ("Cannot connect to database");
/* We have now connected, unless you got an error message */
/* Lets extract the data (news) from the database */
/* $query = "SELECT id, title, news, images, author, date FROM houses ORDER BY id DESC LIMIT 10";


if(!$rowstart) $rowstart=0;
$query = "SELECT id, title, news, images, author, date, areas, towns, zip FROM houses ORDER BY id DESC LIMIT $rowstart,10";
$result = mysql_query($query);
/* Here we fetch the result as an array */
while($r=mysql_fetch_array($result))
{  
/* This bit sets our data from each row as variables, to make it easier to display */
    $id=$r["id"];
	$title=$r["title"];
    $news=$r["news"];
	$images=$r["images"];
    $author=$r["author"];
    $timestamp = strtotime($r['date']);
	$date = date('d-m-Y',$timestamp);
	$areas=$r["areas"]; 
	$towns=$r["towns"]; 
	$zip=$r["zip"]; 
		  
/* Now lets display the Houses */
    echo "<TABLE border = '1' cellspacing = '0' cellpadding ='0' width = '75%' align='center'>
    
	
	<TR>
        <TD bgcolor=\"#99CCFF\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\"><b>House id $id </b><br>$title</font></TD>
    </TR>
	
	 		<TR>
        <TD><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\"><A HREF=\"delete_links2.php?id=$id\">delete</A> <font size=\"1\" face=\"Verdana, Arial, Helvetica, sans-serif\" color=\"#ff0000\"><b>*</b> </font></font></TD>
							
    </TR>
					
    </TABLE><br>";
}
?>
</center>
<center><strong><font color="#FF0000" size="1" face="Verdana, Arial, Helvetica, sans-serif">* 
If selected this item will be deleted immediately, so be careful!</font></strong></center><br>

<?php

//previous & next links

$result1 = mysql_query("select * from houses limit $rowstart,10");
$result2 = mysql_query("select * from houses");

//put all the code here for running the script itself using $result1 in the while loop

if ($rowstart>$numrows) 
{?>
<center><A HREF="<? $php_self ?>?rowstart=<? echo $rowstart-10;?>"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> < Previous Page</font></A></center>
<?}?>
 
<?
$numrows=mysql_num_rows($result2);
if($rowstart+10<$numrows) 
{?>
<center><A HREF="<? $php_self?>?rowstart=<?echo $rowstart+10 ;?>"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"> Next Page ></font></A></center>
<? } ?>

<?php

mysql_close($db);

?>
<br>

  </td>
          </tr>
        </table>

----------------------------------------------------------------------------------------

//The code for delete_links2.php is as follows:

----------------------------------------------------------------------------------------

<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><?php

//Connect to DB
include "config.php";

$db = mysql_connect ($Host, $User, $Password);
mysql_select_db ($DBName) or die ("Cannot connect to database");


if($id)

// If $delete is present show this :

{

// This query deletes from our table (houses) where the title is $delete, which is the title you entered in the form.
$sql_query = "DELETE FROM houses WHERE id=$id";


$result = mysql_query($sql_query);

echo "You deleted the following House Listing : " . $id ;


}
else

// Otherwise, show this :
{
echo ("This item was not deleted.");
}


?>

<br></td>
          </tr>
        </table>

---------------------------------------------------------------------