Need Help!

Discussion in 'Databases' started by syndromeX, Jul 5, 2008.

  1. #1
    Hi,
    i need help importing a sql into phpmyadmin,

    When i try to import the sql file i receive a error message
    ''#1136 - Column count doesn't match value count at row 1''

    Can someone please explain this error.

    INSERT INTO `categories` VALUES (120, 'Appetizers', 'Apricot & Cucumber Soup', '<TABLE cellSpacing=2 cellPadding=3 border=0><TBODY><TR><TD><P>6 oz Dried apricots <P>1 1/2 pt Vegetable stock <P>1 ea Orange, juiced &amp; rind grated <P>1 md Cucumber <P>1 md Onion, finely chopped <P>1 tb Vegetable oil <P>2 ts Curry powder <P>Salt &amp; pepper 2 tb Pumpkin seeds, to garnish <P>Soak the apricots in the stock with the grated orange rind for 2 to 3 hours. Add the orange juice &amp; simemr for 45 minutes. Cut 8 thin slices from the cucumber &amp; reserve for garnish. Peel &amp; roughly chop the remainder. Fry the onion in the oil over medium heat for 3 to 4 minutes, stirring once or twice. Stir in the curry powder &amp; chopped cucumber &amp; cook for 2 minutes. Puree the apricots with the stock &amp; the cucumber mixture. Return to the pan &amp; heat gently. Season with salt &amp; pepper. Serve the soup garnished with floating slices of cucumber topped with the pumpkin seeds. Black rye bread makes a good accompaniment. Pamela Westland, \"Fruit\" <BR><BR></P></TD></TR></TBODY></TABLE>');
    
    PHP:
    Thanks!
     
    syndromeX, Jul 5, 2008 IP
  2. Stryder

    Stryder Guest

    Messages:
    124
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Looks like the table structure is different from the insert values. You could try something like the following:

    insert into tablename(field1,fiel2..) values(value1, value2 .. )
     
    Stryder, Jul 5, 2008 IP
  3. zerofill

    zerofill Member

    Messages:
    34
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #3
    Show us a dump of the table structure
     
    zerofill, Jul 7, 2008 IP