I want to set data in two tables on my databas from my webbform but i dont understand how i do! the first query works fine insert into varor but the second query when i should set in varu_id from the first query and bild tree times only the second bild comes in table and 0 in varu_id
<?php
require("var.inc.php");
MYSQL_CONNECT($server, $anvandare, $losen) OR DIE("Unable to connect to database");
@mysql_select_db( "$databas") or die( "Unable to select database");
$query = "INSERT INTO varor (varu_id, artid, varunamn, pris, beskrivning) VALUES ('NULL', '$artid', '$varunamn', '$pris', '$beskrivning')";
$result = MYSQL_QUERY($query);
if ($result ==0) {$error = "<center>mySQL error " .mysql_errno().": ".mysql_error()."</center><BR>";
{
print $error;
}
}
$query = "INSERT INTO bild (bild_id, varu_id, bild) VALUES ('NULL', '$varu_id', '$bild')";
$result = MYSQL_QUERY($query);
if ($result ==0) {$error = "<center>mySQL error " .mysql_errno().": ".mysql_error()."</center><BR>";
{
print $error;
}
}
?>
<form method="POST" action="varor.php">
<div align="center"><center>
<input type="hidden" name="varu_id" value="<?php echo $produkt[1]; ?>" border="0">
<table border="0" width="400">
<tr>
<td width="102" align="right">Artnr:</td>
<td ><input type="text" name="artid" value="<?php echo $produkt[1]; ?>" size="40" ></td>
</tr>
<tr>
<td width="102" align="right">Namn:</td>
<td ><input type="text" name="varunamn" value="<?php echo $produkt[2]; ?>" size="40" ></td>
</tr>
<tr>
<td width="102" align="right">Pris:</td>
<td ><input type="text" name="pris" value="<?php echo $produkt[3]; ?>" size="40" ></td>
</tr>
<tr>
<td width="102" align="right">Beskrivning:</td>
<td ><textarea rows="4" name="beskrivning" cols="40" ><?php echo $produkt[4]; ?></textarea></td>
</tr><tr>
<td width="102" align="right">Bild1:</td>
<td ><input type="text" name="bild" value="<?php echo $produkt[7]; ?>" size="40" ></td>
</tr>
<tr>
<td width="102" align="right">Bild2:</td>
<td ><input type="text" name="bild" value="<?php echo $produkt[7]; ?>" size="40" > dm³</td>
</tr>
<tr>
<td width="102" align="right">Bild3:</td>
<td ><input type="text" name="bild" value="<?php echo $produkt[7]; ?>" size="40" > kg</td>
</tr>
<tr>
<td width="102" align="right"> </td>
<td ><input type="submit" value="Uppdatera" name="insert"></td>
</tr>
</table>
</center></div>
</form>
</body>
</html>
