Edit News

[Peosan]

I have this edit news script, everything works, except when I press submit.

When I press it, it shows it's been successfully updates, however, the database is unchanged.

 

I've tried but no success. :')

Here's the code:

 

<?php 
include("include/database.php");

	if (isset($_POST['submitted'])) {
		$title = $_POST['title'];
		$newstext = $_POST['newstext'];
		$posted = $_POST['posted'];

		$query2 = "UPDATE news_post SET title='$title', newstext='$newstext', posted='$posted' WHERE id='$id'";
		$r2 = mysqli_query($dbc, $query2);
		echo'<h3>Thank you! The news has been UPDATES successfully! Please wait (3) seconds while we throw you to the index!'; 
		echo "<meta http-equiv=Refresh content=4;url=index.php>";
	}
		elseif(isset($_GET['id'])) {
		$query = "SELECT * FROM news_post WHERE id='$_GET[id]'";
		$r = mysqli_query($dbc, $query);
			while($myrow = mysqli_fetch_assoc($r)) {
				$title = $myrow["title"];
				$newstext = $myrow["newstext"];
				$posted = $myrow["posted"];
?>

[kenrbnsn]

Where is $id being set before this statement:

<?php
$query2 = "UPDATE news_post SET title='$title', newstext='$newstext', posted='$posted' WHERE id='$id'";
?>

 

Ken

[Peosan]

Ahhh, thanks Ken!

 

I added

$id = $_POST['id']; 

before the query and now it works like a charm.

 

Thanks alot. <3  :-)