returning values in a <marquee> tag

[sjones]

Hello, I'm trying to return titles of events and scroll them in a <marquee> tag -but they are stacked on top of each other. Is there a way to have them one after another. Below is the code I am using.

 

<? include 'connections/mysql_connect.php';

            $sql = 'SELECT * FROM `events` ORDER BY `date_created` LIMIT 0, 30';

            $result = mysql_query($sql);

            while ($record = mysql_fetch_assoc($result)){

          $text = $record['title'];

  echo "<marquee scrolldelay='160' width='594' direction='left'><span class='default'><a href='news.php'>" .$record['title']. "</a></span></marquee>";

} 

  ?>

[shocker-z]

You would need to either put lots of spaces inbetween with somthing like this...

 

Remember to try and use full PHP tags e.g. <?php instead of <?

 

<?php   include 'connections/mysql_connect.php';
            $sql = 'SELECT * FROM `events` ORDER BY `date_created` LIMIT 0, 30';
            $result = mysql_query($sql);
            while ($record = mysql_fetch_assoc($result)){
              $text .= $record['title'].'                                                  ';
            }        
            echo "<marquee scrolldelay='160' width='594' direction='left'><span class='default'><a href='news.php'>" .$text. "[/url]</span></marquee>"; 
   ?>

 

do you want just 1 url? or this to be chanbged reflecting the item?

 

Regards

Liam

[sjones]

O.K so I have changed it to this

 

<marquee scrolldelay="160" width="594" direction="left">

<?php  include 'connections/mysql_connect.php';

            $sql = 'SELECT * FROM `events` ORDER BY `date_created` LIMIT 0, 30';

            $result = mysql_query($sql);

            while ($record = mysql_fetch_assoc($result)){

              $text .= $record['title'].'       ';

            }

echo "<span class='default'>" .$text. " </span>";

?>

</marquee>

____________________________________________________________________

This ia returning the titles in one line. Now I have to work on the <a href> tag that will pull the URL for the article that goes with the headline that was returned. Will what I have below work? - using the $url

 

<marquee scrolldelay="160" width="594" direction="left">

  <?php  include 'connections/mysql_connect.php';

            $sql = 'SELECT * FROM `events` ORDER BY `date_created` LIMIT 0, 30';

            $result = mysql_query($sql);

            while ($record = mysql_fetch_assoc($result)){

              $url = $record['url'];

              $text .= $record['title'].'       ';

            }

echo "<span class='default'><a href=".$url.">" .$text. "</a> </span>";

    ?>

</marquee>

[sjones]

That code above does not work for returning the url - its all just one big <a href> with the value of the last url returned.

any help on how to return the title and url from the DB and scroll it in a marquee.??

[sjones]

O.K I have solved it - This returns the the title and the URL - hopefully helpfull for the archive

 

<marquee scrolldelay="160" width="594" direction="left">

  <?php  include 'connections/mysql_connect.php';

            $sql = 'SELECT * FROM `events` ORDER BY `date_created` LIMIT 0, 30';

            $result = mysql_query($sql);

            while ($record = mysql_fetch_assoc($result)){

              echo "<a href=".$record['url'].">".$record['title']. "</a>      " ;

            }

  ?>

</marquee>