[TheCase]

Hi,

This is my query

$sql = "SELECT teamname,id FROM `aacl_team`";
$result = mysql_query($sql) or die (mysql_error());

I want to do something like this though

SELECT teamname,id FROM `aacl_team` WHERE $laddered is less than or more than $points LIMIT 1

So if $points = 5

I need it fetch out the DB the lowest one after 5 so if team 1 has 4 points and team 2 has 1 points then it will fetch team 1 and the same the other way around for nearest highest but limit it to 1 so I only get 2 teams. Then if something goes wrong like all the lowest teams are 5 can we echo out No Teams.

I tried using the > < signs but I guess they dont work in a query. Sorry for the bad explaination.

Any ideas?
Thanks

[TheCase]

PHP Code:

$sql = "SELECT teamname,id FROM `aacl_team` WHERE $currentpointsp > $currentpoints LIMIT 1 AND $currentpointsp < $currentpoints LIMIT 1";
$result = mysql_query($sql) or die (mysql_error()); 

Thats the code I tried. Just a random guess, might give you a better understanding of what I whould like to achieve

[Keith]

Gah, misread your message...

[job0107]

You might be able to do it with two queries like this:

PHP Code:

<?php
$row1 = "";
$row2 = "";
$teams = "";
$sql = "SELECT teamname,id FROM `aacl_team` WHERE $currentpointsp < $currentpoints ORDER BY $currentpointsp DESC LIMIT 1";
$result = mysql_query($sql) or die (mysql_error());
if($result)
{
 $row1 = mysql_fetch_assoc($result);
 mysql_free_result($result);
 }
$sql = "SELECT teamname,id FROM `aacl_team` WHERE $currentpointsp > $currentpoints ORDER BY $currentpointsp ASC LIMIT 1 ";
$result = mysql_query($sql) or die (mysql_error());
if($result)
{
 $row2 = mysql_fetch_assoc($result);
 mysql_free_result($result);
 }
if($row1)
{
 $teams .= "Id = ".$row1["id"]." Team = ".$row1["teamname"]."<br />";
 if($row2){$teams .= "Id = ".$row2["id"]." Team = ".$row2["teamname"]."<br />";}
 }
else{$teams = "No Teams<br />";
echo $teams;
?>

This should work, but you may have to play around with the ASC and DESC in the queries.

What happens if you have two or more teams that have the same number of points, lower but closest to the set point?

[TheCase]

Originally Posted by job0107

What happens if you have two or more teams that have the same number of points, lower but closest to the set point?

Erm will it pick any row at random? That will be allright

[TheCase]

Script Fixed.