News Headlines Help

[Mega]

Dear devbest,
I need help. I'm using Habsys 2's system. All okay just I want it to be like. Anyone help?

But when i integrate these codes

<!-- News Headlines -->
<div class="newscont">
<div id="newscont">
<div class="news_text">
 
<?php
$latest10 = mysql_query("SELECT * FROM news ORDER BY `id` DESC LIMIT 10");
if(mysql_num_rows($latest10) == 0){
    echo 'There are no news topics!';
}else{
    while($l10 = mysql_fetch_array($latest10)){
        $id = $l10["id"];
        $title = $l10["title"];
        $comments = $l10["comments"];
        $author = $l10["author"];
        $username = userRow($author, 'username');
        echo '<a href="article.php?id='.$id.'" title="Author: '.$username.'  |  Comments: '.$comments.'">'.$title.'</a><br>';
    }
}
?>
 
</div>
<div id="post_date"></div>
</div>
</div>

It become like this:

Thank you

 

[Sean]

You need to have the styling:

<div class="newscont">
<div id="newscont">
<div class="news_text">

Inside the While loop

so that it echos one news box for each title.

 

[Mega]

You need to have the styling:

<div class="newscont">
<div id="newscont">
<div class="news_text">

Inside the While loop

so that it echos one news box for each title.

Sorry I'm too php :\ Explain more?

 

[Sean]

Try this:

<!-- News Headlines -->
 
<?php
$latest10 = mysql_query("SELECT * FROM news ORDER BY `id` DESC LIMIT 10");
if(mysql_num_rows($latest10) == 0){
    echo 'There are no news topics!';
}else{
    while($l10 = mysql_fetch_array($latest10)){
        $id = $l10["id"];
        $title = $l10["title"];
        $comments = $l10["comments"];
        $author = $l10["author"];
        $username = userRow($author, 'username');
        echo '<div class="newscont">
              <div id="newscont">
              <div class="news_text">';
        echo '<a href="article.php?id='.$id.'" title="Author: '.$username.'  |  Comments: '.$comments.'">'.$title.'</a><br>';
        echo '</div>
              <div id="post_date"></div>
              </div>
              </div>';
    }
}
?>

 

[Mega]

Try this:

<!-- News Headlines -->
 
<?php
$latest10 = mysql_query("SELECT * FROM news ORDER BY `id` DESC LIMIT 10");
if(mysql_num_rows($latest10) == 0){
    echo 'There are no news topics!';
}else{
    while($l10 = mysql_fetch_array($latest10)){
        $id = $l10["id"];
        $title = $l10["title"];
        $comments = $l10["comments"];
        $author = $l10["author"];
        $username = userRow($author, 'username');
        echo '<div class="newscont">
              <div id="newscont">
              <div class="news_text">';
        echo '<a href="article.php?id='.$id.'" title="Author: '.$username.'  |  Comments: '.$comments.'">'.$title.'</a><br>';
        echo '</div>
              <div id="post_date"></div>
              </div>
              </div>';
    }
}
?>

Thanks, it worked. But how can I maximum it only 3 headlines?

 

[Sean]

use this code:

<!-- News Headlines -->
 
<?php
$latest3 = mysql_query("SELECT * FROM news ORDER BY `id` DESC LIMIT 3");
if(mysql_num_rows($latest3) == 0){
    echo 'There are no news topics!';
}else{
    while($l3 = mysql_fetch_array($latest3)){
        $id = $l3["id"];
        $title = $l3["title"];
        $comments = $l3["comments"];
        $author = $l3["author"];
        $username = userRow($author, 'username');
        echo '<div class="newscont">
              <div id="newscont">
              <div class="news_text">';
        echo '<a href="article.php?id='.$id.'" title="Author: '.$username.'  |  Comments: '.$comments.'">'.$title.'</a><br>';
        echo '</div>
              <div id="post_date"></div>
              </div>
              </div>';
    }
}
?>

 

[Mega]

use this code:

<!-- News Headlines -->
 
<?php
$latest3 = mysql_query("SELECT * FROM news ORDER BY `id` DESC LIMIT 3");
if(mysql_num_rows($latest3) == 0){
    echo 'There are no news topics!';
}else{
    while($l3 = mysql_fetch_array($latest3)){
        $id = $l3["id"];
        $title = $l3["title"];
        $comments = $l3["comments"];
        $author = $l3["author"];
        $username = userRow($author, 'username');
        echo '<div class="newscont">
              <div id="newscont">
              <div class="news_text">';
        echo '<a href="article.php?id='.$id.'" title="Author: '.$username.'  |  Comments: '.$comments.'">'.$title.'</a><br>';
        echo '</div>
              <div id="post_date"></div>
              </div>
              </div>';
    }
}
?>

Thanks Mod close thread please

You must be registered for see links

 

[Sledmore]

Thread closed on request.