MySQL insert error

[perezf]

I need help,

Everytime an item is placed into my MySQL table under pictures it stops my php script from loading the username from the session

can someone let me know if it is MySQL database issue or php

 

-- --------------------------------------------------------

-- 
-- Table structure for table `pictures`
-- 

CREATE TABLE `pictures` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `size` int(11) NOT NULL,
  `content` mediumblob NOT NULL,
  `username` varchar(30) NOT NULL,
  `nameofhoe` varchar(30) NOT NULL,
  `buildofhoe` varchar(30) NOT NULL,
  `hobbyofhoe` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `username` varchar(25) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[perezf]

can someone let me know if this is set up correct

[bubblegum.anarchy]

looks ok'ish

[btherl]

perezf, can you post your script?