Get most recent 6 entries

[Fou-Lu]

Uhh, what? You don't query for "author" anywhere here, so you cannot extract it. All you have to work with is title and imagelink, nothing more, nothing less. If you want author, you'll need to query for it.
And I wouldn't bother with list if you are already pulling from $row array.
So what are you planning to do with "author" and "imageink"?

[sherlockturtle]

Sorry I had image link there I meant author.

[sherlockturtle]

$sql = "SELECT title, author FROM posts1 ORDER BY id DESC LIMIT 6";
$result = mysql_query( $sql ) or die( mysql_error() );
while($row = mysql_fetch_assoc($result))
{

     $il = $row["author"];
     $title   = $row["title"];
}

mysql_close($con);

?>

[Fou-Lu]

Your query still does not include the author, only the title and imagelink.

[sherlockturtle]

Ok sorry thats what i was saying i meant author...

[Fou-Lu]

The code you've posted above will work as expected. Each iteration for $il and $title will have the corresponding author and title for the current record.

[sherlockturtle]

But it only gets the first one.

[Fou-Lu]

No, it fetches all of them. But if you use your variables outside of the loop it will only be the last result iterated.

[sherlockturtle]

So as I said how could i get an individual one?

[Fou-Lu]

An individual what? Record? Seek it if you don't need to iterate them all.

[sherlockturtle]

As i said originaly I want to get a specific collums row in this case author and then the fifth one but I DIDINT know how to IMPLEMENT it into my current code.

[Fou-Lu]

You're not making any sense here.
If you want the FIFTH record from a resultset, use mysql_data_seek to move the resultset pointer to the fifth row. Then call a fetch on the row to pull the record out. I demonstrated this a number of posts back.

[sherlockturtle]

But I said I did not know how to implement it into my code.

sql = "SELECT title, author FROM posts1 ORDER BY id DESC LIMIT 6";
$result = mysql_query( $sql ) or die( mysql_error() );
while($row = mysql_fetch_assoc($result))
{

     $il = $row["author"];
     $title   = $row["title"];
}

mysql_close($con);

?>

[Fou-Lu]

And a copy and paste of the code I added result in. . .?

[sherlockturtle]

Would i do $li = mysql_data_seek($result, 4);
$record = mysql_fetch_assoc($result); ??