[Resolved] MySql LIMIT Problem

[mehrzadsoft]

I wanna use Mysql and its Limit statement to show top 3 id in a database. but when i use my codes its show 3 last id but THE LAST ONE is omited.

e.g.:
id 01
id 02
id 03
id 04
id 05
id 06

and it shows:
05
04
03

and 06 is omited!!😕

what i can do???😕

my codes:

<?php
// load db
require ("sys/db.php");
$tblname="post_daily";

$link = mysql_connect($host, $user, $password) or die(mysql_error());
$query="SELECT * FROM $tblname ORDER BY id DESC limit 4";
$result=mysql_db_query($dbname, $query, $link);
$row=mysql_fetch_array($result);
$count=mysql_num_rows($result);

while ( $row=mysql_fetch_array($result) ) {
echo( $row["id"] . "<BR>");
}

mysql_close ($link);
?>

[mrhappiness]

<?php
// load db
require ("sys/db.php");
$tblname="post_daily";

$link = mysql_connect($host, $user, $password) or die(mysql_error());
$query="SELECT * FROM $tblname ORDER BY id DESC limit 4";
$result=mysql_db_query($dbname, $query, $link);
$row=mysql_fetch_array($result);
// addition - start
echo '<pre>';
print_r($row);
echo '</pre>';
// addition - end
$count=mysql_num_rows($result);

while ( $row=mysql_fetch_array($result) ) {
echo( $row["id"] . "<BR>");
}

mysql_close ($link);
?>

now you know where your "06" is, don't you? 😉

btw: why do youuse LIMIT 4 if you want the top 3?

[mehrzadsoft]

dear mrhappiness

Am confused with this scripts. i mean that i want to get 3 last records of database. can you help me more?

is LIMIT have some thing that says get 3 latest records, even the id numbers not be arranged (e.g. 01,02,03,05,08,...) (when user deletes some records i mean).😕

thanks

[liquorvicar]

yes, LIMIT will pick up the three highest ids if you use it in this way, whether they are in sequence or not:

<?php
// load db
require ("sys/db.php");
$tblname="post_daily";

$link = mysql_connect($host, $user, $password) or die(mysql_error());
$query="SELECT * FROM $tblname ORDER BY id DESC limit 3";
$result=mysql_db_query($dbname, $query, $link);
// addition - end
$count=mysql_num_rows($result);

while ( $row=mysql_fetch_array($result) ) {
echo( $row["id"] . "<BR>");
}

mysql_close ($link);
?> 

[mehrzadsoft]

🙂 Thanks Buddies

with your assistance my LONG headaches removed!

thanks alot mrhappiness and liquorvicar .🆒

[liquorvicar]

see that link at the bottom? the one that says 'Mark thread resolved'. if you click on that it makes it much easier for everyone.