[SOLVED] echo results?

[MDanz]

how do i echo 1st result, 2nd result, 3rd result? i know how to echo all of them, how do i echo the specific... e.g. 2nd result in query.

 

 

  $addz = mysql_query("SELECT * FROM Stacks WHERE username = 'Admin'")or die (mysql_error());

while($rowrun = mysql_fetch_array( $addz)) {
		  
$idz = $rowrun['id'];
		  
		  
		  }

[ram4nd]

if($rowrun['id'] == 2) echo $rowrun['what_ever_is_the_col_name'];

[MDanz]

i don't see how that would work... the id isn't 2.

 

i want the second result from the query.... not where the id=2.

[mikesta707]

use a counter?

$addz = mysql_query("SELECT * FROM Stacks WHERE username = 'Admin'")or die (mysql_error());
$i = 0;
while($rowrun = mysql_fetch_array( $addz)) {
		  
$idz = $rowrun['id']
if ($i == 2){//or i = whatever you want. this would be the third run of the loop
echo $idz;
}

$i++;
}

[MDanz]

thx got it.