Hello all. I am working on a new mod for Integramod/Im Portal use. it is quite nice and works a treat for radio station websites.
My database works nice, EXCEPT i have 1 small minor issue that maybe some one can help with.
here is my db structure:
CREATE TABLE IF NOT EXISTS `request_song` (
`id` bigint(20) NOT NULL auto_increment,
`song` longtext NOT NULL,
`artist` longtext NOT NULL,
`name` longtext NOT NULL,
`shoutout` longtext NOT NULL,
`ip` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
Nohere is the problem. everything shows up on the page properly as it should EXCEPT for shoutout. Not quite sure why it wont work.
A couple of screenshots to follow. (Click Images for large view)
Ok here goes in the first shot, you can see my request page ALL info was filled in before submit was selected.
[albumimg]28[/albumimg]
Now here is a shot of the requested songs page. Notice the shout out is empty? Its not even entered in the database either.
[albumimg]29[/albumimg]
The only thing I think besides an obvious db error is the fact that I need to go with a large text field somehow for shout outs.