Hi Guys,
I have a While loop that creates a list from my database. The results are presented in ASC order based on their ID (1,2,3,4 etc)
I would like to be able to set a few of the results so that they are always at a specified position. e.g 1, 13, 21 and 40.
I cannot think of a way to do this and would appreciate any help on the matter.
Here is my php.
$sql = "SELECT id, client_name, image FROM clients ORDER BY ID ASC LIMIT 50";
$result = $conn->query($sql) or die(mysqli_error());
if($result){
while($row = $result->fetch_object()){
$square_name = $row->image;
$client = $row->client_name;
$min = 1;
$max = 2;
$number = rand($min, $max);
$image_url = "$image_path/$square_name" . 1 . ".jpg";
echo "<li>
<a href='$url' class='tooltip' title='$client'>
<img src='$image_url' height='87' width='87' border='0' alt=''/>
</a>
</li>";
}
}
Thanks in advanced guys.