Problem with mysql_fetch_array rows

[gli]

Hi!

I've sorted latest news from my database by id.

Then the results i fetched array.

All is ok.

Then i want to show recent subject with news text in main news box, but other last two subjects i want to show in archive news box.

And here's my problem that i dont know how to make example third row from that fetched array.

 

Sorry for my bad English.

 

And this is the code:

 

<?

// build the query, order by newest ID and limit it to 10
$sql = "SELECT * FROM news ORDER BY id DESC LIMIT 3";

// run the query and set a result identifier to the recordset
$res = mysql_query($sql);


$article = mysql_fetch_array($res);

[color=red]PROBLEM
echo $article['subject'] . $article['newstext']  ; // there is information from first row
// there is some html elements
echo $article['subject']; //  there is information from second row
// some other html elements
echo $article['subject']; // and there is information from third row
PROBLEM[/color]?> 

 

Thanks

[947740]

Try this?  I am not sure if this is what you want...

 

<?php

// build the query, order by newest ID and limit it to 10
$sql = "SELECT * FROM news ORDER BY id DESC LIMIT 3";

// run the query and set a result identifier to the recordset
$res = mysql_query($sql);


while($article = mysql_fetch_array($res)) {


echo $article['subject'] . $article['newstext']  ; // there is information from first row
// there is some html elements
echo $article['subject']; //  there is information from second row
// some other html elements
echo $article['subject']; // and there is information from third row
}
?> 

 

Question, in the comments you say limit the query to 10 items, but you have a 3?

[jonsjava]

you need a while loop:

<?php
// build the query, order by newest ID and limit it to 10
$sql = "SELECT * FROM news ORDER BY id DESC LIMIT 3";

// run the query and set a result identifier to the recordset
$res = mysql_query($sql);


while ($article = mysql_fetch_assoc($res));

echo $article['subject'] . $article['newstext']  ; // there is information from first row
// there is some html elements
echo $article['subject']; //  there is information from second row
// some other html elements
echo $article['subject']; // and there is information from third row
?> 

[947740]

Don't you need curly braces for while loops, like in my example?

[jonsjava]

*face-palm* yup. his example. not mine*working at same time, sometimes get distracted*

[947740]

 

I just wanted to make sure...I doubt myself a lot...

[gli]

thanks for answers, but problem is not solved. i already tried this. this makes that all that three elements repeats each time and there is more than three results.

i need one result with  subject and news text

second only with subject

and third too only with subject

and not in list but in unique places.

 

[gli]

if you dont understand what i mean, then please tell , and i will make more detailed with picture.

thanks

[947740]

Through a variable (e.g. i) in there.

 

 

 

<?php

// build the query, order by newest ID and limit it to 10
$sql = "SELECT * FROM news ORDER BY id DESC LIMIT 3";

// run the query and set a result identifier to the recordset
$res = mysql_query($sql);


$i = 1;
while($article = mysql_fetch_array($res)) {

if($i == 1) {
echo $article['subject'] . $article['newstext'];
}
else {
echo $article['subject'];
}
$i++;
}
?>