MYSQL Query LIMIT 2

[Foser]

$query = mysql_query("SELECT `post_subject`, post_text FROM `phpbb_posts` WHERE `forum_id` = 2 ORDER by `post_id` DESC LIMIT 2");
$article = mysql_fetch_assoc($query);

this is what I have. I'd like to keep it assoc but if it's easier another way I'm flexible for it.

 

I would know how to echo it out in normal if it was limit 1 but as limit 2 how can I differentiate from $article['post_subject'] (for first in order) and $article['post_subject'](from limit two)

 

thanks, any help is greatly appreciated!

 

 

[jordanwb]

Just use != (Not equals) and compare between the two.

[Foser]

Just use != (Not equals) and compare between the two.

 

could you elaborate? Don't see how that condition would work...

[jordanwb]

Well when you loop through the first row save $article['post_subject'] to it's own variable so it won't be lost. Then when it goes into the second row compare that row's $article['post_subject'] to the variable you just created.

[Foser]

Well the only thing is. I want it seperatly but with the same query as I won't be using a loop.

 

Is this possible?

[jordanwb]

So basically what you're doing is:

 

• Run the query and save the result
  
• Get the first row and do some stuff with it
  
• A little further down get the second row.
  

[BrandonK]

You can throw them to a 3d array:

while ($fetch = mysql_fetch_assoc($query) {
$article[] = $fetch;
}
echo $article[0]['post_subject']; //row 1
echo $article[1]['post_subject']; //row 2

[jordanwb]

Yes that would work.

[Psycho]

<?php

$query = mysql_query("SELECT `post_subject`, post_text FROM `phpbb_posts` WHERE `forum_id` = 2 ORDER by `post_id` DESC LIMIT 2");
$article1 = mysql_fetch_assoc($query);
$article2 = mysql_fetch_assoc($query);

?>