[SOLVED] Mysql Problem

[xshanelarsonx]

This keep's giving me this error.

"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 's','aa's.mp3', '0')' at line 1"

 

$songname = aa's

 

mysql_connect("localhost","root","hs") or die ("Unable to connect to MySQL server."); 
mysql_select_db("Music") or die ("Unable to select requested database."); 
$music = array(".mp3");
$fname = $_FILES['file']['name'];
$ext = strrchr($fname,'.');
if (!in_array(strtolower($ext),$music)) {
echo "~~Wrong file extension -- Music*.mp3* only~~<br /><a href='Music.php'>Back</a>";
}else{
$fname = $songname.".mp3";
$fname = str_replace(' ', '', $fname);
$fname = stripslashes($fname);
$songname = stripslashes($songname);
move_uploaded_file($_FILES["file"]["tmp_name"],"Files/Music/" ."$fname" );
$MuscUpload = "INSERT INTO songs(SongName , File, Seconds) VALUES('$songname','$fname', '0')";
mysql_query($MuscUpload) or die("MySQL ERROR: ".mysql_error());

[13th_Star]

change this

$fname = str_replace(' ', '', $fname);

 

back to

$fname = str_replace("'", "", $fname);

 

[xshanelarsonx]

That didn't fix it. Thanks for the try.

[13th_Star]

ok so you've got $songname = aa's

 

and your error is: 'aa's'  it just looks like it does not like the extra ' in the middle.

 

which you should just take out with the $songname = str_replace("'","",$songname); like you did with the filename

[redarrow]

Test this and ur see ur self that the

str_replace function does work as you was told ok

 

<?php

$fname="red'arrow's";
$fname = str_replace("'", "", $fname);

echo $fname;
?>

[xshanelarsonx]

Thanks for all the help. I figured out that it must be a combo to work.

 

$fname = stripslashes($fname);
$fname = str_replace("'", "", $fname);

 

Not just.

 

$fname = str_replace("'", "", $fname);