Problem PHP and MYSQL

Discussion in 'PHP' started by rdlrn19, Mar 9, 2009.

  1. #1
    I'm adding content in one sql table...

    But when I try to add the var $description in a text, the information don't add..

    The var is $description and mysql value is description text not null.

    I think that this is because my $description var is too long...

    Help please !!!
     
    rdlrn19, Mar 9, 2009 IP
  2. itvn

    itvn Peon

    Messages:
    30
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    please give me your SQL statement
     
    itvn, Mar 9, 2009 IP
  3. rdlrn19

    rdlrn19 Peon

    Messages:
    48
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    CREATE TABLE `articles` (
    `id` int(11) NOT NULL auto_increment,
    `title` varchar(80) collate utf8_unicode_ci NOT NULL,
    `image` varchar(80) collate utf8_unicode_ci NOT NULL,
    `description` text collate utf8_unicode_ci NOT NULL,
    `date` varchar(80) collate utf8_unicode_ci NOT NULL,
    `file` varchar(80) collate utf8_unicode_ci NOT NULL,
    KEY `id` (`id`)
    );
     
    rdlrn19, Mar 9, 2009 IP
  4. itvn

    itvn Peon

    Messages:
    30
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    No, not that SQL statement. I need your INSERT INTO query
     
    itvn, Mar 9, 2009 IP
  5. Techmonkey

    Techmonkey Active Member

    Messages:
    107
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #5
    Yes show us the code where you are actually running the insert or update query
     
    Techmonkey, Mar 9, 2009 IP