How to get the total rows in Mysql table using visual basic 6?
Posted on 2014-02-07
I need to pull the total rows in a MySQL Query and put it in a variable, the code works fine but I don't know how to pull the total of each city
cSQLBusca = "SELECT Residence_city, Count(*) FROM transacciones WHERE Fecha_registra BETWEEN '" & cFechaIni & "' and '" & cFechaFin & "' GROUP BY Residence_city
I need to ouput the result like this:
Los Angeles 11
And so on.
Thank you guys.