Jump to content

How do I do this?


todayme

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/42318-how-do-i-do-this/
Share on other sites

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;

}

 

Link to comment
https://forums.phpfreaks.com/topic/42318-how-do-i-do-this/#findComment-205291
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.