Jump to content

Is something wrong with this query?


wee493

Recommended Posts

I keep getting an error with this query, what could be wrong with it?

 

 

Here is my database http://grab.by/grabs/e2245fe272af915a98f186b9e9966ee1.png

$query = mysql_query("INSERT INTO scrobble ('lfmuser', 'artist', 'artistmbid', 'name', 'album', 'albummbid', 'trackurl', 'playdate', 'nicedate') VALUES ('$user', '$artist', '$artist_mbid', '$name', '$album', '$album_mbid', '$url', '$date', '$nicedate')") or die(mysql_error());

Link to comment
https://forums.phpfreaks.com/topic/204469-is-something-wrong-with-this-query/
Share on other sites

Sorry, forgot to put that this is the 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 ''lfmuser', 'artist', 'artistmbid', 'name', 'album', 'albummbid', 'trackurl', 'pl' at line 1

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.