Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Results 1 to 10 of 10

Thread: MySql Error

  1. #1
    Join Date
    Apr 2006
    Location
    wolvo init lol.
    Posts
    2,272
    Tokens
    0

    Latest Awards:

    Default MySql Error

    Hi, I just uploaded a DJ panel - http://www.samsterteenzradio.com/staff2/Panel But I cant create a user, and when I just click the login link, I get this error...

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sradio/public_html/staff2/Panel/index.php on line 35

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sradio/public_html/staff2/Panel/index.php on line 37
    Your Username And Password Did Not Match


    Line 35 has this:
    list($user) = mysql_fetch_array(mysql_query("SELECT `username` FROM `staff` WHERE username='$user1_post'"));

    Line 37 has this:
    list($pass) = mysql_fetch_array(mysql_query("SELECT `password` FROM `staff` WHERE password='$pass1_post'"));


    Any ideas whats wrong and how I could create a user?

  2. #2
    Join Date
    Jun 2006
    Location
    Nottinghamshire
    Posts
    184
    Tokens
    0

    Default

    I had the same problem. have you chenged the MySQL details in you config file? If you have try that, if you haven't then repost and Ill have a look.
    Last edited by The Voice; 03-08-2006 at 07:39 PM.

  3. #3
    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    3,384
    Tokens
    0

    Latest Awards:

    Default

    The problem is you havn't added an account so you cannot select an account from drop down list.


    Xbox Live: Jholder112233
    PS3 Online Tag: Josh-H

    Last.fm | Digg | Xbox.com

  4. #4
    Join Date
    Apr 2006
    Location
    wolvo init lol.
    Posts
    2,272
    Tokens
    0

    Latest Awards:

    Default

    Yes, I have changed all the details. And I know I havent added an account, thats cause I dont know how, theres no page to do it on, or if there is, I cant find it.

  5. #5
    Join Date
    Sep 2005
    Posts
    1,604
    Tokens
    0

    Latest Awards:

    Default

    It's becuase you havent inserted the tables in PHPmyadmin

    Becuase the pael you have (i'm guessing) didnt come with an install folder?

  6. #6
    Join Date
    Apr 2006
    Location
    wolvo init lol.
    Posts
    2,272
    Tokens
    0

    Latest Awards:

    Default

    Oh I have no idea how to usr that lol. Nor does it tell me where to insert the tables in phpmyadmin lol

  7. #7
    Join Date
    Mar 2005
    Location
    Kidlington, Oxford.
    Posts
    7,274
    Tokens
    0

    Latest Awards:

    Default

    What DJ panel is it?

  8. #8
    Join Date
    Aug 2006
    Posts
    27
    Tokens
    0

    Default

    I will create you an install folder for Ł1.50 paypal if you want?

  9. #9
    Join Date
    Apr 2006
    Location
    wolvo init lol.
    Posts
    2,272
    Tokens
    0

    Latest Awards:

    Default

    No thanks, dont have paypal. Id pay habbo furni, doubt if youd be interested though.

  10. #10
    Join Date
    Sep 2005
    Posts
    1,604
    Tokens
    0

    Latest Awards:

    Default

    offer in habbo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •