I am looking for a way to find the highest 5 and lowest 5 numbers within 300
or so numbers. Here is what I have so far...

$Tickers = array();
$Current = array();

   mssql_select_db($DBName) or DIE("Table unavailable");

    $Results = MSSQL_QUERY("SELECT CompanyName,Ticker FROM Company WHERE
Ticker != ''");

    $RowCount = MSSQL_NUM_ROWS($Results);
    print "$RowCount Number of Tickers<br>\n";

    if($RowCount != 0) {
      for ($i = 0; $Field = MSSQL_FETCH_ARRAY($Results); ++$i) {
array_push($Tickers, $Field["Ticker"]); }
   else { print "There was nothing selected in the Query, it may have been
bad."; }

foreach($Tickers as $Ticker) { Get Last price on the ticker from database.
and... array_push($Current, $Value); }

Now that I have the values in an array I would like to pull out the five
highest and the 5 lowest. Is there a way to do that....if not, is there
another way to do what I am looking for. I keep thinking I would have to
compare each ticker against all the others to verify it's standing...and
that seems like a lot of work.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to