Anyone Can help me with this mysql fetch form ?

VB Code:

If CNN.State <> 0 Then
Set rsshow = CNN.Execute("select * from status")
    Do While Not rsshow.EOF
    txtChat = rsshow(1)
    Loop
        CNN.Close
    End If

Yes, and?

Doncha just love it when people not only want to to answer their question, but also work out the what the question might possibly be?

I'll make the answer (to what I assume the question is) a bit more obvious: You are missing a movenext.

i jus wana fetch the fields but it cant fetch with this script that i did

I have no idea what you know about coding databases (or what you have tried), so I can only suggest to try looking at some working code - the code from the "ADO Tutorial" link in my signature is a good example.

If that doesn't help, please be more specific about what the problems are.