Can't Select Database =? - It works on my home PC

free web hosting
Free Web Hosting > Advanced Free Professional Web Hosting > Hosting Support & Help

Can't Select Database =? - It works on my home PC

Feelay
Hey!

I've made a register script. It works on my home pc, but when I upload it to astahost, it don't work =/
This is the error meesage I am getting:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/feelay/public_html/regcheck.php on line 35
You Could Not Register Because Of An Unexpected Error.
Error: No database selected


I know the error is from the database.. But I don't know exactly how the astahost database works.. My username is feelay_myname
i think, and the databasename should be feelay_thedatabasename. But still it ain't working.

Reply

turbopowerdmaxsteel
Have you granted appropriate permissions to the MySQL username feelay_myname on the database? If not, you can do this via the CPanel.

Reply

Feelay
Yes I have. the "All" checkbox is checked.
But still I can't select the database =/

Reply

sparkx
When I get this error it is often because of some invalid row() array. You might want to look around at your script on line 35 and see what mysql action is going on. If you absolutely cannot figure out what is going on I suggest you use this little tip. Press <enter> before and after the suspected mysql string. If it only moves down one line then you found your problem otherwise it is not the problem.

I think you get this error when you have look for the number of results in a database that does not exist. Common errors may be case sensitivity and incorrect spelling of database name.

Sorry I can't really suggest anything more other then look closely at your query and maby even post it here if you continue having errors.

Sparkx

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

Recent Queries:-
  1. cpanel select database - 69.82 hr back. (1)
  2. cannot select db - 128.04 hr back. (1)
  3. cannot select db php - 128.71 hr back. (2)
  4. error: sorry cannot select database.php - 168.75 hr back. (1)
  5. select database php cpanel - 353.63 hr back. (1)
  6. "can’t select database" mysql - 383.85 hr back. (1)
  7. cannot select database php - 279.23 hr back. (2)
  8. php cannot select database - 589.32 hr back. (1)
Similar Topics

Keywords : select, database, works, home, pc

  1. Database Priveleges Lost
    (2)
  2. Web Space And Mysql Database
    (3)
    hi every body : at the first thank you for reading this . i 'm about searching a web host that
    supports php+mysql with no limited bandwith and always i found that the web space 100-500 mb and
    suuport mysql my question is when they provide for example 100mb and mysql is the size of your
    database is incluse in 100mb or not !! thank you for your reading and for your replay....
  3. Database Disk Space Usage?
    (3)
    When I was still utilizing the services of trap17, I always wondered whether the disk space used by
    databases was actually applied to the disk space usage total on my account. Is this true? I'm
    just curious. I never bothered to ask in Trap17 ....
  4. What's Wrong With "my Assistant?
    Somedays it works somedays it does not? (0)
    I have noticed that somedays the "My Assistant" feature of this forum works but then other days when
    I click on the "My Assistant" link it opens a new window and redirects me to the index of the forum
    /huh.gif' border='0' style='vertical-align:middle' alt='huh.gif' /> . Does anyone know why?
    /blink.gif' border='0' style='vertical-align:middle' alt='blink.gif' /> /unsure.gif' border='0'
    style='vertical-align:middle' alt='unsure.gif' /> ....
  5. Database
    (2)
    ummm, if i get hostin will it include a database and will i be able 2 install a fourm wit it, if not
    where can i a free one , and be able 2 host fourms Misplaced query. Topic moved. ....
  6. Database Setups - Errors - Settings Etc
    READ IT ANY COST IF YOU DONT KNOW DATABASE (0)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....

    1. Looking for select, database, works, home, pc






*SIMILAR VIDEOS*
Searching Video's for select, database, works, home, pc
advertisement




Can't Select Database =? - It works on my home PC