pclp19

Many thank you for Barand and ginerjm, troubles are finished. if I want to ask something else please help again. Final code : $sql = mysql_query("SELECT * FROM tov"); while($hs_show = mysql_fetch_array($sql)) { $urut++; $marqueeText .= $hs_show['judul']; // build single text string } echo '<marquee scrollamount="4" align="left" behavior="scroll" direction="left" class="text" onmouseover="this.stop()" onmouseout="this.start()">', $marqueeText, '</marquee>'; ?> case close

sorry I am very confused with this code, when I try $max_results = 2; put after $marqueeText = $hs_show['judul'];, first data appear and showing in 1 line but the problem is next data is unreadable. Can you give a direct code. Thank's

When I use code from Barand suggestion, I try like this : $table = tov; $hal = $_GET[hal]; if(!isset($_GET['hal'])){ $page = 1; } else { $page = $_GET['hal']; } $max_results = 2; $from = (($page * $max_results) - $max_results); $sql = mysql_query("SELECT * FROM $table ORDER BY id_berita DESC LIMIT $from, $max_results"); while($hs_show = mysql_fetch_array($sql)) { $urut++; $marqueeText = $hs_show['judul']; // build single text string ?> <marquee scrollamount="4" align="left" behavior="scroll" direction="left" class="text" onmouseover="this.stop()" onmouseout="this.start()"> <?php echo $marqueeText; ?> </marquee> <?php } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM $table"),0); $total_pages = ceil($total_results / $max_results); And this code still showing/appear 2 lines simultaneously, does not appear by turns.

help me please, my code is : $table = tov; $hal = $_GET[hal]; if(!isset($_GET['hal'])){ $page = 1; } else { $page = $_GET['hal']; } $max_results = 2; $from = (($page * $max_results) - $max_results); $sql = mysql_query("SELECT * FROM $table ORDER BY id_berita DESC LIMIT $from, $max_results"); while($hs_show = mysql_fetch_array($sql)){ $urut++; ?> <marquee scrollamount="4" align="left" behavior="scroll" direction="left" class="text" onmouseover="this.stop()" onmouseout="this.start()"> <?php echo "$hs_show[judul]"; ?> </marquee> <?php } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM $table"),0); $total_pages = ceil($total_results / $max_results); i want the results to be in 1 line and one after the other ,thanks

help me please, my code is : $table = tov; $hal = $_GET[hal]; if(!isset($_GET['hal'])){ $page = 1; } else { $page = $_GET['hal']; } $max_results = 2; $from = (($page * $max_results) - $max_results); $sql = mysql_query("SELECT * FROM $table ORDER BY id_berita DESC LIMIT $from, $max_results"); while($hs_show = mysql_fetch_array($sql)){ $urut++; ?> <marquee scrollamount="4" align="left" behavior="scroll" direction="left" class="text" onmouseover="this.stop()" onmouseout="this.start()"> <?php echo "$hs_show[judul]"; ?> </marquee> <?php } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM $table"),0); $total_pages = ceil($total_results / $max_results); i want the results to be in 1 line and one after the other ,thanks