marquee

[thecableguy2011]

Hi, i have a marquee on my page that is getting its contents from mysql database. It gets all the information, put it in the marquee and it all scrolls, that works fine. The problem is that it take takes all the information and puts it as one line. That is it takes all the records and makes them as one. I want it to seperate them. I think the problem is with my loop. I have tried moving the loop and nothing seems to work. Please help, here is the code that im using         

 

 

      <marquee behavior="scroll" direction="up" onmouseover="this.stop();" onmouseout="this.start();">
                  <h1>
                    <?php

  require_once("connect.php");
  
         $selectsqw = "SELECT name, quantity, price FROM inventory";
         $resultqw = mysql_query($selectsqw);      
         $countrowssaqw = mysql_num_rows($resultqw);
                           
            if ($countrowssaqw > 1) {
            
               while ($resqw = mysql_fetch_array($resultqw)) {
               $resuqw[] = $resqw;   
                                                   }
                                    
               mysql_free_result($resultqw);
               foreach ($resuqw AS $rowqw) {      
?>
                    Latest Tenders: <?php echo "".$rowqw['name']." - ".$rowqw['quantity']." - ".$rowqw['price'].""; ?>
                    <?php } } ?>
                  </h1>
                </marquee>

[ZulfadlyAshBurn]

look below

 <marquee behavior="scroll" direction="up" onmouseover="this.stop();" onmouseout="this.start();">
                  <h1>
                    <?php

  require_once("connect.php");
  
         $selectsqw = "SELECT name, quantity, price FROM inventory";
         $resultqw = mysql_query($selectsqw);      
         $countrowssaqw = mysql_num_rows($resultqw);
                           
            if ($countrowssaqw > 1) {
            
               while ($resqw = mysql_fetch_array($resultqw)) {
               $resuqw[] = $resqw;   
                                                   }
                                    
               mysql_free_result($resultqw);
               foreach ($resuqw AS $rowqw) {      
?>
                    Latest Tenders: <?php echo "".$rowqw['name']." - ".$rowqw['quantity']." - ".$rowqw['price'].""; ?><br>
                    <?php } } ?>
                  </h1>
                </marquee>

 

add a break line -.-

[samoht]

you should consider using javascript instead of marquee too