Barevně označený limit

Michales

(5 hodnocení)

6. 5. 2013 09:26:11

Dobrý den,

potřeboval bych poradit jak napsat tento script.

V databázy jsem si přidal sloupec limit.

Do něho zapíši třeba číslo 10

A teď oč jde.

Pokud nebude splněný limit 10 zápasů, tak by byl tým označený červěně, pokud by ho splnil tak by se označil zeleně.

Jak toto napsat?

Děkuji za každou radu.

6. 5. 2013 09:26:11

https://webtrh.cz/diskuse/barevne-oznaceny-limit/#reply898368

P-ierre

(43 hodnocení)

6. 5. 2013 09:45:16

https://webtrh.cz/diskuse/barevne-oznaceny-limit/#reply898367

Tomáš Faldyna

(54 hodnocení)

6. 5. 2013 09:47:42

Polopaticky treba takto...

if( $limit < 10 ) $barva = "red"; else $barva = "green";

echo "$limit";

6. 5. 2013 09:47:42

https://webtrh.cz/diskuse/barevne-oznaceny-limit/#reply898366

ghostik

(21 hodnocení)

6. 5. 2013 09:50:35

...

6. 5. 2013 09:50:35

https://webtrh.cz/diskuse/barevne-oznaceny-limit/#reply898365

Michales

(5 hodnocení)

6. 5. 2013 09:58:43

if( $limit < 10 ) $barva = "red"; else $barva = "green";

echo "$limit";

Toto by mohlo fungovat, ale zde je přesně dán limit 10

Já bych potřeboval aby to bralo ten limit z toho sloupce.

Dám sem kod kterým zobrazuji tabulku:

if ($result_exist) {

$query="SELECT teamid, teamname, nickname,limit teamwins, teamties, teamlosses, teamforfeits, teamrf, teamra,

(teamwins + teamties + teamlosses + teamforfeits) AS gamesplayed,

(

(SELECT COUNT(1) FROM sportsdb_wins WHERE (winortie=1 AND winner=teamid) OR (winortie=4 AND loser=teamid) ) * $points_win +

(SELECT COUNT(1) FROM sportsdb_wins WHERE (winortie=5 AND loser=teamid) OR (winortie=2 AND winner=teamid) ) * $points_winned_forfeit +

(SELECT COUNT(1) FROM sportsdb_wins WHERE (winortie=5 AND winner=teamid) OR (winortie=2 AND loser=teamid) ) * $points_forfeit +

(SELECT COUNT(1) FROM sportsdb_wins WHERE winortie=0 AND winner=teamid OR loser=teamid) * $points_tie

) AS points,

$winning_pct_formula AS winningpct,

((({$results}) - (teamwins - teamlosses - teamforfeits)) / 2) AS gamesbehind

FROM sportsdb_teams

WHERE teamdiv = {$divs}";

if ($standings_sort == 9) {

$query .= " AND teamid != {$results}";

}

$query .= " AND active = 1" . $division_sort . " ORDER BY $sort_order";

//echo "

$query

$result=mysql_query($query);

$num=mysql_num_rows($result);

$postupujici=(int)@$_GET;

$baraz=(int)@$_GET;

$row_number =0;

while ($results = mysql_fetch_array($result, MYSQL_ASSOC)) {

$winningpct=number_format($results, 3)*100;

$gamesbehind = number_format($results,1);

if ($gamesbehind == "0.0") {

$gamesbehind = "---";

}

$sql="SELECT w.winner AS winnerID,w.loser AS loserID,datum,winortie,rf,ra,tw.teamname AS winner,tl.teamname AS loser FROM sportsdb_wins w LEFT JOIN sportsdb_teams tw ON w.winner=tw.teamid LEFT JOIN sportsdb_teams tl ON w.loser=tl.teamid WHERE w.winner={$results} OR w.loser={$results} ORDER BY w.winid DESC LIMIT 5";

$resWins=mysql_query($sql);

' . "n"; ?>

if ($forfeit) { ?>

if ($show_rfra) { ?>

while($rw=mysql_fetch_assoc($resWins)){

switch($rw){

case 0:

$bg='white';

$winner=$loser=$rw.'+'.$rw;

$popis='remíza';

break;

case 1: