php and mysql selecting 5 rows from mysql

Question

i am tryng to select 5 mysql rows from the database and display them like $row[1] ect.... in php i am not sure how to do it an someone lead me down the right way please Ok i hav looked a bit more

i wanted it to come out 1 - 5 and i wanted it to display the names

 $result = mysql_query("SELECT * FROM table  ORDER BY id DESC") or die (mysql_error()); 
 while ($row = mysql_fetch_array($result)) { 
  $name = $row['name'];

  $arr = array("somearray" => array(1 => 5, 2 => 9, 3 => 42, 4 => 42, 5 => 42));
  echo $arr["somearray"][1];
  echo $arr["somearray"][2];
  echo $arr["somearray"][3];
  echo $arr["somearray"][4];
  echo $arr["somearray"][5];

  }

dont have any thats why i am asking for help

Rickstar
– Rickstar

2009-10-23 18:15:40 +00:00
Commented Oct 23, 2009 at 18:15 — Rickstar
– Rickstar, Commented Oct 23, 2009 at 18:15

jlee · Accepted Answer · 2009-10-23 18:23:21Z

3

I think the OP wants five ROWS, not COLUMNS. Here is the correct code, assuming you already have a mysql connection open:

$sql = 'SELECT *
    FROM table_name
    ORDER BY col_name
    LIMIT 5';

$result = mysql_query($sql);

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

    $row[] = $line;

}

// print (access individual rows: $row[0] ... $row[4])
var_dump($row);

answered Oct 23, 2009 at 18:23

jlee

4925 silver badges15 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-21 15:10:29Z

0

From php.net : https://www.php.net/manual/en/function.mysql-fetch-row.php

<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);

echo $row[0]; // 42
echo $row[1]; // the email value
?>

edited Nov 21, 2023 at 15:10

CommunityBot

11 silver badge

answered Oct 23, 2009 at 18:19

Zak

25.3k11 gold badges42 silver badges68 bronze badges

Comments

Asaph · Accepted Answer · 2009-10-23 18:33:21Z

0

Try using MySQL's LIMIT clause to limit your results to 5 rows. And use PHP's mysql_fetch_assoc() (returns an associative array) instead of mysql_fetch_row() (returns a numerically indexed array). Also, it's good practice to free the memory associated with the result using mysql_free_result().

$result = mysql_query("SELECT * FROM mytable ORDER BY id DESC LIMIT 5") or die (mysql_error()); 
while ($row = mysql_fetch_assoc($result)) { 
    $name = $row['name'];
    echo $name;
}
mysql_free_result($result);

answered Oct 23, 2009 at 18:33

Asaph

164k25 gold badges204 silver badges204 bronze badges

Comments

Justin Ethier · Accepted Answer · 2009-10-23 18:42:33Z

0

If you only need to select 5 rows from MySQL you can do this:

SELECT * 
  FROM Table
ORDER BY column
LIMIT 5

edited Oct 23, 2009 at 18:42

answered Oct 23, 2009 at 18:15

Justin Ethier

135k53 gold badges235 silver badges291 bronze badges

Collectives™ on Stack Overflow

php and mysql selecting 5 rows from mysql

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related