1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Database:( Plz help me out webmasters

Discussion in 'MySQL' started by kanwarjot, Apr 16, 2007.

0
  1. #1
    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
     
    kanwarjot, Apr 16, 2007 IP
  2. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2
    Database has syntax rules and does not like some characters...try to make table name like this: lyrics_artist or just like this lyricsartist.
     
    Boulder, Apr 16, 2007 IP
    designcode likes this.
  3. designcode

    designcode Well-Known Member

    Messages:
    738
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    118
    #3
    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.
     
    designcode, Apr 16, 2007 IP
  4. kanwarjot

    kanwarjot Notable Member

    Messages:
    3,256
    Likes Received:
    283
    Best Answers:
    0
    Trophy Points:
    230
    #4
    thx for the info masters...:)
     
    kanwarjot, Apr 17, 2007 IP
  5. hclhost.com

    hclhost.com Banned

    Messages:
    257
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #5
    use _ in lue of . because in data base u can't use . for the tables
     
    hclhost.com, Apr 17, 2007 IP