Does anyone know why this doe not work?
nothing adds to my database and i can not see a error in my code
PHP Code:
---------------------------------------------------------------------------------
<?php
mysql_connect (localhost, username, pass);
mysql_select_db (table);
?>
<?php
if ($action == "save")
{
$result = mysql_query ("INSERT INTO news Values ('','$header','$from','$IMG,'$body','$source','$re
sult_id','$WRE','$AKL','$TRG','$PMR','$NPL','$WLG'
,'$OHA','$CHC','$DUD','$NZK','$NZW','$NZI','$AGE',
'$EDI','$BCC','$BULLS','$FLA','$REP')");
?>
<title>Rugby League in New Zealand Admin - Add News</title>
<br>
<font face="Verdana">
<strong><font size="2">All Done!<br>
</font>
</strong><font size="2">The news item has been added.<br>
</font></font></font></p>
<p><font face="Verdana"
size="2"><a style="text-decoration: none" href="index.php">Return to the main menu</a>
<?php
} else {
?>
<p>
<font face="Verdana" size="1">
<a style="text-decoration: none" href="index.php">Back to the main</a></font><p>
<font face="Verdana" size="1">If you have any questions please contact
<a style="text-decoration: none" href="mailto:[email protected]">Bevan</a></font><hr>
<font face="Verdana" size="2">
<form method="POST" action="addnews.php?action=save">
<font face="Verdana" size="2">Header: <br><input name="header" size="40" style="font-family: Verdana; border-style: solid; border-width: 1px"></font><p>
<font face="Verdana" size="2">From:<br> <input name="from" size="40" style="font-family: Verdana; border-style: solid; border-width: 1px"></font><p>
<font face="Verdana" size="2">Image:<br> <input name="IMG" size="40" style="font-family: Verdana; border-style: solid; border-width: 1px"></font><p>
<font face="Verdana" size="2">Body: <br><textarea rows="10" name="body" cols="77" style="font-family: Verdana; border-style: solid; border-width: 1px"></textarea>
<font face="Verdana" size="2">Source:<br> <input name="source" size="40" style="font-family: Verdana; border-style: solid; border-width: 1px"></font><p>
<font face="Verdana" size="2">Result ID:<br> <input name="result_id" size="40" style="font-family: Verdana; border-style: solid; border-width: 1px"></font><p>
<p>
<input type="checkbox" value="1" name="WRE"> Northland <br>
<input type="checkbox" value="1" name="AKL"> Auckland <br>
<input type="checkbox" value="1" name="TRG"> Waicoa Bay <br>
<input type="checkbox" value="1" name="PMR"> Western Alliance <br>
<input type="checkbox" value="1" name="NPL"> Taranaki <br>
<input type="checkbox" value="1" name="WLG"> Wellington <br>
<input type="checkbox" value="1" name="OHA"> Defence <br>
<input type="checkbox" value="1" name="CHC"> Canterbury RL <br>
<input type="checkbox" value="1" name="DUD"> Southern Alliance <br>
<input type="checkbox" value="1" name="NZK"> New Zealand Kiwis <br>
<input type="checkbox" value="1" name="NZW"> New Zealand Warriors <br>
<input type="checkbox" value="1" name="NZI"> New Zealand International <br>
<input type="checkbox" value="1" name="AGE"> Age Groups <br>
<input type="checkbox" value="1" name="EDI"> Editorials <br>
<input type="checkbox" value="1" name="BCC"> Bartercard Cup <br>
<input type="checkbox" value="1" name="BULLS"> Canterbury Bulls <br>
<input type="checkbox" value="1" name="FAL"> Central Falcons <br>
<input type="checkbox" value="1" name="REP"> Rep Footie
<p align="center">
<br><br>
<input type="submit" value="Save" name="B1" style="border-style: solid; border-width: 1px"></p>
</form>
<?php
}
?>
</body>
</font>
</html>
--------------------------------------------------------------------------------
and my table is set up like this
CREATE TABLE `news` (
`id` int(10) NOT NULL auto_increment,
`header` varchar(250) NOT NULL default '',
`from` varchar(250) NOT NULL default '',
`IMG` varchar(250) NOT NULL default '',
`body` text NOT NULL,
`source` varchar(250) NOT NULL default '',
`result_id` int(11) default NULL,
`WRE` int(11) default NULL,
`AKL` int(11) default NULL,
`TRG` int(11) default NULL,
`PMR` int(11) default NULL,
`NPL` int(11) default NULL,
`OHA` int(11) default NULL,
`WLG` int(11) default NULL,
`CHC` int(11) default NULL,
`DUD` int(11) default NULL,
`NZK` int(11) default NULL,
`NZW` int(11) default NULL,
`NZI` int(11) default NULL,
`AGE` int(11) default NULL,
`EDI` int(11) default NULL,
`BCC` int(11) default NULL,
`BULLS` int(11) default NULL,
`FAL` int(11) default NULL,
`REP` int(11) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
