Reverse Limit?

jabba_29

Is there anyway of selecting all from a table except the last 10 records ordered by date desc?

I thought about one query to get the last 10 ids, then inserting that into a second query but I am not sure how to do it..

Example:

$nresult = mysql_query("SELECT id FROM `news` ORDER BY date DESC LIMIT 5");
while ($row=mysql_fetch_array( $nresult )):

$id = "'".$row[0]."'";

Then insert into second as $news -this is what I am stuck on !

$anresult = mysql_query("SELECT id, date, user, subject, content FROM `news`WHERE id NOT IN ($news) ORDER BY date DESC");

Aditional info:

ID is autoincremental.
I have been looking at the manual and substr("$news", 0, -1) takes off one character in every occurent of the id..

Any advice / comments / solutions really welcomed :p
It is driving me nuts :mad:

Jamie

mahers

Just as a thought could you try.

// Count all the records in the db
$totalrecs = mysql_query("SELECT count(*) FROM 'news'");
// perform other required db functions. etc

// Subtract 10
$limit = ($totalrecs - 10);

// Perform query using $limit
$data = mysql_query("SELECT id, date, user, subject, content FROM `news' ORDER BY date DESC LIMIT 0,".$limit."");

Not actually sure about this, still uses two queries unfortunatly.
😕

jabba_29

Hi Mahers,

thanks for the reply.

I tried the code, but it limits the wrong way.

i.e. it takes the first ten items off.

If I was doing the query with date asc. then this would be perfect.

Is there anyway to get the information from that query, then reverse it?

Thanks again.

Jamie

mahers

Whoops my bad.

// Count all the records in the db
$counter = mysql_query("SELECT count(*) FROM 'news'");

// Perform query
$result = mysql_query("SELECT id, date, user, subject, content FROM `news' ORDER BY date DESC");

while($row = mysql_fetch_array($data)) {
    if($counter>10) {
        echo $row['date'];
        // Etc...
        $counter--;
    }
}