dk01 — Thu, 05 May 2005 15:23:45 +0000

Yeah I am 4.0 also. I am just using 2 queries. You'd think something simple like this wouldn't be a problem. Oh well!

Greg K — Wed, 04 May 2005 17:45:56 +0000

If you debugID's do not skip any numbers, from what I was reading in the manual, this should work if you are using mySQL 4.1 or above.
(sadly I'm at 4.0 something so I can't test it...)

Quote: SELECT DebugID, DebugText
FROM Debug
WHERE DebugID > (SELECT MAX(DebugID)-10 FROM Debug)
ORDER BY DebugID ASC

dk01 — Wed, 04 May 2005 16:46:24 +0000

Yup sorry MySql is what I am using. Bummer.

Greg K — Wed, 04 May 2005 16:38:27 +0000

if it is only 10 items, try something like this:

<?

	// already opened and did the sql query with
	// resutls into $dbResult

	$arDebug = array();
	
	while ($thisRow = mysql_fetch_assoc($dbResult))
		$arDebug[$thisRow['DebugID']] = $thisRow['DebugText'];
	
	ksort($arDebug);
	reset($arDebug);
	
	// Close database connection if not needed further
	// You now have a 10 element array with data in order
	
	echo "<table><tr><th colspan=2>Debug Info</th></tr>\n";
	foreach ($arDebug as $key => $value)
		echo "<tr><td>$key</td><td>$value</td></tr>\n";
	echo "</table>\n";

?>

timjpriebe — Wed, 04 May 2005 15:04:23 +0000

Not sure what DB you're using, but if it allows nested SQL statements in a LIMIT statement, the following should work:

SELECT DebugID, DebugText FROM Debug ORDER BY DebugID ASC LIMIT (SELECT COUNT(*) FROM Debug)-10, 10

If it won't allow it (I don't think mySQL will), you'll have to execute the nested one, pull in the count, then execute the other.

dk01 — Wed, 04 May 2005 14:52:52 +0000

All that does is get the first 10 records.

Looks like this:

| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello
| Hello Hello Hello

Any other suggestions?

-dk

chrishirst — Wed, 04 May 2005 08:13:26 +0000

ORDER BY column ASC '