Edit Page

[muddy9494]

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

[GingerRobot]

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?

[muddy9494]

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.

[muddy9494]

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.';

}

?>