How to get only the first path from Mysql?

[Markus]

Right. Show me all of the output from this command: print_r($visa);

[Fynd]

Ok here's the lot, hope it will make any sense to you :-)

Array ( [0] => 271 [annonsid] => 271 [1] => 2010-03-31 [datum] => 2010-03-31 [2] => 20100331100815 [datumtid] => 20100331100815 [3] => Malmö kommun [lan] => Malmö kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test igen [rubrik] => Test igen [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 271 [11] => IMG_0232.jpg [bildnamn] => IMG_0232.jpg [12] => annonsbilder/201003311008151 62.119.142.29.j pg [bildpath] => annonsbilder/201003311008151 62.119.142.29.j pg ) Array ( [0] => 271 [annonsid] => 271 [1] => 2010-03-31 [datum] => 2010-03-31 [2] => 20100331100815 [datumtid] => 20100331100815 [3] => Malmö kommun [lan] => Malmö kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test igen [rubrik] => Test igen [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 271 [11] => IMG_0237.jpg [bildnamn] => IMG_0237.jpg [12] => annonsbilder/201003311008152 62.119.142.29.j pg [bildpath] => annonsbilder/201003311008152 62.119.142.29.j pg ) Array ( [0] => 271 [annonsid] => 271 [1] => 2010-03-31 [datum] => 2010-03-31 [2] => 20100331100815 [datumtid] => 20100331100815 [3] => Malmö kommun [lan] => Malmö kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test igen [rubrik] => Test igen [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 271 [11] => IMG_0231.jpg [bildnamn] => IMG_0231.jpg [12] => annonsbilder/201003311008153 62.119.142.29.j pg [bildpath] => annonsbilder/201003311008153 62.119.142.29.j pg ) Array ( [0] => 270 [annonsid] => 270 [1] => 2010-03-30 [datum] => 2010-03-30 [2] => 20100330060044 [datumtid] => 20100330060044 [3] => Göteborgs kommun [lan] => Göteborgs kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test 3 bilder [rubrik] => Test 3 bilder [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 270 [11] => IMG_0073.jpg [bildnamn] => IMG_0073.jpg [12] => annonsbilder/201003300702531 217.210.81.146. jpg [bildpath] => annonsbilder/201003300702531 217.210.81.146. jpg ) Array ( [0] => 270 [annonsid] => 270 [1] => 2010-03-30 [datum] => 2010-03-30 [2] => 20100330060044 [datumtid] => 20100330060044 [3] => Göteborgs kommun [lan] => Göteborgs kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test 3 bilder [rubrik] => Test 3 bilder [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 270 [11] => IMG_0071.jpg [bildnamn] => IMG_0071.jpg [12] => annonsbilder/201003300658152 217.210.81.146. jpg [bildpath] => annonsbilder/201003300658152 217.210.81.146. jpg ) Array ( [0] => 270 [annonsid] => 270 [1] => 2010-03-30 [datum] => 2010-03-30 [2] => 20100330060044 [datumtid] => 20100330060044 [3] => Göteborgs kommun [lan] => Göteborgs kommun [4] => Affärsöverlåtel ser [typ] => Affärsöverlåtel ser [5] => Test 3 bilder [rubrik] => Test 3 bilder [6] => [stad] => [7] => 1 [pris] => 1 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => 270 [11] => IMG_0229.jpg [bildnamn] => IMG_0229.jpg [12] => annonsbilder/201003300829383 217.210.81.146. jpg [bildpath] => annonsbilder/201003300829383 217.210.81.146. jpg ) Array ( [0] => 259 [annonsid] => [1] => 2010-03-25 [datum] => 2010-03-25 [2] => 20100325173348 [datumtid] => 20100325173348 [3] => Örebro [lan] => Örebro [4] => Hobby [typ] => Hobby [5] => 17 olika darkkort [rubrik] => 17 olika darkkort [6] => [stad] => [7] => 99 [pris] => 99 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 258 [annonsid] => [1] => 2010-03-25 [datum] => 2010-03-25 [2] => 20100325172040 [datumtid] => 20100325172040 [3] => Örebro [lan] => Örebro [4] => Hobby [typ] => Hobby [5] => Shining Mewtwo Pokemonkort [rubrik] => Shining Mewtwo Pokemonkort [6] => [stad] => [7] => 299 [pris] => 299 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 257 [annonsid] => [1] => 2010-03-25 [datum] => 2010-03-25 [2] => 20100325171046 [datumtid] => 20100325171046 [3] => Örebro [lan] => Örebro [4] => Hobby [typ] => Hobby [5] => Lugia ex Pokemonkort [rubrik] => Lugia ex Pokemonkort [6] => [stad] => [7] => 99 [pris] => 99 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 255 [annonsid] => [1] => 2010-03-25 [datum] => 2010-03-25 [2] => 20100325140201 [datumtid] => 20100325140201 [3] => Västerbotten [lan] => Västerbotten [4] => Butikstillbehör [typ] => Butikstillbehör [5] => Gratulationskor t [rubrik] => Gratulationskor t [6] => [stad] => [7] => 600 [pris] => 600 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 250 [annonsid] => [1] => 2010-03-24 [datum] => 2010-03-24 [2] => 20100324074656 [datumtid] => 20100324074656 [3] => Örebro [lan] => Örebro [4] => Maskiner [typ] => Maskiner [5] => Minitraktor med plogblad [rubrik] => Minitraktor med plogblad [6] => [stad] => [7] => 10000 [pris] => 10000 [8] => [marke] => [9] => Köpes [kategori] => Köpes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 249 [annonsid] => [1] => 2010-03-23 [datum] => 2010-03-23 [2] => 20100323171018 [datumtid] => 20100323171018 [3] => Örebro [lan] => Örebro [4] => Prydnadssaker [typ] => Prydnadssaker [5] => Handmålad keramikvas [rubrik] => Handmålad keramikvas [6] => [stad] => [7] => 49 [pris] => 49 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 248 [annonsid] => [1] => 2010-03-23 [datum] => 2010-03-23 [2] => 20100323142446 [datumtid] => 20100323142446 [3] => Skåne [lan] => Skåne [4] => Maskiner [typ] => Maskiner [5] => Begagnad Oerlikon TIG [rubrik] => Begagnad Oerlikon TIG [6] => [stad] => [7] => 18700 [pris] => 18700 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 237 [annonsid] => [1] => 2010-03-20 [datum] => 2010-03-20 [2] => 20100320205341 [datumtid] => 20100320205341 [3] => Örebro [lan] => Örebro [4] => Motorsågar [typ] => Motorsågar [5] => Motorsåg Stihl köpes [rubrik] => Motorsåg Stihl köpes [6] => [stad] => [7] => 1200 [pris] => 1200 [8] => [marke] => [9] => Köpes [kategori] => Köpes [10] => [11] => [bildnamn] => [12] => [bildpath] => ) Array ( [0] => 236 [annonsid] => [1] => 2010-03-20 [datum] => 2010-03-20 [2] => 20100320110749 [datumtid] => 20100320110749 [3] => Örebro [lan] => Örebro [4] => Antikt [typ] => Antikt [5] => Antikt pottskåp [rubrik] => Antikt pottskåp [6] => [stad] => [7] => 500 [pris] => 500 [8] => [marke] => [9] => Säljes [kategori] => Säljes [10] => [11] => [bildnamn] => [12] => [bildpath] => )

[Fynd]

Hope it could shine a light on this but I could fetch the id from annonser_bilder for the different images but as they are connected to the same id from annonser I can not seperate them either. Tried the used_ids from above but can not make it to go further in the while loop from the query.
Thanks for helping out.

Best regards and happy easter.Morgan

[Fynd]

Sorry for double posting but if I use this:

WHERE
                  a.kontrollerad = 'ja'  
                GROUP BY
                  a.annonsid
                ORDER BY
                  a.datumtid DESC

The loop works with showing one image per id but if I do it like this:

WHERE
					
                  a.kontrollerad = 'ja' 
				$sokord
				   
				LIMIT
				$offset, $antal_bilder

It will show 3 images per id. I can not attach GROUP BY and ORDER BY as the syntax will not handle the $sokord, which is a part of the search, so can anybody see if there's a way to attach $sokord in the first example?