9999 and wkchange <> 9999 and eoddata.pchange <> 9999 ".$cap." ORDER BY CAST(ytdchange * 100 AS SIGNED)/100 desc limit 11";
$stktickers3 = "";
$result = mysql_query($query) or die(mysql_error());
$daten = "";
$n = 0;
while($row = mysql_fetch_array($result)){
$stktickers3[$n]="".firsttwowords(strtoupper($row['equityname'])).": ".$row['ytdchange'];
$n++;
}
$query = "SELECT equities.EQUITYTICKER, equityname,close, eoddata.dchange, eoddata.pchange, equityname, currrating, suffix, weeksuffix, sector, midsector, subsector, ytdchange , wkchange, marketcap, score FROM equities,performance, eoddata ,technicals WHERE performance.ticker=equities.equityticker and performance.ticker=technicals.equityticker and equities.equityticker=eoddata.ticker and equities.sector='Technology' and ytdchange <> 9999 and wkchange <> 9999 and eoddata.pchange <> 9999 ".$cap." ORDER BY CAST(ytdchange * 100 AS SIGNED)/100 limit 12";
$stktickers = "
";
$result = mysql_query($query) or die(mysql_error());
$daten = "";
$n = 1;
while($row = mysql_fetch_array($result)){
if ($row['ytdchange'] < 9000) {
$stktickers = $stktickers."| ".firsttwowords($row['equityname'])."[".round($row['ytdchange'],0)."%] | ";
if ($n%3==0 && $n!=0) $stktickers=$stktickers."
";
$n++;
}
}
$stktickers = $stktickers."
";
$query = "SELECT equities.EQUITYTICKER, equityname,close, eoddata.dchange, eoddata.pchange, equityname, currrating, suffix, weeksuffix, sector, midsector, subsector, ytdchange , wkchange, marketcap, score FROM equities,performance, eoddata ,technicals WHERE performance.ticker=equities.equityticker and performance.ticker=technicals.equityticker and equities.equityticker=eoddata.ticker and equities.sector='Technology' and ytdchange <> 9999 and wkchange <> 9999 and eoddata.pchange <> 9999 ".$cap." ORDER BY CAST(wkchange * 100 AS SIGNED)/100 desc limit 12";
$stktickers5 = "";
$result = mysql_query($query) or die(mysql_error());
$daten = "";
$n = 1;
while($row = mysql_fetch_array($result)){
if ($row['ytdchange'] < 9000) {
$stktickers5 = $stktickers5."| ".firsttwowords($row['equityname'])."[".round($row['wkchange'],1)."%] | ";
if ($n%3==0 && $n!=0) $stktickers5=$stktickers5."
";
$n++;
}
}
$stktickers5 = $stktickers5."
";
$query = "SELECT equities.EQUITYTICKER, equityname,close, eoddata.dchange, eoddata.pchange, equityname, currrating, suffix, weeksuffix, sector, midsector, subsector, ytdchange , wkchange, marketcap, score FROM equities,performance, eoddata ,technicals WHERE performance.ticker=equities.equityticker and performance.ticker=technicals.equityticker and equities.equityticker=eoddata.ticker and equities.sector='Technology' and ytdchange <> 9999 and wkchange <> 9999 and eoddata.pchange <> 9999 ".$cap." ORDER BY CAST(ytdchange * 100 AS SIGNED)/100 desc limit 12";
$stktickers2 = "";
$result = mysql_query($query) or die(mysql_error());
$daten = "";
$n = 1;
while($row = mysql_fetch_array($result)){
if ($row['ytdchange'] < 9000) {
$stktickers2 = $stktickers2."| ".firsttwowords($row['equityname'])."[".round($row['ytdchange'],0)."%] | ";
if ($n%3==0 && $n!=0) $stktickers2=$stktickers2."
";
$n++;
}
}
$stktickers2 = $stktickers2."
";
$query = "SELECT equities.EQUITYTICKER, equityname,close, eoddata.dchange, eoddata.pchange, equityname, currrating, suffix, weeksuffix, sector, midsector, subsector, ytdchange , wkchange, marketcap, score FROM equities,performance, eoddata ,technicals WHERE performance.ticker=equities.equityticker and performance.ticker=technicals.equityticker and equities.equityticker=eoddata.ticker and equities.sector='Technology' and ytdchange <> 9999 and wkchange <> 9999 and eoddata.pchange <> 9999 ".$cap." ORDER BY score desc, CAST(eoddata.pchange * 100 AS SIGNED)/100 desc limit 12";
$stktickers6z2 = "";
$result = mysql_query($query) or die(mysql_error());
$daten = "";
$n = 1;
while($row = mysql_fetch_array($result)){
if ($row['ytdchange'] < 9000) {
$stktickers6z2 = $stktickers6z2."| ".firsttwowords($row['equityname'])."[".round($row['score'],0)."] | ";
if ($n%3==0 && $n!=0) $stktickers6z2=$stktickers6z2."
";
$n++;
}
}
$stktickers6z2 = $stktickers6z2."
";
?>