Determine if variable is last in a while statement [+6rep]

[Blinger1]

G'day y'all!

Quick question, how do i determine if a variable is the last in a while statement? Say the following is my while statement, i don't want there to be the "<hr>" after the last entry..

while($row = mysql_fetch_array($query)){
                $id = $row['id'];
            
                $from = $row['from'];
                $from = username($from);
                
                $message = $row['message'];
                $date = $row['date'];
                
                echo("<p><strong>id</strong>: $id<br />
                      <strong>from</strong>: $from<br />
                      <strong>message</strong>: $message<br />
                      <strong>date</strong>: $date<br />
                      <hr>
                     ");
            } 

No need to comment on the code apart from how to determine the last variable plz.

[Excellent2]

I'm not sure about this but couldn't you use strpos()?

[BoyBetterKnow]

Just do a mysql_num_rows and then in the while increase a var by one each loop. Then if the mysql_num_rows resource = the number it's currently on, don't echo the <hr>

[Blinger1]

Just do a mysql_num_rows and then in the while increase a var by one each loop. Then if the mysql_num_rows resource = the number it's currently on, don't echo the <hr>

I used your method. cheers!

and i +repped you both

[BoyBetterKnow]

I used your method. cheers!

and i +repped you both

Thanks very much. I need rep haha.

[Blinger1]

hmm.. it looks like it?

Show Hide

$num_rows = mysql_num_rows($query)
$whileCount = 0;
while($row = mysql_fetch_array($query)){
  $whilecount ++;
  $id = $row['id'];
            
  $from = $row['from'];
  $from = username($from);
                
  $message = $row['message'];
  $date = $row['date'];
                
  echo("<p><strong>id</strong>: $id<br />
  <strong>from</strong>: $from<br />
  <strong>message</strong>: $message<br />
  <strong>date</strong>: $date<br />
  ");
  if($num_rows != $whileCount){
    echo("<hr>");
  }
} 

was my end code btw

[Dentafrice]

If you want an easier way; without incrementing, checking the numbers, or a wasteful
num_rows

It puts the <hr> on all of them.. then just removes the last one and echos out the combined string.

while($row = mysql_fetch_array($query)) {
    $string .= "<p><strong>id</strong>: {$row["id"]}<br />";
    
    $from = username($row["from"]);
    $string .= "<strong>from</strong>: {$from}<br />";
    
    $string .= "<strong>message</strong>: {$row["message"]}<br />";
    $string .= "<strong>date</strong>: {$row["date"]}<br />";
    $string .= "</p><hr />";
}

echo substr_replace($string, "", -6); 

[Blinger1]

Your code looks more complicated!

So i have a few questions: what does the ".=" thing mean? I presume it means $string .= $string+"</p><hr />"; ?

And also, what does the last line mean? That is the most confusing part!

[Tomm]

It just removes the last 6 characters from $string, not anything super complicated

Your code looks more complicated!

So i have a few questions: what does the ".=" thing mean? I presume it means $string .= $string+"</p><hr />"; ?

And also, what does the last line mean? That is the most confusing part!

[Blinger1]

oh right! +rep to you too then