LIMIT

[rascle]

Hi

I am trying to limit this so that it only shows the first 5 results but it is showing all of the what should i do?

Here is the code-

<?php
include "config.php";  
$result = mysql_query("SELECT * FROM members WHERE username = '$logged[username]' LIMIT 0,5");
if($logged){
    while($data = mysql_fetch_array($result))
    {
        echo"<font size=\"4\">";
        echo $data['recentgames'];
        
    }
}
?> 

 

Thanks

[premiso]

$result = mysql_query("SELECT * FROM members WHERE username = '$logged[username]' LIMIT 5");

 

You have multiple users with the same username? That is a flaw in itself imo...

[rascle]

That didnt work

[premiso]

Where is $logged being populated from? I fail to see that part...

[rascle]

$logged is coming from config.php (include "config.php") but that doesnt matter i just need to Limit it, and that is the thing that isnt working it just shows everything in that table.

[premiso]

$logged is coming from config.php (include "config.php") but that doesnt matter i just need to Limit it, and that is the thing that isnt working it just shows everything in that table.

 

Silly question, but is the file being updated properly and or uploaded after (if needed).

 

I ran a similar query on my server and it limited it to 5 just fine for me.

[rascle]

Yes i think so because i make minor changes on the same page like change the text and that all works fine.