Results 1 to 2 of 2

Thread: Number not adding to SQL [RESLOVED]

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2003
    Location
    Auckland
    Posts
    1,139

    Resolved 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???
    Last edited by kiwis; Apr 10th, 2005 at 03:21 AM.

  2. #2
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    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?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width