SELECT question

[txtimmer87]

I am writing a code in which i need to find a value in my MySQL database. If the value is not there, however, I want the first value that is listed listed below my search value.

Any help would be a lifesaver!

[txtimmer87]

I've tried the following method, but it returns the first value of my entire database.
Here's what I've written:

$get = "SELECT myfield FROM mytable WHERE myfield <= myvalue LIMIT 1";
$search = mysql_query($get) or die(mysql_error());
$file = mysql_result($search, 0);
echo "
$file";

[Xnuiem]

A better way would be to use sort to sort against the results. This would only work if you are looking for a single value though.

[txtimmer87]

Hey that worked!
Here's the new script:

$get = "SELECT myfield FROM mytable WHERE myfield <= myvalue ORDER BY myfield DESC LIMIT 1";
$search = mysql_query($get) or die(mysql_error());
$file = mysql_result($search, 0);
echo "
$file";