Guteman Posted March 8, 2006 Share Posted March 8, 2006 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--]<? include("config.php");//If cmd has not been initializedif(!isset($cmd)) { //display all the news $result = mysql_query("select * from news order by id"); //run the while loop that grabs all the news scripts while($r=mysql_fetch_array($result)) { //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"> </form> <? } ?><? 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."; }}?>[/quote] Link to comment https://forums.phpfreaks.com/topic/4464-news-edit-issue/ Share on other sites More sharing options...
Guteman Posted March 8, 2006 Author Share Posted March 8, 2006 someone please help. Link to comment https://forums.phpfreaks.com/topic/4464-news-edit-issue/#findComment-15530 Share on other sites More sharing options...
lessthanthree Posted March 8, 2006 Share Posted March 8, 2006 What happens if you echo out $id before you print the <a href....? Link to comment https://forums.phpfreaks.com/topic/4464-news-edit-issue/#findComment-15539 Share on other sites More sharing options...
Guteman Posted March 8, 2006 Author Share Posted March 8, 2006 Problem is fixed. Thank you! Link to comment https://forums.phpfreaks.com/topic/4464-news-edit-issue/#findComment-15546 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.