[Resolved] Listing news and editing

[fean0r]

My admins can post news but I also want them to be able to edit there own posts.

Whats the best way to do this?

Fields

ID
title
date
user
post

Perhaps via ID?

[jayant]

any 'candidate key'
=> any key that is unique or is primary key

'id' should suffice, since it will be a primary key

[fean0r]

Yea but how?

If that user has posted 10 news posts and he wants to edit one?

I can list all the news 1 user has submitted but i cant figure how to select one to edit...

[fean0r]

so far..

<?
$query_items = "SELECT  *  FROM news ORDER BY ID";
$items = mysql_query($query_items) or die(mysql_error());
$row_items = mysql_fetch_assoc($items);
do {
echo "<BR>";
if($row_items['user'] == $username) {
echo "<form action='ad_ednewsed.php' method='POST'>";
echo "ID:<BR><input type='text' name='ID' size='80' VALUE='";
echo $row_items['ID'];
echo "'><BR><BR>";
echo "Date:<BR><input type='text' name='date' size='80' VALUE='";
echo $row_items['date'];
echo "'><BR><BR>";
echo "Title:<BR><input type='text' name='title' size='80' VALUE='";
echo $row_items['title'];
echo "'><BR><BR>";
echo "Post:<BR><TEXTAREA COLS='60' ROWS='16' WRAP='hard' NAME='post'>";
echo $row_items['post'];
echo "</TEXTAREA>";
echo "'><BR><BR>";
echo "<input type='submit' value='Save Changes'>";
echo "</form>";
}
}
while ($row_items = mysql_fetch_assoc($items));
mysql_close();
?>

This loop shows all the post made by that user.....