while() loop and selection of certain rows

astanos

hi.

I have something like this:

$var = "";
while($row = mysql_fetch_array($res)) {
echo "id: ".$res['id']." var: ".$var ;
}

I'd like to know if it's possible to specify a value for $var ONLY on some rows, let's say row 1 and 3, to have an output like:

id: 1 var: foo
id: 2 var:
id: 3 var: foo
id: 4 var:
id: 10 var:
...

I thought about something like if ($res[1]) {$var = "foo";} but no luck.

Any ideas?
Thx :]

Installer

Don't you mean "$row['id']"?

Something like this would probably work:

$rows_to_show_foo_on = array('1', '3');
$i = 0; 
while($row = mysql_fetch_array($res)) { 
    if (in_array($i++, $rows_to_show_foo_on)) {
        $var = 'foo';
    } else {
        $var = ''
    }
    echo "id: " . $row['id'] . " var: " . $var ; 
}

(The first row will be "row[0]".)

infolock

yep, i just think you are going about it the wrong way. try this

$var = "";
$i=0;
while($row = mysql_fetch_array($res)) {
  if($i == 1 || $i == 3) {
   $var = 'foo';
  } else {
    $var = '';
  }
    echo "id: ".$res['id']." var: ".$var ;
  $i++;
}

Edit : The first response is a better option as you are actually defining your search before the loop and can search it easier than with multiple if/elses like I have given you as an example. Both work though, just his is more efficient.

Edit2: LOL, our code is almost exactly the same lol. cracks me up when my solution mirrors someone else's =) shows we are on the same path at least.

astanos

Installer wrote:
Don't you mean "$row['id']"?

Yeah sorry, I still have to learn how to copy/paste correctly... :p

And thanks a lot, both of you! Works like a charm :]