Who has the highest field

[eazyefolife]

Hello, I'm a pawn coder from the modification SA-MP (( http://www.sa-mp.com )) so please excuse me if I don't understand something. Anyways, I am trying to get the person with the most kills in the whole database, and display it. How can I do that? This is what I have so far:

 

mysql_query("SELECT * FROM users ORDER BY kills");

[trq]

mysql_query("SELECT * FROM users ORDER BY kills DESC LIMIT 1");

[eazyefolife]

mysql_query("SELECT * FROM users ORDER BY kills DESC LIMIT 1");

 

Thank's for the fast reply but I get a error now:

 

PHP Parse error: parse error in C:\Users\Eric\Desktop\phpdesigner_output_tmp.php on line 26 

[trq]

Might want to post your code then.

[eazyefolife]

Might want to post your code then.

<?php 
$host "xx.xx.xx.xx" // Blocked for safety
$user "x"  // Blocked for safety
$password "x"  // Blocked for safety
$db "x" // Blocked for safety
mysql_connect($host,$user,$password);
mysql_selectdb($db);
mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");

?>

 

Obviously I blocked all the regular stuff with x's. Check out my code and tell me what's wrong. 

 

[eazyefolife]

Strangly I managed to fix it. Now how would I make it show:

 

$msg = mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");
echo $msg;

 

Like that?

[oni-kun]

Strangly I managed to fix it. Now how would I make it show:

 

$msg = mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");
echo $msg;

 

Like that?

 

Well, you'd normally place it into a variable so you can go over the rows:

$q =  mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");

while($row = mysql_fetch_array($q)){ 
       echo '<pre>';
       echo print_r($row);
}

 

That can give you a better idea of what you're doing.

[eazyefolife]

Strangly I managed to fix it. Now how would I make it show:

 

$msg = mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");
echo $msg;

 

Like that?

 

Well, you'd normally place it into a variable so you can go over the rows:

$q =  mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1");

while($row = mysql_fetch_array($q)){ 
       echo '<pre>';
       echo print_r($row);
}

 

That can give you a better idea of what you're doing.

 

nothing wont show up

 

[trq]

You don't need a while loop because your only selecting one row.

 

<?php 
$host "xx.xx.xx.xx" // Blocked for safety
$user "x"  // Blocked for safety
$password "x"  // Blocked for safety
$db "x" // Blocked for safety
mysql_connect($host,$user,$password);
mysql_select_db($db);
if ($result = mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1")) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_array($result);
    print_r($row);
  } else {
    echo "No results found";
  }
} else {
  trigger_error(mysql_error());
}
?>

[eazyefolife]

You don't need a while loop because your only selecting one row.

 

<?php 
$host "xx.xx.xx.xx" // Blocked for safety
$user "x"  // Blocked for safety
$password "x"  // Blocked for safety
$db "x" // Blocked for safety
mysql_connect($host,$user,$password);
mysql_select_db($db);
if ($result = mysql_query("SELECT * FROM users ORDER BY Kills DESC LIMIT 1")) {
  if (mysql_num_rows($result)) {
    $row = mysql_fetch_array($result);
    print_r($row);
  } else {
    echo "No results found";
  }
} else {
  trigger_error(mysql_error());
}
?>

 

Now only ?> is showing on the web page.. (( Bug? ))

[trq]

Not a bug in the code, maybe a bug in your server. What do you see when you right click and view source?

[eazyefolife]

Not a bug in the code, maybe a bug in your server. What do you see when you right click and view source?

just shows my code exactly from dreamweaver..

[trq]

php and all?

[eazyefolife]

php and all?

 

yes

[trq]

Is your server configured to parse php? It would appear not.

[eazyefolife]

Is your server configured to parse php? It would appear not.

 

what?

[oni-kun]

Is your server configured to parse php? It would appear not.

 

what?

 

We're wondering why it would display the PHP source in the first place. Are you viewing the file directly on web browser by chance?

(IE: C:\files\this.php)

 

And as well, is it .php? Web servers are not really configured to run them off default extensions like .phtml etc.

[trq]

Is your server configured to parse php? It would appear not.

 

what?

 

In order to execute php code you need a server configured to execute php code. Is yours?

[eazyefolife]

Is your server configured to parse php? It would appear not.

 

what?

 

In order to execute php code you need a server configured to execute php code. Is yours?

 

yes

[trq]

If you can see the php code in the browser it would appear it is not configured properly. As oni-kun asked, are you using the .php extension for this file?

[eazyefolife]

If you can see the php code in the browser it would appear it is not configured properly. As oni-kun asked, are you using the .php extension for this file?

yes

[trq]

Are you accessing the site via a url like http://localhost/filename.php ?

 

Can you make a simple test file and place this in it?

 

<?php phpinfo(); ?>

 

What does that display?

[eazyefolife]

Are you accessing the site via a url like http://localhost/filename.php ?

 

Can you make a simple test file and place this in it?

 

<?php phpinfo(); ?>

 

What does that display?

 

I dont understand?

[Buddski]

What do you type into your browser to view your file...

[eazyefolife]

What do you type into your browser to view your file...

 

Firefox (( I also tried opening it with IE and OPERA ))