Databases
StackOverflow2013
Postsdbo
POPHP not displaying text colour
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP not displaying text colour
    primarykey
    data
    text
    <p>I have a page which I would like to see display the team played for in green. I have the following SQL:</p> <pre><code>SELECT performance.id, matchid, playerid, team, debut, batpos, runs, ballsfaced, runs/ballsfaced*100 AS strikerate, fours, sixes, no, howout, fielder, bowler, ballsbowled, maidens, wickets, runsconceded, catches, stumpings, runouts, runsconceded/ballsbowled/6 AS economy, matches.round, matches.season, teams.id AS fteamid, a.id AS ateamid, teams.name AS hometeamname, a.name AS awayteamname, players.fname, players.surname FROM performance INNER JOIN matches ON performance.matchid=matches.id INNER JOIN teams ON matches.hometeam = teams.id INNER JOIN (SELECT teams.id, name FROM teams) AS a ON matches.awayteam = a.id INNER JOIN players ON performance.playerid=players.id </code></pre> <p>And the following php statement:</p> <pre><code>&lt;?php //if they play for this team display in green if ($team['team'] == $team['fteamid']){ ?&gt; &lt;font color="green"&gt;&lt;?php htmlout($team['hometeamname']); ?&gt;&lt;/font&gt; &lt;?php } else { ?&gt; &lt;?php htmlout($team['hometeamname']); ?&gt; &lt;?php } ?&gt; v &lt;?php //if they play for this team display in green if ($team['team'] == $team['ateamid']){ ?&gt; &lt;font color="green"&gt;&lt;?php htmlout($team['awayteamname']); ?&gt;&lt;/font&gt; &lt;?php } else { ?&gt; &lt;?php htmlout($team['awayteamname']); ?&gt; &lt;?php } ?&gt; </code></pre> <p>It works fine for the home team, but it doesn't work for the away team and I can't figure out why, it appears to be correct to me. Can someone please point out my error?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. UScameronjonesweb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP not displaying text colour
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POPHP not displaying text colour
      1. This table or related slice is empty.
      1. VTDownMod
    1. COPlease use css instat of font tags.
      singulars
      1. POPHP not displaying text colour
      1. USrekire
    2. COis your resulting rowset contain row with $team['team'] == $team['ateamid']?
      singulars
      1. POPHP not displaying text colour
      1. USIvan Solntsev
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload