List:General Discussion« Previous MessageNext Message »
From:ck nuke Date:November 21 2002 3:01am
Subject:mysql query error
View as plain text  
Hi

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???

_________________________________________________________________
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com 

Thread
mysql query errorck nuke21 Nov
  • Re: mysql query errorDan Nelson21 Nov
  • extracting submatches from regular expressionsMurad Nayal21 Nov