Hjælp til fejlfinding.
Hej eksperter. kan i se om der er nogle fejl her:<?php
if(isset($_POST['op']))
{
include 'db.php';
$spg_id = $_POST['spg'];
$svar = htmlspecialchars(addslashes($_POST['svar']));
$spg = htmlspecialchars(addslashes($_POST['spg']));
$spg_id = mysql_escape_string($_POST['spg_id']);
foreach($_POST['svar'] as $svar)
{
$query = mysql_query("UPDATE spg_svar SET svar='$svar',spg_id='$spg_id' id='". $_GET["id"] ."'");
if(mysql_affected_rows()==0)
{
echo "Der opstod en fejl: " . mysql_error() . "<hr>\n";
}
}
mysql_query("UPDATE spg_spg SET spg='$spg' WHERE id='". $_GET["id"] ."'") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Spørgsmålet blev oprettet</div>";
}
?>
<?
require "db.php";
$query = mysql_query ("SELECT * FROM spg_spg WHERE id='". $_GET["id"] ."'") or die(mysql_error());
while ($row = mysql_fetch_array($query)) {
$spg = $row['spg'];
$id = $row['id'];
?>
<form name="rediger" method="post" action="redi_spg.php">
<table width="100%" height="1%" border="0">
<tr><td width="20%" height="26" valign="middle">
<div align="left" class="style2">Spørgsmålet:</div></td>
<td width="80%" valign="middle">
<textarea name="spg" cols="50"><?php echo $row['spg']; ?></textarea>
</td>
</tr>
<? } ?>
<?
$query = mysql_query("SELECT * FROM `spg_svar` WHERE spg_id='". $_GET["id"] ."'") or die (mysql_error());
while($vis = mysql_fetch_array($query)) {
$svar = $vis['svar'];
echo " <tr><td height='26' valign='middle' class='style2'>Svar X: </td>
<td valign='middle'>
<input name='svar[]' type='text' size='50' value='$svar'></td></tr>";
}
?>
<tr>
<td height="26" colspan="2" valign="top"><div align="center">
<input name="op" type="submit" id="op" value="Rediger spørgsmål">
</div></td>
</tr>
</table>
</form>
den skal gemme i 2 forskellige tabeller.
