mysql query, val1>=$getval AND val2<=$getval

[helz]

Hello all,
I need to get a single update from the database, and in need of some help constructing the query.
this is the original idea of the query, but i then thought, why not speed things up and see if i can get it done within the query itself:

$query = mysql_query("SELECT * FROM table")
while ($data = mysql_fetch_array($query)) {
   extract($data);
   if ($minver <= $_GET['currentversion'] && $maxver >= $_GET['currentversion']) {
      echo $update;
   }
}

So i thought, would something similar to this work?

SELECT sourcefile,max(version) FROM table WHERE minver>='$_GET['curver']' AND maxver<='$_GET['curver']'

an extra thing would be, if multiple rows are found with the above query how can i make it so that only the row with the highest version column is in the result?

thanks for any replies

[harman]

$sql = "SELECT sourcefile, version "
          ."FROM table "
          ."WHERE minver BETWEEN '$_GET['curver']' AND '$_GET['curver']' "
         ."ORDER BY version"; 

$row = mysql_fetch_array(mysql_query($sql));

echo $row['sourcefile'].' '.$row['version'];

[helz]

there are two columns in the table:
minver and maxver
$_GET['curver'] has to be inbetween these values

with the GROUP BY version, will this return the highest version row or lowest? or is it just the last row that affected by the query?

[helz]

well here is a query that does the job:

	$sql = "SELECT sourcefile,version,minver,maxver"
		  ." FROM ".$tablename
		  ." WHERE minver<='".$curver."' AND maxver>='".$curver."'"
		  ." GROUP BY version ORDER BY version DESC LIMIT 1";

it pulls all records that are within the limits, but to get the max value of version, just set it to order by version desc, and then limit the number of results to 1