Least

[Asheeown]

I've been digging through manuals, the internet, and I still can't find something in PHP or mysql to find the least of numbers that are being called from a database


Does anyone know a function to do this?

[Asheeown]

So what i'm basically being told by the dead silence is their is no way?

[trq]

Your question is pretty vague, do you mean...

[code]
SELECT MIN(fld) FROM tbl;
[/code]

?

[Asheeown]

exactly what I mean't thank you

[Asheeown]

Wait thats my bad it's not exactly what i'm looking for.

I have a table and each entry into that table has 12 different columns of numbers, which represent prices of a company, I want to find the minimum number of each entry for those 12 columns.

[trq]

That wreaks of poor database design but ah well.

You need to run a query which retrieves all these values into an array, then sort it. eg;

[code]
<?php
  // connect
  $sql = "SELECT p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12 FROM tbl WHERE companyid = 4;";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result) > 0)) {
      $row = mysql_fetch_array($result);
      sort($row);
      echo $row[0];
    }
  }
?>
[/code]

[Asheeown]

I just used the least function for mysql, but another question the least number that it found...is their a way to get that column name

[code=php:0]
$InterQuery = mysql_query("SELECT least(inter1,inter2,inter3,inter4,inter5,inter6,inter7,inter8,inter9,inter10,inter11,inter12) FROM compare_npanxxcost") or die(mysql_error());
[/code]

Showing what column it got the least number out of

For example if "inter3" had the lowest number there, how could you tell that it was in fact "inter3"?

[Draicone]

Well, no, because the problem is that it is selecting the least of all those columns. You need a query for each. I suppose you can use a for loop in php to automate the process.

[Asheeown]

Somewhere, someplace it has to show where that number came from.

[Jessica]

Use mysql_fetch_assoc instead of mysql_fetch_array

[trq]

Why do you need it?

[url=http://php.net/array_keys]array_keys[/url] could get it if used with [url=http://php.net/mysql_fetch_assoc]mysql_fetch_assoc[/url]().

[Asheeown]

Its a company price, they aren't the same for each entry thought so in order to track them just take the column name "inter3" and use another mysql table to tell what it is and inter3 matches with a company name

[Asheeown]

I don't really see how I could use array_keys could you elaborate a little please?