Selecting Certain Rows

[Imtehbegginer]

Hey,

I was just wondering, how to select, only the TOP 5 rows. Not all of them, just the top 5. Can anyone tell me how to do this?

[marked]

Hi,

If you're talking about using MySQL you can write SELECT * FROM table LIMIT 5

That will get you the top 5 rows.  Of course you can add in any WHERE, ORDER BY etc that you need.

Thanks
mark

[Imtehbegginer]

Awsome! Thanks alot.

[Imtehbegginer]

[code]<?php
    include 'config.php';
  $result = mysql_query("SELECT char_name FROM characters LIMIT 5")
or die(mysql_error()); 
$echos = $row['char_name'];
echo $echos;
?>[/code]

That's my code, my config.php file connects to mysql. It doesnt show anything, just shows a blank page.

[marked]

Hey,

you need to use something like mysql_fetch_array like so:

[code]
$result = mysql_query("SELECT char_name FROM characters LIMIT 5") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
    $echos .= $row['char_name'];
}
echo $echos;
[/code]

This will also append the results to the $echos variable, rather than keep overwriting it.

Thanks,
mark

[Imtehbegginer]

That works,

Now I get

Brett19DeathcodeGenesisStrikeXRoseBot All of the rows together. How can I split them up?

[marked]

throw in a line break or however you want to split them like so:
[code]
$echoes .= $row['char_name'] . '<br />';
[/code]

This will append a line break to the end of every row.

Thanks,
mark