Number not adding to SQL [RESLOVED]
Hi have a code ehich i want to have the number value added to my sql database
this is the html
<option value"43"></b><font face="Verdana" size="2">Burnham</option>
<option value"42"></b><font face="Verdana" size="2">Shirley</option>
<option value"41"></b><font face="Verdana" size="2">Sydenham</option>
my field is a INT (10)
php is
PHP Code:
<?php
if ($action == "save")
{
$result = mysql_query ("INSERT INTO results_team (`team_id`,`team_name`,`team_sh_name`,`parent_club`,`team_logo`,`jumper_url`) Values ('','$team_name','$team_sh_name','$parent_club','$team_logo','$jumper_url')") or die("INSERT error: ".mysql_error());
?>
only sometime does this add to my DB.... any ideas why???
Re: Number not adding to SQL
Your HTML has an error. This:
HTML Code:
<option value"43">
Should be:
HTML Code:
<option value="43">
Also, whnat error do you get when it doesn't work?
