[SOLVED] row display question

[zhangy]

Hello,

I have the tables rows in mysql database echoing out listed by their submission id number. What I am trying to do is have it so the most current row on the list will stand out with a larger font than the the previous rows in the list. Can anyone help?

[aashcool198]

can you post the part of the code you are using?

will be easier to figure out.

[zhangy]

<?php
$sql = "SELECT * FROM $table ORDER BY id DESC LIMIT 25";
$result = mysql_query($sql) or die("Error ". mysql_error(). " with query ". $sql);
if(mysql_num_rows($result) >= 1)
{ 
echo '<div id="front_page_post_container">';
while($row = mysql_fetch_array($result))
{
	echo '<div id="hover_div">';
	echo '<div id="title_container">';
	echo '<h2>';
	echo '<a href="post.php?id='.$row['id'].'">'.stripslashes($row['title']).'</a>';
	echo '</h2>';
	echo '</div>';
	echo '<div id="post_container">';
	echo stripslashes(nl2br(substr($row['post'],0,450)));
	echo ' <a href="post.php?id='.$row['id'].'">Read on...</a>';
	echo '</div>';

[zhangy]

Any ideas? suggestions?

[lonewolf217]

have a counter variable initiated before your while loop and set it to zero.

inside the loop check this variable. if it is zero, highlight the current item however you want, then increment the counter.  then as it goes through the loop no other entry will be highlighted

[zhangy]

Not sure how to right that. Can you point me in the right direction?

 

 

<?php
$sql = "SELECT * FROM $table ORDER BY id DESC LIMIT 25";
$result = mysql_query($sql) or die("Error ". mysql_error(). " with query ". $sql);
if(mysql_num_rows($result) >= 1)
{ 

$count = mysql_num_rows($result);
   
if  {
   $class = '0';
   }else{
   $class = '';
   }

    
echo '<div id="front_page_post_container">';
while($row = mysql_fetch_array($result))
{
	echo '<div id="hover_div" class="{$class}">';
	echo '<div id="title_container">';
	echo '<h2>';
	echo '<a href="post.php?id='.$row['id'].'">'.stripslashes($row['title']).'</a>';
	echo '</h2>';
	echo '</div>';
	echo '<div id="post_container">';
	echo stripslashes(nl2br(substr($row['post'],0,450)));
	echo ' <a href="post.php?id='.$row['id'].'">Read on...</a>';
	echo '</div>';

 

 

 

[Ken2k7]

Well before I even get into the more technical aspect of this, do you know how to use an IF statement?

 

   if  {
   $class = '0';
   }else{
   $class = '';
   }

 

??? Google that. I'm going to let you figure out what's wrong.

[zhangy]

Ok i see what you mean, but I tried the following and it has no effect.

 

<?php
$sql = "SELECT * FROM $table ORDER BY id DESC LIMIT 25"; 
$result = mysql_query($sql) or die("Error ". mysql_error(). " with query ". $sql); 
if(mysql_num_rows($result) >= 1) 
{  
    echo '<div id="front_page_post_container">'; 
    $RsCounter = 0;
    while($row = mysql_fetch_array($result)) 
    { 
        $RsCounter++;
        if($RsCounter == 0){
             echo '<div id="hover_div" style="font-size: 15px; font-weight: bold;">'; 
        } else {
             echo '<div id="hover_div">'; 
        }
        echo '<div id="title_container">'; 
	echo '<h2>';
	echo '<a href="post.php?id='.$row['id'].'">'.stripslashes($row['title']).'</a>';
	echo '</h2>';
	echo '</div>';
	echo '<div id="post_container">';
	echo stripslashes(nl2br(substr($row['post'],0,450)));
	echo ' <a href="post.php?id='.$row['id'].'">Read on...</a>';
	echo '</div>';
	echo '</div>';
}
echo '</div>';
}
else
{
echo "That record does not exist!";
}
?>

 

 

[lonewolf217]

<?php
    $RsCounter = 0;
    while($row = mysql_fetch_array($result)) 
    { 
        $RsCounter++;
        if($RsCounter == 0){
             echo '<div id="hover_div" style="font-size: 15px; font-weight: bold;">'; 
        } else {
             echo '<div id="hover_div">'; 
        }

 

you are incrementing the counter before you ever check it.

[zhangy]

Oh i see! Thanks!