php - Unexpected output when comparing database column to variable -


I have a code that receives information about players from a MySQL database. I want to apply a special case to HTML output, if their ranking changes, I want to look it like this:

But I want to get it to like it, instead it Prints the rank on each line: 

  $ old_rank = ''; While ($ g = mysql_fetch_object ($ q)) {if ($ g-> rankname! = $ Old_rank) {echo "<">  $ g- & gt; Rank name & Lt; / td & gt; \ n "; $ Old_rank = "& lt; tr & gt; & lt; TD & gt; & amp; nbsp; & lt; / td & gt; \ n"; } Echo " $ g-> Names & lt; / td & gt; & lt; / tr & gt; \ n"; }

What do I need: 

  & lt; Tr & gt; & Lt; TD & gt; A & lt; / TD & gt; & Lt; Td> Craven Hunter & lt; / Td> & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; Td> Cool the Conquer & lt; / Td> & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; Td> Zazi the Beast & lt; / Td> & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; Vice-leader & lt; / TD & gt; & Lt; Td> Igos du Unana & lt; / Td> & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; Td> Sant Papar & lt; / Td> & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; & Nbsp; & Lt; / TD & gt; & Lt; Td> Midvelie Hernfreak & lt; / Td> & Lt; / Tr & gt; .......................

What do I get: 

  & Lt; TR & gt; & Lt; TD & gt; A & lt; / TD & gt; & Lt; TD & gt; Examiner & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; TD & gt; A & lt; / TD & gt; & Lt; Td> Craven Hunter & lt; / Td> & Lt; / Tr & gt; & Lt; TR & gt; & Lt; TD & gt; A & lt; / TD & gt; & Lt; Td> Cool the Conquer & lt; / Td> & Lt; / Tr & gt; & Lt; TR & gt; & Lt; TD & gt; A & lt; / TD & gt; & Lt; Td> Zazi the Beast & lt; / Td> & Lt; / Tr & gt; & Lt; TR & gt; & Lt; TD & gt; Vice-leader & lt; / TD & gt; & Lt; Td> Midvelie Hernfreak & lt; / Td> & Lt; / Tr & gt; & Lt; TR & gt; & Lt; TD & gt; Vice-leader & lt; / TD & gt; & Lt; Td> Sant Papar & lt; / Td> & Lt; / Tr & gt; & Lt; TR & gt; & Lt; TD & gt; Vice-leader & lt; / TD & gt; & Lt; Td> Igos du Unana & lt; / Td> & Lt; / Tr & gt;    
 
 
  $ old_rank  is not equal to  $ G- & gt; Rank name  because the way you are setting  $ old_rank  will contain HTML tags, and  $ g- & gt; Rank name  which you get from, DB will never have HTML tags. 
 
 If such a statement changes you: 
 
  if ($ g-> rankname! = $ Old_rank) {echo "& lt; tr & gt; ; TD> $ G & gt; rankname & lt; / TD & gt; \ n "; $ Old_rank = $ g- & gt; Rank Name; } Other {resonant "<">  & amp; nbsp;  \ n "; }  
 
 This rank prints  if  is a new rank name,  and  prints this blank space.

Comments

Post a Comment