muddy9494 Posted June 13, 2009 Share Posted June 13, 2009 ok, i need help making a page. I want a page to be like this. It has a form, and the top of the page is editnews.php?id=x it will GET the id and then in say the title text box it will fetch the name from the row with id x in it. So for example. Row with id 1 has news title "Welcome" it will go to row with id 1 and put the welcome in the textbox. the rest i can get. I know how to make it update it Thanks for the help Link to comment https://forums.phpfreaks.com/topic/162078-edit-page/ Share on other sites More sharing options...
GingerRobot Posted June 13, 2009 Share Posted June 13, 2009 Ok, so it sounds like you know what you want to do. Do you have anything so far? Is there any particular part you're struggling with? Link to comment https://forums.phpfreaks.com/topic/162078-edit-page/#findComment-855254 Share on other sites More sharing options...
muddy9494 Posted June 13, 2009 Author Share Posted June 13, 2009 I know what I want to do but i cant code it. I have a delete function but I have been looking at it to figure out how to basically recode it. Link to comment https://forums.phpfreaks.com/topic/162078-edit-page/#findComment-855257 Share on other sites More sharing options...
muddy9494 Posted June 13, 2009 Author Share Posted June 13, 2009 Here is my Delete News Code <?php //database connection stuff include("mysql.php"); $db = "mysql"; //grab postid from the url $id = intval($_GET['id']); //check if it exists $sql = "SELECT id FROM news WHERE id='$id'"; $result = mysql_query($sql); if(mysql_num_rows($result) == 1){ $delete = "DELETE FROM news WHERE id='$id' LIMIT 1"; //exists, "delete" it if(!mysql_query($delete)) { echo mysql_error(); }else{ include("addliveblog.php"); echo 'Post has been deleted.'; } }else{ //post doesn't exist, or multiple matches (shouldn't have multiple on auto inc ..) include("addliveblog.php"); echo 'No post exists with that post id.'; } ?> Link to comment https://forums.phpfreaks.com/topic/162078-edit-page/#findComment-855259 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.