Go Back   Webmaster Forum > Development > Database and SQL
REMOVE the ads below !
Reply
 
LinkBack Thread Tools
  # 1 (permalink)
Old
Newbie
Posts: 12
Join Date: Mar 2008
iTrader: (0)
need help - 03-27-2008

Can anybody tell me what that means? I get it on the front page of my site.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a3030916/public_html/config.php on line 29

No database selected
Reply With Quote
  # 2 (permalink)
Old
Junior Geek
Posts: 142
Join Date: Feb 2007
iTrader: (0)
03-27-2008

As it said, you need to select a database on your config.php page.


Thanks,
Aqua


-------------------
http://www.aquafolie.org
Reply With Quote
  # 3 (permalink)
Old
Web Developer
Posts: 2,256
Join Date: Feb 2007
iTrader: (0)
Location: Bhopal (MP, India)
03-27-2008

You need to "correctly" fill up your database settings/values in the given PHP file.
(ie, config.php)


My periodic table contains only 1 element : the element of Surprise.
Reply With Quote
  # 4 (permalink)
Old
Super Moderator
Posts: 431
Join Date: Nov 2007
iTrader: (0)
Location: Karachi
03-27-2008

Simply Browse to Config.php From your File Manager.

- Open Config.php in the Code Editor. Scroll to Line 29. Follow the Function till the line where a Misinterpreted Database value may exist or not. Correct that.


Xyber 3D Studios
Designing with a difference


Reply With Quote
  # 5 (permalink)
Old
Newbie
Posts: 12
Join Date: Mar 2008
iTrader: (0)
03-27-2008

while($r2=mysql_fetch_array($q2)) that is my line 29. I cant tell whats wrong wih the line.
Reply With Quote
  # 6 (permalink)
Old
Senior Geek
Posts: 591
Join Date: Jan 2008
iTrader: (0)
Location: Craiova
04-24-2008

Quote:
Originally Posted by richierich813 View Post
while($r2=mysql_fetch_array($q2)) that is my line 29. I cant tell whats wrong wih the line.

because this stade of script depend on where u have entred your database password.

Check your mods one more time .
Reply With Quote
  # 7 (permalink)
Old
Newbie
Posts: 9
Join Date: May 2008
iTrader: (0)
05-11-2008

Read some php/mysql programming tutorial.
Reply With Quote
  # 8 (permalink)
Old
Web Developer
Posts: 2,256
Join Date: Feb 2007
iTrader: (0)
Location: Bhopal (MP, India)
05-12-2008

Looks like Line 29 doesn't need any changes.

It's the values you have filled in that file (before line 29, ie, in the first 28 lines somewhere)
that you need to correct.


My periodic table contains only 1 element : the element of Surprise.
Reply With Quote
  # 9 (permalink)
Old
Newbie
Posts: 8
Join Date: Dec 2007
iTrader: (0)
05-27-2008

The error is not in line 29, but perhaps in the code before it. The error occurs because the resulting query ends up with no result.
Checking your MySQL authentication may help.
Reply With Quote
  # 10 (permalink)
Old
Ali
Moderator
Posts: 44
Join Date: Feb 2008
iTrader: (0)
Location: California
07-04-2008

I had this problem about an hour ago
$q2 is trying to read data from a table that doesn't exist, check the name of the db.
Reply With Quote
Reply


Thread Tools




vBulletin®, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd. | SEO by vBSEO | Skin developed by vBStyles.com