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
  •