Exclude result from MySQL query using multiple ID’s


//set parameter in mysql query
$query = “SELECT * FROM category WHERE published=1 and id not in (’11’,’22’,’33’)”;
//execute the query
$result = mysql_query($query);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s