Display and order a number of results from MySQL database using PHP

Question

I want to display and order a number of results to my webpage.

I'm still a starter with PHP but I have the following code to echo (all) data and that works pretty fine but I don't know if the code is good if I only want to show for example 5 results. And if that would work, how could I order them? (Like a top 5 for quickest time scores)

$dbhost = 'host';
$dbuser = 'user';
$dbpass = 'pass';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
    die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT name, company, time FROM tablename';

mysql_select_db('databasename');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
    die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_NUM))
{
    echo 
        "name: {$row[0]}  <br> ".
        "company: {$row[1]} <br> ".
        "time: {$row[3]} <br> "
    ;
}
mysql_free_result($retval);
mysql_close($conn);

I should somewhere add ORDER BY but can't find the right solution.

i think you was looking for this SELECT name, company, time FROM tablename ORDER BY columnname LIMIT 5 — krishna
– krishna, Commented Feb 20, 2014 at 10:56
mysql_* functions are deprecated ... please try to use mysqli_* or PDO — Tun Zarni Kyaw
– Tun Zarni Kyaw, Commented Feb 20, 2014 at 10:58

Krish R · Accepted Answer · 2014-02-20 10:56:16Z

1

Try this,

$sql = 'SELECT name, company, `time` FROM tablename   ORDER BY name ASC LIMIT 5';

answered Feb 20, 2014 at 10:56

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erwin van Ekeren Over a year ago

i already tried something like this but then it didn't work, somewhere I made a mistake because this one works, thanks!

Kyle · Accepted Answer · 2014-02-20 10:56:12Z

0

$sql = 'SELECT name, company, time FROM table name'; should be

$sql = 'SELECT name, company, time FROM table name ORDER BY column_name ACS | DESC';

Take a lot at the docs here.

answered Feb 20, 2014 at 10:56

Kyle

3272 silver badges12 bronze badges

1 Comment

Erwin van Ekeren Over a year ago

Thanks Kyle, this also works (like the answer of Krish), but I was searching for the limit too so I need to choose his answer as the right one this time, I'm sorry! Thanks for the link to the docs!

user3004356 · Accepted Answer · 2014-02-20 11:07:10Z

0

$sql = SELECT name, company, time FROM tablename ORDERBY columnname LIMIT n;

Here n refers to number of records to be shown.

edited Feb 20, 2014 at 11:07

answered Feb 20, 2014 at 10:59

user3004356

8784 gold badges17 silver badges50 bronze badges

Collectives™ on Stack Overflow

Display and order a number of results from MySQL database using PHP

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related