Hello Webmasters i have added a new database and then i tried created a table name" lyrics.artist" as shown by the error message Database error in B-Inet Lyrics : Invalid SQL: SELECT COUNT(*) as songcount FROM songs AS s INNER JOIN artists AS a ON s.primaryartist = a.artistid LEFT JOIN albums AS al ON s.album = al.albumid WHERE a.letter = '09' mysql error: Table 'lyrics.artists' doesn't exist mysql error number: 1146 Date: Monday 16th 2007f April 2007 06:59:34 AM Script: /lyrics/lyrics.php Referer: http://www.videos-lyrics.com/lyrics/ But that lead to a new problem as it says it is not possible to create it...i am a newbie and have no knowledge about this..i hope u all can solve this query of mine..i will be really very thankful to u Regards KJS
Database has syntax rules and does not like some characters...try to make table name like this: lyrics_artist or just like this lyricsartist.
Yeh boulder its right, rename lyrics.artist to lyrics_artist. Also its not a good practice to use special characters for Object names in programming.