Different colors with mysql-fetch_array2

[Anon]

Apparently something went wrong with copy and paste...So I'll try again.
I am totally new with php and mySQL , so please forgive me if this is a stupid question..I hope the following makes sence: I use the function

do{
printf("<--!here's my tablerow layout in html--!>%s<end of row>%s <--!more tablerows in html--!>\n,$myrow["a"], $myrow["b"]);
while
($myrow = mysql_fetch_array($result));

to generate a resultpage with all the rows from my table presented in a nice table layout; text is all in the same color(blue). How could I make the textcolor from a tablerow change to another coler in case a certain field (let's say a field in $myrow["a"]) has a certain value?

Thanks in advance.

[Anon]

Something like:
<font color="<?php if ($myrow['a']=='special') echo 'red' else echo 'blue'?>">...</font>

better:

<span style="color=<?php if ($myrow['a']=='special') echo 'red' else echo 'blue'?>;">...</span>

[Anon]

Thanks for the quick reply; my first post ever and it works!! php Rules!

I can see how this works, but I can't fit it into the original code (newbie as i am).
Here's a bit more complete how it looks now:

if ($myrow = mysql_fetch_array($result)) {
echo "<table border=0 width=450 align=CENTER>\n";

//the first row of the table
echo "<b><tr><td><font face=Verdana size=2 color=#000066>dw</td>
<td><font face=Verdana size=2 color=#000066>vw</td>
<td><font face=Verdana size=2 color=#000066>aw</td>
<td><font face=Verdana size=2 color=#000066>Artist</td>
<td><font face=Verdana size=2 color=#000066>Title</td>
<td><font face=Verdana size=2 color=#000066>Lable</tr></b>\n";

//and the rows from the database-table

do {

printf("<tr><td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</tr>\n", $myrow["dw"], $myrow["vw"], $myrow["aw"], $myrow["artist"], $myrow["title"], $myrow["lable"]);

} while ($myrow = mysql_fetch_array($result));

echo "</table>\n";

The row which I want to change color is $myrow["dw"]

Hope you can be a bit more specific this way?

Thanks again!!

[Anon]

Hm. Little performance tip - don't use printf() if all you're using is %s. (That's just a rule of thumb; there are exceptions, but this isn't one of them.)

To write it the way you have (hm... which one is dw? This is one of the problems...):

printf("<tr><td%s>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</tr>\n", $myrow["dw"]=="special" ? " style=\"color:red;\"" : "", $myrow["dw"], $myrow["vw"], $myrow["aw"], $myrow["artist"], $myrow["title"], $myrow["lable"]);

Now, when $myrow["dw"]=="special", the appropriate cell will get an extra style attribute making the text inside it red. Otherwise the text will just be the usual. To switch between two colours, say red/blue, a more sensible version would be:

printf("<tr><td style="color:%s;">%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</tr>\n", $myrow["dw"]=="special" ? "red" : "blue", $myrow["dw"], $myrow["vw"], $myrow["aw"], $myrow["artist"], $myrow["title"], $myrow["lable"]);

And if things start to get hairy, break some of the code out and go:

$dwcolour = $myrow["dw"]=="special" ? "red" : "blue";
printf("<tr><td style="color:%s;">%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</tr>\n", $dwcolour, $myrow["dw"], $myrow["vw"], $myrow["aw"], $myrow["artist"], $myrow["title"], $myrow["lable"]);

[Anon]

A little late...but it works!

thanks again.