Order mysql results following a function

@iamjonesJul 05.2013 — #On each iteration you should add $longueur to an array and then order the array.

Something like this:

[code=php]
 //Outside the loop
 $items = array(); //Or $items = []; if you are using PHP 5.4 or above
 
 //Inside the loop do this
 $items[] = round(get_distance_m($Lat, $Long, $user_Lat, $user_Long) / 1000, 3);
 [/code]

Then after you can use sort() to sort the array.

Hope that helps.

@hares7293authorJul 05.2013 — #Thanks for help.

I tried your approach but i can't work with the $items array as if i echo it i only get Array Array ... with no values.

I am a beginner with php, perhaps i missed something

I put my complete code so far :

[code=php]<?php
 if(isset($_GET['cord'])){
 $cord= $_GET['cord'];
 list($user_Lat,$user_Long) = explode("-", $cord);
 
 $query="SELECT * FROM table WHERE Statut>='0'";
 $db->setQuery($query);
 $rs=$db->query();
 
 echo'<table>';
 
 function get_distance_m($Lat, $Long, $user_Lat, $user_Long) {...}
 $longueur = array();
 
 while($row=mysqli_fetch_array($rs)){
 $Lat=$row['Lat'];
 $Long=$row['Long'];
 $longueur[]=round(get_distance_m($Lat, $Long, $user_Lat, $user_Long) / 1000, 3);
 
 //echo "$longueur";
 //folowing is previous code where i putted $longueur alone without sorting
 
 if ($longueur<="3") {
 ?>
 <tr class="tr">
 <td style="height:100"><a href="http://mobile.monsite.net/index.php/donnees.html?value=<?php echo"$row[Identifiant]"?>"><img src="http://mobile.monsite/images/uploaders/<?php echo"$row[Identifiant]/Images/Logo/logo.jpg"?>" alt="Logo" width="100" height="100"/></a></td>
 <td>
 <p>
 <?php if ($longueur<=0.1){echo'<span class="distance">A moins de 100 m</span><br/>';} 
 elseif ($longueur>0.1 AND $longueur<=0.2){echo'<span class="distance">A moins de 200 m</span><br/>';}
 elseif ($longueur>0.2 AND $longueur<=0.3){echo'<span class="distance">A moins de 300 m</span><br/>';}
 elseif ($longueur>0.3 AND $longueur<=0.4){echo'<span class="distance">A moins de 400 m</span><br/>';}
 elseif ($longueur>0.4 AND $longueur<=0.5){echo'<span class="distance">A moins de 500 m</span><br/>';}
 elseif ($longueur>0.5 AND $longueur<=1){echo'<span class="distance">A moins d'1 km</span><br/>';}
 elseif ($longueur>1 AND $longueur<=2){echo'<span class="distance">Entre 1 et 2 Km</span><br/>';}
 else   {echo'<span class="distance">A plus de 2 km</span><br/>';} ?>
 <span class="magenta"><?php echo"$row[Identite]"?></span><br/>
 <?php echo"$row[categorie]"?>
 </p>
 </td>
 </tr>
 <?php
 }}
 echo'</table>';
 ?>[/code]

Order mysql results following a function

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Order mysql results following a function

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴