Hente data fra to tabeller ind i formular
Jeg har to tabeller, som jeg gerne vil hente data fra. Den ene hedder products og den anden images, jeg vil hente data fra images ind i en scroll-box/form for at vælge et givent billede, når jeg trykker på ret, skal products tabellen blive opdateret med det valgte data fra images. Nogen der vil hjælpe mig?<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></font></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Navn</b></font></td>
<td width="20%" valign="bottom"><font class="undermenu"><strong>Size</strong></font></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Pris</b></font></td>
<td width="20%" valign="bottom"><font class="undermenu"><b>Kategori</b></font></td>
</tr>
<tr>
<td><font class="undermenu">
<?= $row['products_prodnum'] ?>
</font></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></font></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><a class="undermenu" href="upload_image.php" target="_blank">[upload]</a> <a class="undermenu" href="showimages.php" target="_blank">[vælg]</a></font></td>
<td colspan="2"><font class="undermenu"><b>Lille billede: </b><a class="undermenu" href="upload_image.php" target="_blank">[upload]</a> <a class="undermenu" href="showimages.php" target="_blank">[vælg]</a></font></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 name="submit" type="submit" value="Ret" /></td>
</tr>
</form>
</table>
----
<?php
$conn = mysql_connect("xxxxx", "xxxxx", "xxxxx")
or die(mysql_error());
$db = mysql_select_db("xxxxx_shop")
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");
?>
