Find the Highest Number in Table?

[Warptweet]

I use the old code below to fetch information from the database...

 

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM person
WHERE FirstName='Peter'");

while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />";
  }

 

Well, how can I return a row (with LIMIT 1) with upload_votes AT LEAST 3, and with the HIGHEST upload_rating of all the rows in the database table?

 

Thanks for any help.

[MadTechie]

$result = mysql_query("SELECT * FROM person WHERE FirstName='Peter' AND upload_votes >= 3 ORDER BY  upload_votes ASC LIMIT 1");

[Barand]

Haven't a clue since I have no idea what the database/table structure is. All we know your post is that you have a table named "person" with columns firstname and lastname. Those with telepathic abilities (like MadTechie) may be able to help

[MadTechie]

Well i just done a CICO, C*** In C*** OUT

 

if it works i am the dog's ... if not then  oh well

 

PS it's called OT

 

Overseas Telepathic

 

basically the same but costs a little more and also a bit fuzzy at times