Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Php query to get data from mysql

Here I have an mysql tables with ID, ID_polja, lat, lng: enter image description here

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]
like image 840
gmaestro Avatar asked Sep 17 '26 06:09

gmaestro


2 Answers

Maybe GROUP and ORDER:

SELECT * FROM `koordinate` GROUP BY `ID_polja` ORDER BY `ID` ASC
like image 190
Mihai Iorga Avatar answered Sep 19 '26 19:09

Mihai Iorga


SELECT * FROM `koordinate` GROUP BY `ID_polja`
like image 36
Pratik Avatar answered Sep 19 '26 20:09

Pratik