[RESOLVED] Omit certain rows?

spiderfang

Hi,

I’m not sure if this is possible to do.

Basically I have a database (hundreds of rows)

i.e

I want to show every row but omit rows that contain ‘1111’ in Category. My coding is as follows at the moment this is perfect for showing every row. How would I amend this to omit ‘1111’.

<?php

$result= mysql_query("SELECT * FROM dbname WHERE category  LIKE '%' ORDER BY name");

 while($row = mysql_fetch_array( $result )) 

{ echo $row['Link_Name']; }

?>

Many Thanks

Tracer

Try
SELECT * FROM dbname WHERE category <> '1111' ORDER BY name"

Piranha

Or
SELECT * FROM dbname WHERE category != '1111' ORDER BY name

spiderfang

Yeeeeeee! 🙂

Cheers!!!

Both work fine.

Many Thanks!

Tracer

FYI: both <> AND != mean "Not Equal Too"

spiderfang

Thanks Tracer I'll keep note of that.

spiderfang

Say I want to omit ‘1111’ and ‘4444’?

spiderfang

YEH! 🙂

No probs... found answer in another thread.

Cheers all!