Jump to content

[SOLVED] select help


dreamwest

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/157202-solved-select-help/#findComment-828352
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.