help Query modification ...... last entry

[simou]

hi friends .....

i'm web designer ... my first days in MySQl . so please help me guys ....

i have this sql sentences " thanks russell" ....


select a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails, count(b.dlid) as numReplies,a.dlNew,b.replys ,replyDate
from topics a LEFT JOIN replys b On b.dlid = a.dlid WHERE a.dlState=1 group by a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails order by a.dldate desc



it's gives me the first reply and first replyDate but i want select the last reply and date .....

so please help me


my all regards

[vssp]

select a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails, count(b.dlid) as numReplies,a.dlNew,b.replys ,replyDate
from topics a LEFT JOIN replys b On b.dlid = a.dlid WHERE a.dlState=1 group by a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails order by b.replys desc

I think thsi query list the last replay

[simou]

thanks for your effort "vssp"...

but it's gives the first reply too....

[simou]

please ..... help ..... any ideas ....???

[vssp]

sorry Can you please send me the query rest and what you want this query so i able easy to understand your problem an dreplay immediatly .

Any other users also send any idea.

Thanks

[simou]

i told u befor i have two table topics & replys .. ok

i want select all data from this two tables but i want just the last replys from the second table ....


select a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails, count(b.dlid) as numReplies,a.dlNew,b.replys ,replyDate
from topics a LEFT JOIN replys b On b.dlid = a.dlid WHERE a.dlState=1 group by a.dltitle, a.dldate, a.dlid, a.clientName,a.dlDetails order by a.dldate desc

this sentence gives the first reply but i want only the last one ...

thanks again

all my regards

[russell]

what db are u using?

[simou]

thanks all ..... i really need select the last reply ....

by the way i'm using MySQL.....

please help guys

[chrismartz]

Change your order by to a.dldate asc

[simou]

i really need this query ...... please help me guys

[simou]

i still need it ...... please help