Simple Query

[Krusifix]

ok here it is in a nutshell.......i want to query a stats db..... i only want it display the top 5 ranks players.... by id or kills i really dont care...... i have no idea how to set this query up but it must be written in php .....

can anyone give me a clue?😕

[JMJimmy]

read the php/mysql manuals & these forms there are hundreds of examples

[Krusifix]

ok where do i find those? the manuals that is

[statrat]

$query = "Select id, kills from stats order by kills limit 0,5";
$result = mysql_query($query) or die("Query failed");

while ($row = mysql_fetch_array($result){

echo $row['id'] $row['kills'];
}

[Krusifix]

ok this is what i got but i getting parse error in the last line

<?

require "connect.php"; // Contains your mySQL functions

?>

<?

$connection = mysql_connect ($dbhost, $dbuser, $dbpass);
if ($connection == false){

  echo mysql_errno().": ".mysql_error()."<BR>";
  exit;
}

$db = mysql_select_db($dbname);
if (empty($act)) {

?>
<?php
	$get = mysql_query("SELECT * FROM `bab_scores` WHERE 1 ORDER BY `score` DESC LIMIT 0, 5; ");
	$num = mysql_num_rows($get);
	$total = $num-$amount;
	$result = mysql_query($query);
		 $numOfRows = mysql_num_rows ($result);
		  for ($i = 0; $i < $numOfRows; $i++) {
			$id = mysql_result ($result, $i, "id");
?>	 
<?php
	$query = "INSERT INTO $tablename VALUES ('$score')";
	$result = mysql_query($query);
		mysql_close();
   }
?>

Please view the error so you can see what im dealing with...

View Error Here

[statrat]

what is line 34?

SELECT * FROM bab_scores WHERE 1 ORDER BY score DESC LIMIT 0, 5;

no semicolon, and no single quotes (i think).
and what is "1"

[Krusifix]

the very last line is the error

view the link to see it

[statrat]

i think maybe you're missing a closing brace.

either your "if (empty($act)) {"

or your

"for ($i = 0; $i < $numOfRows; $i++) {"

never closes. unless you left some code out.

[Krusifix]

ok here it is refined...... no erros however access denied...

<?    

$dbhost = "localhost";
$dbname = "dfextrem_bab";
$dbuser = "dfextrem_babby";
$dbpass = "babby";

$tablename = "bab";


mysql_pconnect($dhost, $dbusername, $dbpassword) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());



// include "connect.php"; // Contains your mySQL functions    


$query = mysql_query("SELECT * FROM bab_stats WHERE total_kills DESC LIMIT 0,5") or die(mysql_error());

while($row = mysql_fetch_array($query)) {
echo $row[total_kills];
}

?>
  </div></td>
  </tr>
</table>

View Denied Access Error Here

[Krusifix]

problem solved everyone...thanks for all the support....

SEE LAYOUT THREAD FOR CURRENT ISSUE