[Resolved] [Resolved] Mysql - Delete news, with repeating region

shifty18

ok so i have an admin section, 2 boxes Tital and content, adds fine displays in news.php with the dynamic text and repeat regoin.

Ok now i want a displaynews.php for admin so he can change (i.e for spelling mistakes) or delte, now if i jsut have it as a globle setting, i.e its a button that will be reapeated with each row retured, how do i make it so the delte button for story 5 wil delete story 5 and not story 1...if anyone can understand where i am comming from, thanks for the help

Chris

nunomira

hi,

the table that stores the news, should have, at least, a column for the news, and a column with a unique id.

so, in your query, you fetch both the text and that unique id
you show the text, and a delete button next to it
this button has the id associated, for example:

echo ("<a href=\"delete.php?id=$id\">delete news number $id</a>");
// where id is the variable that comes from the database

in delete.php, you have something like this:

$id = $_GET['id'];

// connect to database...

$query = "delete from mytable where id='$id'";

shifty18

thnks man, didnt think of that, mind you had been doing this site for about 5 hours by then lol

thanks

shifty18

ok it doesnt seam to want to work for me, ok so this is my section from editnews.php

<td><font color="#FFFFFF">ID Number:</font></td>
<td><font color="#FFFFFF"><?php echo $row_Recordset1['IDNumber']; ?></font></td>
<td width="17%" rowspan="3"><?php echo ("<a href=\"DeleteNews.php?IDNumber=$IDNumber\">delete news number $IDNumber</a>"); ?></td>

Ok now it displays everything but the $IDNumber varible

Now deletenews.php is simply

<?php
require_once('../Connections/admin.php');
$_POST['IDNumber'];
$query = "DELETE FROM news WHERE IDNumber='$IDNumber'";
header ("Location: editnews.php");
?>

if i dont include my header file, i simply get a blank white page with this URL

http://localhost/rainham84/website/DeleteNews.php?IDNumber=

Any clues

Thanks

nunomira

that line should work, if the variable $IDNumber exists

DeleteNews.php?IDNumber=$IDNumber

which I don't think it does, because in the previous line, you have:

echo $row_Recordset1['IDNumber'];

i.e., you have to do exactly the same:

DeleteNews.php?IDNumber=$row_Recordset1['IDNumber']

shifty18

ok so i have everything working along those lines,

But now for the DoDelteNews.php

I have

$id = $_GET ['id'] 

//connect to db 

$query = "DELETE FROM howardttc WHERE id=$row_Recordset1['id']";

Now the id= bit should it be that, or should it be what i stated at the top of the page or should it be $id as i made $id with $_GET['id']

thanks