In the last episode (Nov 21), ck nuke said:
> I have a problem about : mysql query
> I need help for this.
> Sever: mysql Version: 4.0.4-bata
> SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT
> 0,1
> When use this command, no result
> -------------------------------------------------------------------
> SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t,
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.pid DESC LIMIT 0,1
> When use this command, have one result
> -------------------------------------------------------------------
> SELECT pid FROM cdb_posts ORDER BY dateline DESC
> When use this command, have results
> -------------------------------------------------------------------
> Don't know where is the mistake???
Upgrade to 4.0.5. From the changelog:
* Fixed a newly introduced bug that caused 'ORDER BY ... LIMIT #' to
not return all rows.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
