Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Exclamation Mysql Problem inserting multiple records into table

    Hi all how are you? I am just having a bit of an issue with my form script and mysql, inserting records from this form of mine into my table in my database.
    it looks like all my others and they work, so what could be so wrong with this. Here
    let me show you the code


    CODE


    <?php
    $host="xxxxxxxxx";
    $username="xxxxxxx";
    $password="xxxxxx";
    $db="xxxxx";
    $link=mysql_connect($host,$username,$password);
    if (!$link)
    die("Couldn't connect to MySQL");
    mysql_select_db($db,$link)
    or die("couldn't open $db:".mysql_error());


    $sender_firstandlast =$_POST['sender_firstandlast'];
    $sender_companyname =$_POST['sender_companyname'];
    $sender_email=$_POST['sender_email'];
    $sender_phonenumber=$_POST['sender_phonenumber'];
    $how_recieve=$_POST['how_recieve'];
    $websitetitle=$_POST['websitetitle'];
    $what=$_POST['what'];
    $websitedetails=$_POST['websitedetails'];
    $websitebudget=$_POST['websitebudget'];
    $how_pages=$_POST['how_pages'];
    $completiondate=$_POST['completiondate'];
    $currenturl=$_POST['currenturl'];
    $chooseany=$_POST['chooseany'];
    $size=$_POST['size'];
    $scripts=$_POST['scripts'];
    $databases=$_POST['databases'];
    $scriptdetails=$_POST['scriptdetails'];



    mysql_select_db($db) or die("Cannot select the database.<br>" . mysql_error());
    $result=mysql_query("INSERT INTO quote (sender_firstandlast, sender_companyname, sender_email, sender_phonenumber, how_recieve, websitetitle, what, websitedetails, websitebudget, how_pages, completiondate, currenturl, chooseany, size, scripts, databases, scriptdetails) VALUES ('$sender_firstandlast','$sender_companyname','$se nder_email','$sender_phonenumber','$how_recieve',' $websitetitle','$what','$websitedetails','$website budget','$how_pages','$completiondate','$currentur l','$chooseany','$size','$scripts','$databases','$ scriptdetails')")or die("Insert Error: ".mysql_error());


    ?>
    <?php
    include("steveform.php");
    ?>





    All my other scripts use this for their inserting data and so why doesn't this work. The variables are all set right im sure. They carry the same name= as in the form names. the names are correct in the Database Table. May be I entered the data the wrong way in my database??? I don't know, I've tried everything and my form is not running, well dumby me i need to put up my backup, duh, but in the mean time i would really like to solve this, please help me anyone. thanks

  2. #2
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Arrow

    Hi, nice meeting you

    This is the suggestions and feedback forum...

    Try posting your message in the dedicated MySQL forum, here:
    http://www.dbforums.com/f5

    Regards,
    Daniel

Posting Permissions

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