[SOLVED] how to check what the number is

[nathanmaxsonadil]

I have a query to list the top 4 in a mysql table

I want to know how to have an if statment to see what row it's echoing

for example

if(//your echoing row4) {

//do something

}

echo "//normal query";

 

[Wuhtzu]

Do you mean like knowing which row is odd or even - for example to color every 2nd row?

[nathanmaxsonadil]

I mean like I have 4 rows I want before the 3rd row to echo something

[roopurt18]

Do you want to echo the fourth row at all?

[nathanmaxsonadil]

yes I just want to make an addition

[roopurt18]

  $i = 0;
  while($row = mysql_fetch_assoc($result)){
    if($i < 3){
      // Rows 1 - 3
    }
    $i++;
  }

[Wuhtzu]

Just add a counter to your while loop:

 

<?php

$i = 1;

while($row = mysql_fetch_array($gettopfour))

    if($i = 3) {
      echo "something before the 3rd row";
    }
    
    echo $row['something'];

   $i++;

?>

[nathanmaxsonadil]

thanks

[roopurt18]

You missed a less than sign, Wuhtzu.

[Wuhtzu]

Yes it looks like I did, but I actually meant = and not <= at the time... but now I can see I misunderstood him.

 

I thought of "before the 3rd row to echo something" as "to echo something between the 2nd and 3rd row" - but of course (maybe) he want to highlight the 3 highest scores or something like that.

[nathanmaxsonadil]

it puts it on everyline before the 4th one now

[roopurt18]

Yes it looks like I did, but I actually meant = and not <= at the time... but now I can see I misunderstood him.

A single = would have been even more wrong in this context.

 

it puts it on everyline before the 4th one now

<?php
  $i = 0;
  while($row = mysql_fetch_assoc($result)){
    if($i == 4){
      // Rows 1 - 3
    }
    $i++;
  }
?>

 

Are you just blindly copying and pasting code or are you making any attempt to understand what's happening here?

[nathanmaxsonadil]

I ment

to echo something between the 2nd and 3rd row

[Wuhtzu]

Yes, I forgot a =, it should have been ==.

 

If you mean / meant between 2nd and 3rd row you can use something like my first code, just correct the = to ==

 

<?php

$i = 1;

while($row = mysql_fetch_array($gettopfour))

    if($i == 3) {
      echo 'something before the 3rd row';
    }
    
    echo $row['something'];

   $i++;

?>

 

This will echo 'something before the 3rd row' before the third row...

[nathanmaxsonadil]

thanks Wuhtzu