database error help : too many connections :

fivesevenzero

Warning: Too many connections in /usr/local/psa/home/vhosts/fivesevenzero.com/httpdocs/home/news.php on line 46

Warning: MySQL Connection Failed: Too many connections in /usr/local/psa/home/vhosts/fivesevenzero.com/httpdocs/home/news.php on line 46
Unable to connect!

this is my code for the script if curious...

include("../admin/news/conf.php");
include("../admin/news/functions.php");

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

mysql_select_db($db) or die ("Unable to select database!");

$query = "SELECT id, title, brief, timestamp FROM news ORDER BY timestamp DESC LIMIT 0, 3";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if (mysql_num_rows($result) > 0)
{

while($row = mysql_fetch_object($result))
{

then the normal if else and close connection code...

wilsonodk

everything looks in order,
do either of your included files open a connection?

fivesevenzero

my configuration or conf.php has my database configuration thats about it...

Daggeth

But do any of em actually open the database itself?

It might help to close the connections (if there are any open) before oppening your new one.

fivesevenzero

I think i figured out my problem. on the same page i have another table being opened up from the same database.

so i have a new question

instead of opening the database again for the other table. how can i execute both tables from the same db connection?

or how about this...

where can i find tutorials or help that will alow me to run more then one query from one "master" database?

for example...

i have a table for news, and say a table for music reviews, and i want to view both on the same page...

im a new at this, sorry...

RoadKingHD

You may query more than one table after you connect to the DB. It is not necessary to open a new connection to run a query on a second (or more) table(s).

 
include("../admin/news/conf.php"); 
include("../admin/news/functions.php"); 

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

mysql_select_db($db) or die ("Unable to select database!"); 

$query = "SELECT id, title, brief, timestamp FROM news ORDER BY timestamp DESC LIMIT 0, 3"; 

//query 2
$query2 = "SELECT id, title, brief, timestamp FROM someOtherTable ORDER BY timestamp DESC LIMIT 0, 3"; 

$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

//result set 2
$result2 = mysql_query($query2) or die ("Error in query: $query. " . mysql_error());

Hope this helps

Kevin