[RESOLVED] Using Marquee and Mysql/php

[myfafa]

hi all
i wanna show the result of my query in marquee, but the out put is some thing terrible, each record has own marquee, how can i handle it?

<?php
class ProductNavigation{

function show(){

	$page_Location = "pages/Product.php";	
	$rs['create'] = "true";

	if(Util::executeQuery("SELECT id, name FROM product ORDER BY id ASC LIMIT 5",$rs) > 0){					
		if(is_array($rs)){				
			while($row = array_shift($rs)){		
				?><div><MARQUEE onmouseover=this.stop() onmouseout=this.start() scrollDelay=170 direction='up' height='50'>
                        <? echo " <a  href=\"".$page_Location."?id=". $row['id']."\">".$row['name']."</a><hr\> "?></MARQUEE></div>
<?   			 }
			}			
		}		 
	}
}
?>

[NogDog]

Put the <marquee> and </marquee> tags outside of the while loop.

[myfafa]

Thanks it works.

[bradgrafelman]

Don't forget to mark this thread resolved.