One important note that is

Greg K — Tue, 13 Jul 2010 15:29:51 +0000

One important note that is before this were to go into production (intended for public use), you need to validate/cleanse the data coming into $_POST.

(think what would happen if I entered the following for MAKE:

hello'; drop table data;

Now when it submits, the code as is will delete your entire table.

-Greg

Hi Johneva, I corrcet your

sandeep Kumar — Tue, 13 Jul 2010 06:42:47 +0000

Hi Johneva,
I corrcet your code, You Just try with them,

Edit Form
Control Panel

<?php
if(isset($_POST['cmd']) == "edit")
{
//connect to mysql
//change user and password to your mySQL name and password
$connection=mysql_connect("localhost", "johnmev_user1", "Pass1");
   
//select which database you want to edit
mysql_select_db("cp",$connection);

//If cmd has not been initialized

   //display all the cars
   $result = mysql_query("select * from data order by id",$connection);
  
   //run the while loop that grabs all the cars
   while($r=mysql_fetch_array($result))
   {
      //grab the model and the ID
      $make=$r["make"];//take out the model    
      $model=$r["model"];//take out the model
      $id=$r["id"];//take out the id
    
     //show the make and model a link in a list
      echo "<li>";
      echo "<a href='edit.php?cmd=edit&id=$id'>Edit - $make $model</a>";
      echo "</li>";
    }
}
?>

<?php
if(isset($_POST['cmd']) == "edit")
{
   
      $id = $_GET["id"];
      $sql = " SELECT * FROM data WHERE id = '$id' ";
      $result = mysql_query($sql);       
      $myrow = mysql_fetch_array($result);
?>

Make:
Model:
Spec:
7 Month Rental:
12 Month Rental:
18 Month Rental:

<?php
 }
    
   if ($_POST["$submit"])
   {
      $make = $_POST["make"];
      $model = $_POST["model"];
      $spec = $_POST["spec"];
      $seven = $_POST["seven"];
      $twelve = $_POST["twelve"];
      $eighteen = $_POST["eighteen"];


      $sql = ("UPDATE data SET                         
                              make='$make',
                              model='$model',
                              spec='$spec',
                              seven='$seven',
                              twelve='$twelve',
                              eighteen='$eighteen' 
                              WHERE id='$id' ", $connection );

      $result = mysql_query($sql);
      echo "Thank you! Information updated.";
   }
}
?>

and still you face problem then, you mention here. & I'll try to solve them, now Enjoy with that code. ):

I think I see a minor problem

cmoyer — Sun, 21 Feb 2010 02:41:31 +0000

I think I see a minor problem in your inline php
ex:

Make:<input type="text" name="make" value="<?php echo $myrow["make"] ?>" size=30 /><br />

you need a semi colon after the echo $myrow["make"]
ex:

Make:<input type="text" name="make" value="<?php echo $myrow["make"]; ?>" size=30 /><br />

Hope that helps

So...what's the problem?

pr0gr4mm3r — Sat, 13 Feb 2010 14:49:51 +0000

So...what's the problem?