Code: Select all
<tr>
<td width="10%" bgcolor="<?php echo $row_color; ?>">
<?php echo $row["NEWS_DATE2"]; ?></td>
<td width="30%" bgcolor="<?php echo $row_color ?>"><b>
<?php echo $row["NEWS_TITLE"];?></b></td>
<td width="50%" bgcolor="<?php echo $row_color ?>">
<?php echo $row["NEWS_DESC"];?></td>
<td width="10%" bgcolor="<?php echo $row_color ?>">
<a class="menuLink" href="/prep_admin/delete_news.php?d_id=<?php echo $row["DB_ID"]; ?>">delete</a></td>
</tr>I cant figure out what my delete_news.php would be
This is not working
Code: Select all
<?php
$con = mysql_connect("*******","********","********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("**********", $con);
$sql="DELETE FROM PREP_NEWS WHERE DB_ID = $d_ID ";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
mysql_close($con) ;
header('Location:http://*************/prep_admin/display_news.php');
?>