Here I have an mysql tables with ID, ID_polja, lat, lng:

As you can see I want to get first data from unique number so first (lat,lng) with ID_polja =1
first (lat,lng) with ID_polja = 2 ...
But how to run a query for that?
SELECT * FROM koordinate WHERE ID_polja=[1,2,3... n]
Maybe GROUP and ORDER:
SELECT * FROM `koordinate` GROUP BY `ID_polja` ORDER BY `ID` ASC
SELECT * FROM `koordinate` GROUP BY `ID_polja`
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With