Is there away to modify my code to get all the active online users. But instead of displaying all the names I would like it to goto a label instead with just a count of online users. Thanks a ton, and hope to get this working.
The following code works to display the user in a listbox, but I can't figure out how to change it to do what I would like to acheive. Been up for 27hrs now so going to rest a bit to help clear the mind also.
conn = New MySqlConnection("server= ;Port= ; user id= ; password= ; database= ")
Dim username As Boolean = True
Dim sqlquery As String = "SELECT * FROM accounts WHERE online = 'Online'"
Dim data As MySqlDataReader
Dim adapter As New MySqlDataAdapter
Dim command As New MySqlCommand
command.CommandText = sqlquery
command.Connection = conn
adapter.SelectCommand = command
data = command.ExecuteReader