Testing

Pezmc

In my database I have lots of song names as below

 id   	 title   	 artist   	 album   	 submitter   	 submitterip   	 online   	 votes   	 code   	 sumbiteremail
1 	Don't Stop Me Now 	Queen 	The Complete Queen Collection 	Pez Cuckow 	192.168.0.3 	yes 	3 	  	 
2 	Eternal Clerking 	Amatatuer Transplants 	Fitness To Practice 	Pez Cuckow 	192.168.0.3 	yes 	1 	  	 
3 	Moments In Love (Quiet Storm) 	Art Of Noise 	Art of Noise 	Pez Cuckow 	192.168.0.3 	yes 	1 	  	 
4 	Moments In Love (Quiet Storm) 	Art Of Noise 	Art of Noise 	Pez Cuckow 	192.168.0.3 	yes 	1 	  	 
5 	You gotta Tap 	Audiobody 	Sound. Motion. Theater. 	Pez Cuckow 	192.168.0.3 	yes 	1 	  	 
6 	Sweet Harmony 	The Beloved 	Open Space 	Pez Cuckow 	192.168.0.3 	yes 	5

Sorry about misaligning,

On the home page I have these in order of votes and then run this statement to color code them;

$numone = $num/100*20;
$numtwo = $num/100*40;
$numthree = $num/100*60;

And in the query

if ($rank < "$numone") { $color = "bgcolor=\"#009900\""; } elseif ($rank > "$numone" && $rank < "$numtwo") {
$color = "bgcolor=\"#FF6600\""; } elseif ($rank > "$numtwo" && $rank < "$numthree") {
$color = "bgcolor=\"#CC3300\""; } elseif ($rank > "$numthree") {
$color = "bgcolor=\"#CC0000\""; }
$rank++;

I have now made a search box but would still like it to be color coded from the colors on this page, is there a way I can perform a mysql query to find my songs "rank" by votes and then color it using the thing above, so It makes if easier for my users to understand? Working example can be found here: http://labs.pezmc.com/radio/songlist.php

Sxooter

You probably wanna do the color coding in the php side of the house. But you can use case statements to put it into the query sometimes. It's ugly, but I've done it before. Note in my example I'm using || as the concat operator. You'll either have to change it to concat() or turn on ansi sql in mysql...

select case when field1 > 80 then
'<font color="red">'||field||'</font>'
when field1 > 60 and field1 <=80 then
/// repeat as needed...
else
'font color="brown">||field1||'</font>'
end as colorcoded field

I had the same thing but wrapped it in a function called highlight. You give it a field, a threshold and a color and it colors it for ya.