How do I do this?

[todayme]

I need to search a columb of a table call the colmb Status, each row can have different values like

 

Received.

Peding

Closed.

Sold.

 

And I need to get the value of the highest value, given that each value has a coresponding weight to it.

 

eg.

 

Sold and Closed would be equal and the highest.

 

Received would be the lowest

Pending would be second lowest.

 

And what I need to do is find the highest value after searching all the rows.  So If you did a search and searched all the rows and found the highest value was Pending a variable would be passed saying Pending or if it was Closed then it would be parsed as closed.

 

Any help would be appreciated.

[magic2goodil]

Assuming you are referencing a single row via it's id:

 

$query = "select max(*) from table where id = '$id'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result) or die(mysql_error());

foreach($row as $key => $val) {

     echo "The highest value is: ".$key." with a value of ".$val;

}

 

[todayme]

Thanks heaps not good with php syntax.

[todayme]

Hey how does that code know the weight or values of each of the words.

 

????

 

How does it know that Close or Sold is a numeric value ? of 5 and Received is a value of 1