Jump to content


This topic is now archived and is closed to further replies.


News-Edit Issue

Recommended Posts

Alright guys, here is my issue. I cannot get [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<a href='edit.php?cmd=edit&id=$id'>[/quote] to work properly. Specificly the $id part. Its not seeing the id in the news through the sql. I know the rest of this works because I can enter an id number after the link and it works. So its gotta be that variable. Can you please help me out?

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<?


//If cmd has not been initialized
//display all the news
$result = mysql_query("select * from news order by id");

//run the while loop that grabs all the news scripts
//grab the title and the ID of the news
$title=$r["title"];//take out the title
$id=$r["id"];//take out the id

//make the title a link
echo "<a href='edit.php?cmd=edit&id=$id'>$title - Edit</a>";
echo "<br>";
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
if (!isset($_POST["submit"]))
$id = $_GET["id"];
$sql = "SELECT * FROM news WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

<form action="edit.php" method="post">
<input type=hidden name="id" value="<?php echo $myrow["id"] ?>">

Title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["title"] ?>" SIZE=30><br>
Message:<TEXTAREA NAME="message" ROWS=10 COLS=30><? echo $myrow["message"] ?></TEXTAREA><br>
Who:<INPUT TYPE="TEXT" NAME="who" VALUE="<?php echo $myrow["who"] ?>" SIZE=30><br>

<input type="hidden" name="cmd" value="edit">

<input type="submit" name="submit" value="submit">


<? } ?>
if ($_POST["$submit"])
$title = $_POST["title"];
$message = $_POST["message"];
$who = $_POST["who"];

$sql = "UPDATE news SET title='$title',message='$message',who='$who' WHERE id=$id";
//replace news with your table name above
$result = mysql_query($sql);
echo "Thank you! Information updated.";

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.