Se om du får alle variabler med i denne:
<?php
session_start();
if(isset($_POST['update'])){
$id = $_GET['id'];
$edit = "UPDATE load SET Producent = '".$_POST['set_prod']."', Model = '".$_POST['set_model']."',
Beskrivelse = '".$_POST['set_desc']."', Files = '".$_POST['set_files']."', Pics = '".$_POST['set_pics']."' WHERE ID = ".$id."";
echo "SQL-STRING: ". $edit;
//mysql_query($edit) or die(mysql_error());
}
//TJEK SESSION == START//
if ($_SESSION['login']==""){
print '<meta http-equiv="refresh" content="0;url=index.php">';
exit;
}
//TJEK SESSION == SLUT// ?>
<link rel="stylesheet" type="text/css" href="loadstyle.css">
<title>lockandload.dk</title>
<!-- INCLUDE bstyle.php -->
<? include("bstyle.php"); ?>
<br><br><br>
<TABLE height="600" border=0 align="center"><TR>
<TD width="20%" border="0" valign="top" align="right">
<!-- INCLUDE menu.php -->
<? include("menu.php"); ?></TD>
<TD valign="top" align="center">
<TABLE width="600" align="center" class="dot_admin"><TR>
<?php
echo' <TD align="center">
<TABLE class="desc_admin"><TR><TD>ADMINISTRATOR</TD></TR></TABLE><br>
<form action="admin_index.php" method="post">
<input type="text" class="searchbox" name="sbox">
<input type="image" src="/pics/search.png" value=" Search " title="E.g. Smg, Rifle, Sniper, Pistol, Revolver "> <br>
<input type="checkbox" name="adsearch">Search Specifications
</form>';
//'.$row['Producent'].'<br>'.$row['Model'].'<br />
if(isset($_GET['id'])) {
// INCLUDE connect.php //
include("connect.php");
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die("Unable to select database.".mysql_error());
$escaped_sbox = mysql_real_escape_string($_GET['id']);
$query = "SELECT * FROM `load` WHERE id = ". $escaped_sbox . "";
if(isset($_POST['adsearch'])){
$query = "SELECT * FROM `load` WHERE Beskrivelse LIKE '%" . $escaped_sbox . "%'";
}
$result = mysql_query($query);
$q = mysql_query($query);
while ($row = mysql_fetch_assoc($q)) {
echo"<TABLE class='desc_admin'><TR><TD><br><a href='admin_index.php'><- Back</a><br>
<br><form method='post' action=''>
<textarea cols='25' rows='2' name='set_prod' class='searchbox'> ".$row['Producent']." </textarea>
<textarea cols='25' rows='2' name='set_model' class='searchbox'> ".$row['Model']." </textarea>
<textarea cols='65' rows='25' name='set_desc' class='searchbox'> ".$row['Beskrivelse']." </textarea>
<textarea cols='65' rows='5' name='set_files' class='searchbox'> ".$row['Files']." </textarea>
<textarea cols='65' rows='5' name='set_pics' class='searchbox'> ".$row['Pics']." </textarea><br><br>
<a href='admin_index.php'><- Back</a> <input type='submit' value='Save' name='update'>
</form>";
}
}
echo "</TD></TR></TABLE>";
echo "</TD></TR></TABLE>";
?>
<!-- == LOGOUT == START == -->
<TD width="20%" align=left valign=top>
<TABLE><TR><TD>
<form action="index.php" method="get">
<input type="image" src="/pics/logout.png" align="right" name="logout">
</form>
</TD></TR></TABLE><br>
<?php if(isset($_POST['logout'])){
session_start();
session_destroy();
header('Location: index.php'); }?>
<!-- == LOGOUT == SLUT == -->
</TD></TR></TABLE>
<br>
</TD></TR></TABLE>
<br><br>
<? include("bstyle_bottom.php"); ?>
