SQL

[aftab_jii]

i want to show last two posts where posts with category About Me and Our Services are skipped.

i managed to do it with the query below, but it only returns one post if the next post has category About Me or Our Services.

i want the sql to skip the two categories and show two posts

 

$sql = "SELECT article_id FROM articles WHERE is_published=1 AND category <> 'About Me' AND category <> 'Our Services' ORDER BY date_published DESC LIMIT 0,2";
$sql_result = mysql_query($sql)
			or die('Could not run query; ' . mysql_error());

 

i tried with SKIP (category = 'About Me') but got an error

[Ken2k7]

I don't know what you mean "are skipped". Can you lay out an example?

 

Also, you should try using Google rather than making stuff up like SKIP(). Well, at least, I can't find anything on it.

[andrewgauger]

$sql = "SELECT article_id FROM articles WHERE is_published=1 AND category NOT IN('About Me', 'Our Services') ORDER BY date_published DESC LIMIT 0,2";

[aftab_jii]

that worked

thanks