Multiple MySql insert!

Discussion in 'MySQL' started by anversli, Jun 3, 2008.

  1. #1
    Hi,

    I need some help with the following problem:

    I wanna add multiple information from a form if the checkbox is checked, for example:

    form
    -------------
    checkbox
    input name
    input title
    input user
    input desc
    -------------
    checkbox
    input name
    input title
    input user
    input desc
    -------------
    checkbox
    input name
    input title
    input user
    input desc
    -------------
    checkbox
    input name
    input title
    input user
    input desc
    -------------
    end form

    If the checkbox is checked I need to have value like:
    INSERT INTO test VALUES(NULL, 'name1', 'title1', 'user1', 'desc1');
    INSERT INTO test VALUES(NULL, 'name2', 'title2', 'user2', 'desc2');
    INSERT INTO test VALUES(NULL, 'name3', 'title3', 'user3', 'desc3');

    Who can help me with this one?
     
    anversli, Jun 3, 2008 IP
  2. crath

    crath Well-Known Member

    Messages:
    661
    Likes Received:
    33
    Best Answers:
    0
    Trophy Points:
    100
    #2
    What part exactly do you need help with? You see to have it :p
     
    crath, Jun 3, 2008 IP
  3. anversli

    anversli Active Member

    Messages:
    350
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #3
    Ok solve the problem :)
     
    anversli, Jun 3, 2008 IP
  4. crath

    crath Well-Known Member

    Messages:
    661
    Likes Received:
    33
    Best Answers:
    0
    Trophy Points:
    100
    #4
    solved? or me solve? :p
     
    crath, Jun 3, 2008 IP
  5. CreativeClans

    CreativeClans Peon

    Messages:
    128
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #5
    
    INSERT INTO test VALUES(NULL, 'name1', 'title1', 'user1', 'desc1'),
                                       (NULL, 'name2', 'title2', 'user2', 'desc2'),
                                       (NULL, 'name3', 'title3', 'user3', 'desc3');
    
    Code (markup):
     
    CreativeClans, Jun 4, 2008 IP