rockwood

MCC mysqli db class is very old and not enough so if possible than use AB's mysqli db class (NWE).

try this $db->query("INSERT INTO p_messages(pmc_id, s_id, r_id, message, time) VALUES($c_id,$userid,$fr_id,$pmessage, NOW())"); now() should without quotes bcz it is predefined function for mysql current date & time

you should escape values

if(array_key_exists('id', $_POST)) i think if(isset($_POST['id'])) is better bcz is much faster

it is ruthless engine as far as i can guess

FULLTEXT searches are absolutely going to be faster select COUNT(columnname) FROM table WHERE INSTR(columnname,'keyword') > 0; or follow this http://www.joedolson.com/boolean-query-in-mysql.php

it is very weird problem

possible to see your url for testing purpose ?

i think reasonable amt as per game

onmouseout='style.backgroundColor='#ECEAEA ';' is looking fine ? may be it is error part

Looking Awesome and Best of luck

But few Cheap too

my suggestion :-buy a nice VPS

Monthly Most Active Player on random basis with attached activates

promise from my side you can't remove this error without change

your provided link is not working for me otherwise i can check properly

good worked

* is doing what ? its not for db problem ?? if you can do this vi /etc/my.cnf "mysql -e "set global max_connections = 700;"" and you should optimize your queries yes. But you can also run the command i gave u

in html bad quotes also make some difference (due to quotes reading matter )

<?php require("top.php"); ?> <?php require("usercheck.php"); require("prison_check.php"); ?> <form method="post"> <table width="550" border="0" align="center" cellpadding="0" cellspacing="2" class="table"> <tr> <td colspan="3" align="left" class="head">Top 10 Ranked Players:</td> </tr> <tr> <td width="150" align="left" class="sub">Name:</td> <td width="150" align="left" class="sub">Rank:</td> <td width="250" align="left" class="sub">Gang:</td> </tr> <?php $result = mysql_query("SELECT name,gang,exp,rank FROM login WHERE staff='0' AND sitestate='0' ORDER BY exp + 0 DESC LIMIT 0,10") or die(mysql_error()); // keeps getting the next row until there are no more to get while ($row = mysql_fetch_array($result)) { // Print out the contents of each row into a table ?> <tr> <td width="150" align="left" class="cell"><?php echo "<a href=\"view_profile.php?name=" . $row['name'] . "\" onFocus=\"if(this.blur)this.blur()\">" . $row['name'] . "</a>"; ?></td> <td width="150" align="left" class="cell"><?php echo $rank_array[$row['rank']]; ?></td> <td width="250" align="left" class="cell"><?php if (empty($row['gang'])) { echo "No Gang."; } else { echo "<a href=\"view_gang.php?name=" . $row['gang'] . "\" onFocus=\"if(this.blur)this.blur()\" >" . $row['gang'] . "</a>"; }?></td> </tr> <?php } // while ?> </table> <table width="550" border="0" align="center" cellpadding="0" cellspacing="2" class="table"> <tr> <td colspan="3" align="left" class="head">Top 10 wealthiest Players:</td> </tr> <tr> <td width="150" align="left" class="sub">Name:</td> <td width="150" align="left" class="sub">Wealth:</td> <td width="250" align="left" class="sub">Gang:</td> </tr> <?php $result = mysql_query("SELECT money,name,gang FROM login WHERE staff='0' AND sitestate='0' ORDER BY money + 0 DESC LIMIT 0,10") or die(mysql_error()); // keeps getting the next row until there are no more to get while ($row = mysql_fetch_array($result)) { // Print out the contents of each row into a table ?> <tr> <td width="150" align="left" class="cell"><?php echo "<a href=\"view_profile.php?name=" . $row['name'] . "\" onFocus=\"if(this.blur)this.blur()\">" . $row['name'] . "</a>"; ?></td> <td width="150" align="left" class="cell"><?php if ($row['money'] >= 0) { $profile_wealth = $wealth_array[0]; } if ($row['money'] >= 25000) { $profile_wealth = $wealth_array[1]; } if ($row['money'] >= 50000) { $profile_wealth = $wealth_array[2]; } if ($row['money'] >= 100000) { $profile_wealth = $wealth_array[3]; } if ($row['money'] >= 250000) { $profile_wealth = $wealth_array[4]; } if ($row['money'] >= 500000) { $profile_wealth = $wealth_array[5]; } if ($row['money'] >= 1000000) { $profile_wealth = $wealth_array[6]; } if ($row['money'] >= 10000000) { $profile_wealth = $wealth_array[7]; } if ($row['money'] >= 1000000000) { $profile_wealth = $wealth_array[8]; } if ($row['money'] >= 10000000000) { $profile_wealth = $wealth_array[9]; } echo $profile_wealth;?> </td> <td width="250" align="left" class="cell"><?php if (empty($row['gang'])) { echo "No Gang."; } else { echo "<a href=\"view_gang.php?name=" . $row['gang'] . "\" onFocus=\"if(this.blur)this.blur()\" >" . $row['gang'] . "</a>"; }?></td> </tr> <?php } // while ?> </table> </p> </form> <?php require("bottom.php"); ?> try now

still having problem ? thats a mysql limitation, but you may need to just add db indexes(http://dev.mysql.com/doc/refman/5.0/en/create-index.html) if your queries are taking so long that 30 of them are processing at the same time (unless you have thousands of users on at once) help link :- https://dev.mysql.com/doc/refman/5.0/en/user-resources.html you could release your connection as soon as you're finished with it, you could perform faster queries, you could raise your limit on the mysql side, there's no easy debugging that in a jiffy

me too do when my complete

from where are you using JQuery lib ??(means using by online or on your server)

for mod rewriting, you have to know Regex properly and as per my view by mod_rewriting you can make url nicer and less input way for users

please click on Tools->Web Developer->Error Console and if you get any error paste here note : - after execution of code it will be show error