[SOLVED] select help

[dreamwest]

i cant figure out how to select "is not sumthing"

 

ive tried:

 

$result = mysql_query("SELECT id FROM video WHERE user_id NOT '1'") or die(mysql_error()); 

 

and

 

$result = mysql_query("SELECT id FROM video WHERE user_id IS NOT '1' ") or die(mysql_error()); 

 

 

[joozt]

Try:

 

$result = mysql_query("SELECT id FROM video WHERE user_id <> '1' ") or die(mysql_error()); 

 

<> means not

[kickstart]

Hi

 

As above, but there are several ways to do this:-

 

$result = mysql_query("SELECT id FROM video WHERE user_id != '1'") or die(mysql_error());

 

$result = mysql_query("SELECT id FROM video WHERE user_id <> '1'") or die(mysql_error());

 

$result = mysql_query("SELECT id FROM video WHERE NOT (user_id = '1')") or die(mysql_error());

 

$result = mysql_query("SELECT id FROM video WHERE user_id NOT LIKE '1'") or die(mysql_error());

 

I would say go for either of the first 2.

 

All the best

 

Keith

[dreamwest]

Sweet thanks!

 

I used !=