Hallo,ich hab den folgenden code.könnt ihr den fehler endecken:
Code:
`song_id` int(11) unsigned NOT NULL auto_increment,
`song_title` varchar(255) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`song_cat_id` mediumint(8) NOT NULL default '0',
`song_url` varchar(255) NOT NULL default '',
`song_desc` blob NOT NULL,
`song_singer` varchar(255) NOT NULL default '',
`song_writer` varchar(255) NOT NULL default '',
`provider` varchar(100) NOT NULL default '',
`song_user_id` mediumint(8) NOT NULL default '0',
`song_time` int(11) NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`song_username` varchar(32) default NULL,
`song_user_ip` varchar(8) NOT NULL default '0',
`song_view_count` int(11) unsigned NOT NULL default '0',
`song_lock` tinyint(3) NOT NULL default '0',
`song_approval` tinyint(3) NOT NULL default '1',
`song_download_count` varchar(255) NOT NULL default '0',
PRIMARY KEY (`song_id`),
KEY `song_user_id` (`song_user_id`)
) TYPE=MyISAM AUTO_INCREMENT=560 ;
Code:
<?
{
$song_id = addslashes($song_id);
$song_title = addslashes($song_title);
$category = addslashes($category);
$song_url = addslashes($song_url);
$song_desc = addslashes($song_desc);
$provider = addslashes($provider);
$song_cat_id = addslashes($song_cat_iid);
switch($category) {
case Drumandbass:
$song_cat_id ='[3]';
break;
case Techno :
$song_cat_id ='[5]';
break;
case Reggae:
$song_cat_id ='[6]';
break;
case Trance :
$song_cat_id ='[7]';
break;
case House :
$song_cat_id ='[4]';
break;
}
$MYSQLCONN = mysql_connect("localhost","die byatch","damn") or die("Error connecting to mySQL database.
Please try again later.");
mysql_select_db("damn_damn",$MYSQLCONN) or die("Database damn_damn' could not be found.
Script execution terminating.");
$query = "INSERT INTO `phpbb_music` (`song_id`,`song_title`,`category`,'song_cat_id',`song_url`,`song_desc`,`provider`,`date`) VALUES ('$song_id','$song_title','$category','song_cat_id','$song_url','$song_desc','$provider',NOW())";
if(!mysql_query($query)) { echo "Insertion into database failed."; } else { echo "Insertion into database was successful."; }
echo "
<a href=mylinks.php>Back</a>";
danke im voraus°!!!!