PHP - Php Delete And Edit System

Hello,

Not sure how to go about making it so that I can delete and edit a post..

So I am stumped on how to make it to delete and edit post. The key factor for getting the information is the id field. And I am able to get it and display it, but how can I get it to work between all my functions?

This is what I have so far.


<?php
include 'test.php';
function connection()
{

$connection = @mysql_connect('localhost','root','') or die('could not connect to mysql');

$select_db = @mysql_select_db('tutorials') or die('could not connect to database');
}

function delete_post($id)
{

connection();

$query = "DELETE FROM `posts` WHERE `id` = '$id'";

$result = mysql_query($query);
}

function find_posts()
{

connection();

$query = 'SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id`';

$result = mysql_query($query);

while ($row = mysql_fetch_array($result))

{

$id = $row['id'];

echo '<b>' . $row['title'] . '</b>'  .'<a href=/practice/model/posts.php?action=delete>[delete]</a> <a href=/practice/model/posts.php?action=edit>[edit]</a>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';

}

}

function find_post($id)
{

connection();

$query = "SELECT `posts`.`title`, `posts`.`body`, `posts`.`id`, `users`.`username` FROM `posts`, `users` WHERE `posts`.`user_id` = `users`.`id` AND `posts`.`id` = '$id'";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

echo '<b>' . $row['title'] . '</b>' . '<br/>';

echo $row['body'] . '<br/>';

echo $row['username'] . '<p>';
}

function create_post()
{

connection();

$title = $_POST['title'];

$body = $_POST['body'];

$query = "INSERT INTO `posts` SET `title` = '$title', `body` = '$body', `created_at` = NOW(), `user_id` = 53";

$result = mysql_query($query);

if(!$result)

{

echo mysql_error();

}
}

delete_post(7);
find_posts();

?>



<?php
$action = $_GET['action'];


switch ($action)
{

case 'create':

echo 'created' . '<br/>';

create_post();

break;

case 'delete':

echo 'deleted' . '<br/>';

delete_post($id);

break;
}

?>



<form action="/practice/model/posts.php?action=create" method="POST">

<input type="text" col="40" name="title" /><br/>

<textarea cols="30" rows="5" name="body"> </textarea><br/>

<input type="submit" name="submit" />
</form>


So yea, I am not sure how to get the 'id' parameters linked between everything that needs it. Sorry for the vague description, but its kind of hard to put it into words. If you need a more detailed description please let me know and I will try to. Pretty much want to be able to delete and edit my posts.

Thank you!

I want to add text to a file, getting it printed out in index.php and later want to edit/delete per row. I give codes page wise. first the form to take data:
add.php:
Code: [Select]
<?php
?>
<form method="post" action="add_data.php">
<fieldset>
<legend>Student List</legend>
Name : <input type="text" name="uname" /><br>
Content : <input type="text" name="age" />
<br>
<input type="submit" name="submit" value="send" />
</fieldset>
</form>
Next adding text to a file: add_data.php:
Code: [Select]
<?php
$id = 1;
if (file_exists("data.txt"))
{
$fp = fopen("data.txt", 'r');
$str = fread($fp, filesize("data.txt"));
$str_arr = explode("|", $str);
foreach ($str_arr as $rec)
{
if ($rec)
{
$id++;
}
}
}

$mode = (file_exists("data.txt"))? "a" : "w";

$fp = fopen("data.txt", $mode);
$line = $id . "--" . $_POST['uname'] . "--" . $_POST['age'] . "|";
$res = fwrite($fp, $line);
fclose($fp);

header("location:index.php");


?>In the index.php, I'd like to fetch data and edit them per row:
Code: [Select]
<?php
$fp = fopen("data.txt", 'r');
$str = fread($fp, filesize("data.txt"));
$str_arr = explode("|", $str);
echo "<table border='1'>";
echo "<tr><td>ID</td><td>Name</td><td>Age</td><td>Option</td></tr>";

foreach ($str_arr as $rec)
{
if ($rec)
{
$rec_arr = explode("--", $rec);
echo "<tr>";
foreach ($rec_arr as $col)
{
echo "<td>$col</td>";
}
print "<td><a href=\"edit.php?id=$id\">Edit</a>/<a href=\"delete.php?id=$id\">Delete</a></td></tr>";
}
}
echo "</table>";

echo "<a href=\"add.php\">Add Data</a>";

?>


Next I want to Edit per row: edit.php:
Code: [Select]
<?php

$fp = fopen("data.txt", 'r');
$str = fread($fp, filesize("data.txt"));
$str_arr = explode("|", $str);

foreach ($str_arr as $rec)
{
if ($rec)
{
$rec_arr = explode("--", $rec);
$id = $rec_arr[0];
$name = $rec_arr[1];
$age = $rec_arr[2];
if ($id == $_REQUEST["id"])
{
echo "<form action='edit_data.php' method='post'>";
echo "Name :<input type='text' name='uname' value='$name' /><br>";
echo "Age: <input type='text' name='age' value=$age /><br>";
echo "<input type='hidden' name='uid' value=$id />";
echo "<input type='submit' value='Edit'>";
echo "</form>";
}
}
}


?>
From edit.php to edit_data.php where I practically try to edit per row:
Code: [Select]
<?php

$fp = fopen("data.txt", 'r');
$str = fread($fp, filesize("data.txt"));
$str_arr = explode("|", $str);

foreach ($str_arr as $rec)
{
if ($rec)
{
$rec_arr = explode("--", $rec);
$id = $rec_arr[0];
$name = $rec_arr[1];
$age = $rec_arr[2];

if ($id == $_POST['uid'])
{
$new_str = $id . "--" . $_POST['uname'] . "--" . $_POST['age'] . "|";
}
else 
{
$new_str = $id . "--" . $name . "--" . $age . "|"; 
}
}
}

fclose($fp);

$fp = fopen("data.txt", 'w');
fwrite($fp, $new_str);
fclose($fp);


?>
The mechanism is simple. Taking datas from a form, explode them to an array and get them into col/row pattern to edit and delete them. But my problem is when I want to edit in index.php page, specially in this part:
Code: [Select]
print "<td><a href=\"edit.php?id=$id\">Edit</a>
It says, undefined index. But I try to catch this $id in the edit.php page, in this manner, as you see in my code:
Code: [Select]
foreach ($str_arr as $rec)
{
if ($rec)
{
$rec_arr = explode("--", $rec);
$id = $rec_arr[0];
$name = $rec_arr[1];
$age = $rec_arr[2];
if ($id == $_REQUEST["id"])
{
echo "<form action='edit_data.php' method='post'>";
echo "Name :<input type='text' name='uname' value='$name' /><br>";
echo "Age: <input type='text' name='age' value=$age /><br>";
echo "<input type='hidden' name='uid' value=$id />";
echo "<input type='submit' value='Edit'>";
echo "</form>";
}
}
}
Have I done any mistake here? If anyone points out, I'll be obliged.

Hello!

We our creating an admin page to display a list of all the items within a mysql database, these items are within a table called "item". Each item is categorized, these categories are in a table called "category" each category has an ID. There is then a table called "links" which links the items to their category using ID's.

We want to display each item by their category with an edit and delete button. We have it so all the items display with the two buttons in no specific order however we are not too sure how to make it so they all display via their category.

Here is the code we are currently using:
Code: [Select]
<?php

$itemlist = mysql_query("SELECT item.item_name, item.item_description, item.item_image, item.item_price, item.item_id FROM item ORDER BY item.item_id ASC");

$item_count = 0;

?>

<?php while( $row = mysql_fetch_array($itemlist) ){?>

<?php if(($row['item.item_name'] == 1) && (isset($item_count) && $item_count < 1)) { ?>
<?php
$item_count ++;
} ?>

<li class="title">

<h3><?php echo $row['item_name'];?></h3><br />

<form action="ourworkadmin.php" method="get">

<input type="hidden" name="item_id" value="<?php echo $row['item_id'];?>" />
<input name="edit" value="Edit" type="submit" />
<input name="remove" value="Remove" type="submit" />

</form>

</li>

<?php } ?>

</ul> <!--Close-items_list-->
       
 </div>

Any help would be appreciated! Thank you!!!

Hi all.
Here is my scripts which allow user to check multiple rows of data and delete it , but it require select data and click for twice to delete the rows , what should be the error?

Code: [Select]
<form name="frmSearch" method="post" action="insert-add.php">

<table width="600" border="1">
  <tr>
    <th width="50"> <div align="center">#</div></th>
    <th width="91"> <div align="center">ID </div></th>
    <th width="198"> <div align="center">First Name </div></th>
    <th width="198"> <div align="center">Last Name </div></th>
    <th width="250"> <div align="center">Mobile Company </div></th>
    <th width="100"> <div align="center">Cell </div></th>
    <th width="100"> <div align="center">Workphone </div></th>
    <th width="100"> <div align="center">Group </div></th>
  </tr>
    </form>
<?

    echo "<form name='form1' method='post' action=''>";

while($objResult = mysql_fetch_array($objQuery))
{


    echo "<tr>";
    echo "<td align='center'><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$objResult[addedrec_ID]\"></td>";
    echo "<td>$objResult[addedrec_ID] </td>";
    echo "<td>$objResult[FirstName]</td>";
    echo "<td>$objResult[LastName] </td>";
    echo "<td>$objResult[MobileCompany] </td>";
    echo "<td>$objResult[Cell] </td>";
    echo "<td>$objResult[WorkPhone] </td>";
    echo "<td>$objResult[Custgroup] </td>";

   echo "</tr>";

}


 echo "<td colspan='7' align='center'><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"Delete\">";

 if (isset($_POST['delete']) && isset($_POST['checkbox'])) // from button name="delete"
 {
 $checkbox = ($_POST['checkbox']); //from name="checkbox[]"
     $countCheck = count($_POST['checkbox']);

 for($d=0;$d<$countCheck;$d++)
     {
         $del_id  = $checkbox[$d];

 $sql = "DELETE from UserAddedRecord where addedrec_ID = $del_id";

 $result2=mysql_query($sql)  or trigger_error(mysql_error());;;

     }
         if($result2)
     { 
          $fgmembersite->GetSelfScript();
         }
         else
         {
 echo "Error: ".mysql_error();
         }
 }
  echo "</form>";


Thanks for every reply.

 <body>
 
 
  <?php
    

 
       include 'sql.php';
       $query = "SELECT * FROM validation";
       $result = mysqli_query($con , $query);  
       $rows = mysqli_fetch_assoc($result) ;
       $totals = mysqli_num_rows($result) ;
   
      
      
          ?>
            <div id="css">
    <form >
       <table width="80%" border="0" cellpadding="2" cellspacing="2" >
          <caption><h2>Personal Details of Customers</h2></caption>
          <tr class="white">
              <td bgcolor="#330033"> &nbsp; </td>
              <td bgcolor="#330033"> Id Number </td>
              <td bgcolor="#330033"> Full Name </td>
              <td bgcolor="#330033"> Email Address </td>
              <td bgcolor="#330033"> Website </td>
              <td bgcolor="#330033"> Comment </td>
              <td bgcolor="#330033"> Time </td>   
     
</tr>
       <?php while($rows=mysqli_fetch_assoc($result)
       {
       <tr>
      
      <input type="raido" name="ID" value="<?php echo $rows['ID']; ?>"  />
      <td bgcolor="#FFFFCC"><?php  echo $rows['ID'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Name'];?> </td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Email'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo  $rows['Website'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Comment'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Time'];?></td>  
      
       <td>&nbsp;</td>
     
       <td> <a href="delete.php? ID= "$rows[ID]" /"> <input type="submit" name="del" value="Delete" /> </a> &nbsp;                                                     <input type="button" name=   "edit" value="Edit"  /> </td>
       </tr>
              } 

?>
 
     </table>
   </form>
  </div>
 
 </body>

hello dear PHP-Fans - greetings to you - and a happy new year!!


i set up a WAMP-System on my openSuse 11.4 system.  In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running.  Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want  to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

Hi,   I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?   Thank you.

I'm trying to set it so that it will delete an entire populated directory based upon a value in the database then after finishing that to go back and delete that row in the database.  my current code is

Code: [Select]
<?php $page_title = "Central Valley LLC | Photo Addition" ?>
<?php include("header.php"); ?>
<?php include("nav.html"); ?>
<div id="content">
<form action="delprod.php" method="post" enctype="multipart/form-data">
<label for="which">Choose A Product To Remove:</label>
<?php $con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT * FROM Products");
echo "<select name=\"which\">";
while($row = mysql_fetch_array($result))
   {
echo "<option ";
echo "value=\"" . $row['id'] . "\">";
echo $row['Name'] . "</option>";
}
echo "</select>";
mysql_close($con);
?>
<br />
<input type="submit" name="submit" value="Submit" />
</form>
</div><!--#content-->
<?php include("footer.html") ?>

and the delete script

Code: [Select]
<?php
$con = mysql_connect("localhost","phoenixi_cv","centraladmin");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("phoenixi_cvproducts", $con);
$result = mysql_query("SELECT id FROM Products WHERE id=$_POST['which']");
$row = mysql_fetch_array($result)


chdir('assets');
chdir('images');
$mydir = $row . '/';
$d = dir($mydir);
while($entry = $d->read())
{
if($entry!="." && $entry!="..")
{
unlink($_POST['which'] . '/' . $entry);
}
}
rmdir($mydir);
$result = mysql_query("DELETE * FROM Producs WHERE id=$_POST['which']");
?>
Thank you in advance for all your help.  any easier ways of approaching this will be welcome as well

I'm using php edit function to edit an php file online. I think the portion that writing the file is below. My issue is that wherever there's a quote ("), it's automatically adding a slash (\). For example, if I had class="abc", it changes to class=\"abc\". How do I fix this?

Code: [Select]
<?php

$file = $_GET['f'];
$script = $_POST['script'];
      if($file&&$script) {
      $fp=fopen($file, "w");
      fwrite($fp,$script);
      fclose($fp);
   }
?>

hello mates,

I am needing help on editing a line in Flat File Database.

I got it to pull the data i need out by using id but not sure on how i would go about getting it to update the FFD

heres what i got so far


$id2 = $_REQUEST['id'];

 $id = array();
 $username = array();
 $title = array();
 $date = array();
 $message = array();
$lines = file('../news/news.db'); 
foreach($lines as $line){ 
if($id != $id2) {
    $explode = explode("||",$line);
$id = $explode[0]; 
    $username = $explode[1];
$title = $explode[2];
$date = $explode[3];
$message = $explode[4];
} 
}
?>
      <form action="edit_news2.php?id=<?php echo $id; ?>" method="post" name="editnews">
        <table width="100%">
  <tr><td><input name="id" value="<?php echo "$id;" ?>" type="hidden" />UserName:</td><td> <input name="userName" value="<?php echo "$username" ?>" type="text" readonly="true"  /></td></tr>
          <tr><td>News Title:</td><td> <input name="title" type="text" value="<?php echo "$title"; ?>" /></td></tr>
          <tr><td>Date/Time:</td><td> <input name="datetime" value="<?php echo "$date"; ?>" type="text" readonly="true" /></td></tr>
          <tr><td colspan="2">Message:</td></tr>
  <tr><td colspan="2"><textarea name="message" cols="50" rows="15"><?php echo "$message"; ?></textarea></td></tr>
          <tr><td colspan="2" align="center"><input type="submit" name="submitBtn" value="Post News" /></td></tr>
        </table>
      </form>



thank you
Valkeri2010

Hi can anyone please help me, I have to create a edit page that retrieves information from a list so that a user can change the text. The page looks fine but when I enter data in the fields and update it leaves the page as it was retrieved.
I am a beginner! My code looks like this:

Code: [Select]
<form method = "get" action = "edit.php">
<?php

  //check to see if user is logged on
  session_start();
  if (!(isset($_SESSION['login']) && $_SESSION['login'] != "")) {
   header ("Location:login.php");
  }

  include('connect.php');  //connection details to database in a connect.php page
  
  $product_id = $_GET['product_id'];
  
  $query = "SELECT * FROM products WHERE product_id = '$product_id'";
  $result = mysql_query($query);
  
  while($row = mysql_fetch_array($result)){
  $product_id = $row['product_id'];
  echo "<table>";
  echo "<tr>";
  echo "<td><input name = 'product_id' type = 'hidden' value ='$row[product_id]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Name:</td><td><input name = 'pname' type = 'text' value ='$row[product_name]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Range:</td><td><input name = 'prange' type = 'text' value ='$row[product_range]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>Product Price:</td><td><input name = 'pprice' type = 'text' value ='$row[product_price]'></td>";
  echo "</tr>";
  echo "<tr>";
  echo "<td><input type = 'submit' name = 'Submit' value = 'Update'></td>";
  echo "</tr>";
  echo "</table>";
  }
  
   //if form was submitted
    if ($_SERVER['REQUEST_METHOD'] == 'POST'){
  
    //get values from fields
    $productname = $_POST['pname'];
    $range = $_POST['prange'];
    $price1 = $_POST['pprice'];
    $price = (int)$price1;
    
    if ($productname == "" || $range == "" || $price == "" ) {
        $errorMessage .= "Please fill in all text boxes";
        }
        else {
        $errorMessage = "";
        }
    
  
    
    $query = "UPDATE products SET product_name = '$productname', product_range = '$range', product_price = '$price' WHERE product_id = '$product_id'";
    $result = mysql_query($query);
    print "<br> $productname from range $range with a price of $price has been updated!";
    } 
      
?>

 
Thank you in advance!

ok I have text files with my logins to my emails and such..

Well I have this script to prepare the logins for another script

the files with the logins are in this format

email pass
email pass
email pass
email pass

$filename = 'text.txt';
$file = file($filename); 
$begin = "$";
foreach($file as $b){ 
list($email,$password) = explode(" ",$b);
  $emails[] = $begin."header[]=get_header('".$email."','".$password."');";} 
  file_put_contents($filename,implode($emails));  
  echo "Text file edited";
  sleep(5);

Is what I am using to get the email and password in this format

$header[]=get_header('email','pass');

but it is putting it like this


$header[]=get_header('email','pass
');
$header[]=get_header('email','pass
');
$header[]=get_header('email','pass
');
$header[]=get_header('email','pass
');
$header[]=get_header('email','pass

Why is it putting '); on a new line?

 I need it to be right behind the password so it looks like this


$header[]=get_header('email','pass');
$header[]=get_header('email','pass');
$header[]=get_header('email','pass');
$header[]=get_header('email','pass');
$header[]=get_header('email','pass');

any ideas? Thanks

guys in this code i get some data from myswl table and i display them in to and html table with dynamic textboxes

the first part works ok but how can i update the mysqltable with tha changes? i have try to work with one table and i get an error
Notice: Undefined index: name1 in D:\.......

<?php

session_start();
include($_SERVER['DOCUMENT_ROOT'].'/includes/connection.php');

$result = mysql_query( "SELECT * FROM serv " );


while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<tr>";
echo "<td ALIGN=\"center\"><form  method='POST'><input name=\"name1\" type=\"text\" value={$row['onoma-eponymo']} id=\"n1\" STYLE=\" border-color:black; border-style:none; border-width:1px; font-size:30pt; color:yellow; background-color:gray; \" size=\"25\" maxlength=\"24\" /></form></td>";
echo "<td ALIGN=\"center\"><form  method='POST'><input name=\"name2\" type=\"text\" value={$row['username']} STYLE=\" border-color:black; border-style:none; border-width:1px; font-size:30pt; color:yellow; background-color:gray; \" size=\"7\" maxlength=\"5\" /></form></td>";
echo "<td ALIGN=\"center\"><form  method='POST'><input name=\"name3\" type=\"text\" value={$row['password']}  STYLE=\" border-color:black; border-style:none; border-width:1px; font-size:30pt; color:yellow; background-color:gray; \" size=\"7\" maxlength=\"5\" /></form></td>";
echo "<td ALIGN=\"center\"><form  method='POST'><input name=\"name4\" type=\"text\" value={$row['serv_id']}  STYLE=\" border-color:black; border-style:none; border-width:1px; font-size:30pt; color:yellow; background-color:gray; \" size=\"9\" maxlength=\"15\" /></form></td>";
echo "</tr>\n";
}


echo "</table>";


if(isset($_POST['back']))    {header("location:admin.php");}

if(isset($_POST['sub_update']))       
                                    {
                                    $text = $_POST["name1"];
                                    mysql_query("INSERT INTO serv (password) VALUES ('$text') ");
                                    }




?>



<body>
<form method="post" action="">
<input type="Submit" name="sub_update" value="Ενημέρωση Αλλαγών"style="height:6em; width:16em; font-size:150%;">
<form method="post" action="">
<input type="Submit" name="back" value="Back"style="height:6em; width:16em; font-size:150%;">
</form>

Hey guys,
i'm making an edit feature on my website so i can delete,edit or add more jobs,
so far i've made the delete and add function's work
however i can't seem to get the edit to work
This is the edit function
Code: [Select]
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$s = 'SELECT * FROM jobs WHERE id="$editid"';
$sql = mysql_query($s) or die ('Error: '.mysql_error () . " IN $s");
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE  jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
Here is the whole code,
Code: [Select]
<?php
include'modules/sides/header.php';
?>
      <table cellpadding="0" cellspacing="0" width="100%" id="mainTable">
      <tr>
         <td class="left">
        <?php include'modules/sides/left.php';?>
          </td>
        <td id="centercolumn">
          <table class="cont" cellspacing="0">
            <tr>
              <td id="centerCcolumn">
                    <div class="block">
<?php 

if(session_is_registered('username')){
if ($userlevel = 3){ ?>
                        <div class="blockTitle">Administration - Add/Remove Jobs</div>
                      <div class="blockContent">
  <?php
  $action = $_GET["action"];
if ($action == "delete"){
$delid = $_GET['delid'];
$query = "DELETE FROM jobs WHERE id=".$delid." LIMIT 1";
$sql = mysql_query($query);
echo("Job succesfully deleted! [ <a href='add_jobs.php'>Back</a> ]");
}
if ($action == "edit"){
print("<strong>Editing a Job:</strong>");
$editid = $_GET['editid'];
$s = 'SELECT * FROM jobs WHERE id="$editid"';
$sql = mysql_query($s) or die ('Error: '.mysql_error () . " IN $s");
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$query2 = "UPDATE  jobs SET (job_title, job_description, job_type, job_area, hot_job) VALUES ('$job_title', '$job_description', '$job_type', '$job_area', '$hot') WHERE id=$id";
echo("<form name='add' method='post' action='?action=edit'>");
echo("<input type='hidden' name='?action=edit'>");
echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title' value='$job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'>$job_description</textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no'></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
}
}
if ($action == "add"){
$add = $_POST['add'];
$job_title = $_POST['job_title'];
$job_description = $_POST['job_description'];
$job_type = $_POST['job_type'];
$job_area = $_POST['job_area'];
$hot = $_POST['hot'];
$id = mysql_insert_id();
$query = "INSERT INTO jobs (id, job_title, job_description, job_type, job_area, hot_job) VALUES ('$id', '$job_title', '$job_description', '$job_type', '$job_area', '$hot')";
$sql = mysql_query($query) or die (mysql_error());
}
print("<strong>Add A New Job!</strong>");
print("<br />");
print("<br />");
echo("<form name='add' method='post' action='?action=add'>");
echo("<input type='hidden' name='?action=add'>");

echo("<table class=main cellspacing=0 cellpadding=5 width=50%>");
echo("<tr><td>Job Title: </td><td align='right'><input type='text' size=50 name='job_title'></td></tr>");
echo("<tr><td>Job Description: </td><td align='right'><textarea size=50 name='job_description'></textarea></td></tr>");
echo("<tr><td>Job Type: </td><td align='center'><select name='job_type'><option>Permanent</option><option>Locum or Contract</option></SELECT></td></tr>");
echo("<tr><td>Hot Job? </td><td align='center'>Yes <input type='radio' name='hot' value='Yes'> No <input type='radio' name='hot' value='no' checked></td></tr>");
echo("<tr><td>Job Area: </td><td align='center'><select name='job_area'><option>East Anglia</option><option>All UK</option><option>London / South East</option><option>Midlands</option><option>North West</option><option>Northern Ireland</option><option>Scotland</option><option>South</option><option>South West</option><option>Southern Ireland</option><option>Wales</option><option>Yorkshire / North East</option></SELECT></td></tr>");
echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>");
echo("</table>");
if($success == TRUE) {
print("<strong>Success!</strong>");
}
echo("<br>");
echo("</form>");
print("<strong>Existing Jobs:</strong>");
print("<br />");
print("<br />");
echo("<table class=main cellspacing=0 cellpadding=5>");
echo("<td>ID:</td><td>Title:</td><td>Description:</td><td>Type:</td><td>Area:</td><td>Edit (DO NOT USE YET):</td><td>Delete:</td>");
$query = "SELECT * FROM jobs WHERE 1=1";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$job_title = $row['job_title'];
$job_description = $row['job_description'];
$job_type = $row['job_type'];
$job_area = $row['job_area'];
$position=18;
$job_description2 = substr($job_description, 0, $position); 
echo("<tr><td><strong>$id</strong></td><td><strong>$job_title</strong></td><td><strong>$job_description2...</strong></td><td><strong>$job_type</strong></td><td><strong>$job_area</strong></td><td><a href='add_jobs.php?action=edit&editid=$id'>Edit</a></td><td><a href='add_jobs.php?action=delete&delid=$id'>Delete</a></td></tr>");
}
?></p></table>
  </div>
                    </div>
<?php }else{echo'Stop hacking';}}?>
                </td>
            </tr>
          </table>
        <td class="right">
<?php
include"modules/sides/right.php";
?>
          </td>
        </tr>
    </table>
        <?php include'modules/sides/footer.php';?>

Any help would be great, thankyou!