VB.NET-Quellcode
- Dim ReadShouts As MySqlLib.ResultCollection = db.Query("SELECT * FROM shoutbox")
- Dim ReadShoutsCount As Integer = ReadShouts.Row.Count
- For i As Integer = 0 To ReadShoutsCount - 1
- Dim ReadShoutUsername As MySqlLib.ResultCollection = db.Query("SELECT * FROM users WHERE id='" + ReadShouts.Row(0).Column("user_id") & "'")
- ListBox1.Items.Add(ReadShoutUsername.Row(i).Column("username") & ": " + ReadShouts.Row(i).Column("shout_msg"))
- Next
Was mache ich hier falsch?
Er führt den Befehl problemlos aus, aber er zeigt nur einen Wert an obwohl es vier sein müssten.