
chromox
New User
Apr 14, 2008, 1:33 PM
Post #1 of 2
(7198 views)
|
MySQL Query Execution Problem
|
Can't Post
|
|
This is my query...
$sql = "INSERT INTO `abliss`.`songs` (`id`,`artist`,`album`,`name`,`track`,`year`,`length`,`plays`,`filename`) VALUES (NULL,'\'$main::artist\'','\'$main::album\'','\'$main::title\'','\'$main::track\'','$main::year','0','0','$File::Find::name');"; This is the error:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'U2'',''How to Dismantle an Atomic Bomb'',''Sometimes You Can't Make It on Your O' at line 1 at ./mp3scan.pl line 32. Basically I am trying to make it insert the data that I have for each song, and it just doesn't like me I have no idea why the query is not working. Does anyone see something wrong?
|