I have this code but nothing will add to my database... any ideas what is wrong?
PHP Code:<?php
mysql_connect (localhost, root, password);
mysql_select_db (Database);
?>
<?php
if ($action == "save")
{
$result = mysql_query ("INSERT INTO News Values ('','$header','$author','$body','$result_id','$attachimg','$BCC','$WLG','$AKL','$CHC','$NPL','$DUD','$PMR','$TRG','$OHA','$NZL','$KWI','$NZW')");
?>
<font face="Verdana" size="2">
<b><a href="index.php">Click here to return to the main index</a></b>
<?php
} else {
?>
<form method="POST" action="add.php?action=save">
<p>
<font face="Verdana" size="1">
<b>Header: </b>
<input TYPE="text" NAME="header" SIZE="95"> <a href="javascript:popupPage3()">(help)</a></font></p>
<p>
<font face="Verdana" size="1">
<b>Author: </b><input TYPE="text" NAME="author" SIZE="40" value="<?php echo $user_fullname; ?>">
(Optional) <a href="javascript:popupPage4()">(help)</a></font></p>
<p>
<b><font face="Verdana" size="1">Result_id:
<input type="text" name="result_id" size="5">
</font>
</b>
<font face="Verdana" size="1"><a href="javascript:popupPage7()">(help)</a></font></p>
<p>
<b><font face="Verdana" size="1">Image to show next to news item, just select the best option:</font><font face="arial" size="2"> </font>
</font>
<select size="1" name="attachimg">
<option selected value=""></option>
</select>
</b>
<font face="Verdana" size="1"><a href="javascript:popupPage8()">(help)</a></font></p>
<p>
<textarea rows="24" name="body" cols="117"></textarea></p>
<p><b></p>
<hr color="#000000" size="1">
<p><font face="Verdana" size="1">Your news item will automatically
be added to the front page of the site so if it does not need to go
on a sub section don't click any of these boxes. </font></b>
<font face="Verdana" size="1"><a href="javascript:popupPage9()">(help)</a></font><b><font face="Verdana" size="1"> </font></p>
<p><font face="Verdana" size="1">
<input type="checkbox" name="BCC" value="1"></font></b><font size="1" face="Verdana">Bartercard
Cup | </font><b><font face="Verdana" size="1">
<input type="checkbox" name="WLG" value="1"></font></b><font size="1" face="Verdana">
Wellington | </font><b><font face="Verdana" size="1">
<input type="checkbox" name="AKL" value="1"> </font></b>
<font face="Verdana" size="1">Auckland | </font>
<b><font face="Verdana" size="1">
<input type="checkbox" name="CHC" value="1"></font></b><font size="1" face="Verdana">Cantbuery
| </font><b><font face="Verdana" size="1">
<input type="checkbox" name="NPL" value="1"></font></b><font size="1" face="Verdana">
Taranaki | <b>
<input type="checkbox" name="DUD" value="1"> </b>Otago (Southern
Alliance) | </font>
<b><font face="Verdana" size="1">
<input type="checkbox" name="PMR" value="1"></font></b><font face="Verdana" size="1">Western
Alliance </font></p>
<p><b><font face="Verdana" size="1">
<input type="checkbox" name="TRG" value="1"></font></b><font size="1" face="Verdana">
WaiCoa Bay | <b>
<input type="checkbox" name="OHA" value="1"> </b>Defence |
<b><input type="checkbox" name="NZL" value="1"></b>International
| </font><b><font face="Verdana" size="1">
<input type="checkbox" name="KWI" value="1"></font></b><font size="1" face="Verdana">
Kiwis | <b><input type="checkbox" name="NZW" value="1"> </b>Warriors
</font></p>
<p>
<font face="Verdana" size="1">
<br>
</font></p>
<input type="submit" value="Submit" name="save"></p>
</form>
<?php
}
?>




Reply With Quote