Get Next Row

[rubyarat2010]

Is there a way to get the next row? So il2 and title 2 would be the next row?

mysql_select_db("posts", $con);

$sql = "SELECT title, imagelink FROM posts1 ORDER BY id DESC LIMIT 6";
$result = mysql_query( $sql) or die( mysql_error() );


while($row = mysql_fetch_assoc($result))
{

#echo $row['imagelink'];
$title1 = $row['title'];
$il1 = $row['imagelink'];
$title2 = $row['title'];
$il2 = $row['imagelink'];
}

[Barand]

every time you call

 

$row = mysql_fetch_assoc($result)

 

it fetches the next row.

[rubyarat2010]

Ok.  If i do this the second one goes up one but the first assighn does not work.

$sql = "SELECT title, imagelink FROM posts1 ORDER BY id DESC LIMIT 6";
#$sql2 = "SELECT * FROM posts1 WHERE id='1';";
$result = mysql_query( $sql) or die( mysql_error() );

$title1 = $row['title'];
$il1 = $row['imagelink'];
$row = mysql_fetch_assoc($result);
$title2 = $row['title'];
$il2 = $row['imagelink'];

thanks for the quick responsce.

[rubyarat2010]

Wait never mind figured it out thanks man!!

[hakimserwa]

what did you actually wanted?