Problem med update og insert af images!
Jeg kan ikke update billeder, min kode er således:edit.php:
$sql = "SELECT * FROM products WHERE products_prodnum = ".$_GET['products_prodnum'];
//echo $sql;
$q = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($q);
//echo "<pre>";
//print_r($row);
?>
<table border="0" width="785" cellspacing="1" cellpadding="3" align="center">
<form action="save.php" method="post">
<input type="hidden" value="<?= $row['products_prodnum'] ?>" name="products_prodnum" size="1">
<tr>
<td width="20%" valign="bottom"><font class="undermenu"><b>Varernr.</b></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Navn</b></td>
<td width="20%" valign="bottom"><font class="undermenu"><strong>Size</strong></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Pris</b></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Kategori</b></td>
</tr>
<tr>
<td><font class="undermenu"><?= $row['products_prodnum'] ?></td>
<td><input type="text" value="<?= $row['products_navn'] ?>" name="products_navn" size="20" /></td>
<td><input type="text" value="<?= $row['products_size'] ?>" name="products_size" size="20" /></td>
<td><input type="text" value="<?= $row['products_pris'] ?>" name="products_pris" size="20" /></td>
<td><input type="text" value="<?= $row['products_type'] ?>" name="products_type" size="20" /></td>
</tr>
<tr>
<td colspan="5" valign="bottom"><font class="undermenu"><b>Beskrivelse:</b></td>
</tr>
<tr>
<td colspan="5"><textarea name="products_beskrivelse" cols="94" rows="5"><?= $row['products_beskrivelse'] ?></textarea></td>
</tr>
<tr>
<td colspan="3"><font class="undermenu"><b>Stort billede:</b></td>
<td colspan="2"><font class="undermenu"><b>Lille billede:</b></td>
</tr>
<tr>
<td colspan="3" valign="top"><img src="<?= $row['products_imageurl'] ?>" width="400" height="400" border="0"></td>
<td colspan="2" valign="top"><img src="<?= $row['products_thumbnailimageurl'] ?>" width="95" height="95" border="0" /></td>
</tr>
<tr>
<td colspan="3" valign="top"><input type="text" value="<?= $row['products_imageurl'] ?>" name="products_imageurl" size="45" /></td>
<td colspan="2" valign="top"><input type="text" value="<?= $row['products_thumbnailimageurl'] ?>" name="products_thumbnailimageurl" size="45" /></td>
</tr>
<tr>
<td colspan="5" align="center" valign="middle"><input type="hidden" name="action" value="add" />
<input type="submit" value="Ret"></td>
</tr>
</form>
</table>
save.php:
<?php
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die(mysql_error());
$db = mysql_select_db("xxxxx")
or die(mysql_error());
if($_POST[action] =="add")
{
mysql_query("UPDATE products SET products_navn ='$_POST[products_navn]', products_size ='$_POST[products_size]', products_pris ='$_POST[products_pris]', products_type ='$_POST[products_type]', products_beskrivelse ='$_POST[products_beskrivelse]', products_imageurl ='$_POST[products_imageurl]', products_thumbnailimageurl ='$_POST[products_thumbnailimageurl]' WHERE products_prodnum ='$_POST[products_prodnum]'") or die(mysql_error());
$status = Opdateret;
}
header("location: produkter.php");
?>
Hvad kan fejlen skyldes?
