Error, need help

[hoi]

Ermm, this is my error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXCEPT id = '1'' at line 1

and my script:

[code]$query = mysql_query ("SELECT * FROM `leden` WHERE email = '" . $_POST['email'] . "' EXCEPT id = '" . $_COOKIE['id'] . "' ") or die (mysql_error());[/code]

mja, ive got a script, and their u can edit ur email, but i want to select all the emails from the clan EXCEPT for the id of the member itself, how do i do it? :(

[almightyegg]

[code=php:0]$query = mysql_query ("SELECT * FROM `leden` WHERE email = '{$_POST['email']}' EXCEPT id = '{$_COOKIE['id']}' ") or die (mysql_error());[/code] that should work :)

[trq]

[code=php:0]
$query = mysql_query("SELECT * FROM `leden` WHERE email = '" . $_POST['email'] . "' && id <> '" . $_COOKIE['id'] ."'") or die(mysql_error());
[/code]

[CBStrauss]

hmmmm well you could try the != operator meaing if the user who looking for the email address is 1  then try Select all from table where id !=1. In theory that should work maybe someone will correct me if im wrong im not an expert, I still got alot to learn myself

[trq]

Yeah.. you can use either <> or !=

There is no such thing as EXCEPT.

[hoi]

[quote author=thorpe link=topic=113930.msg463359#msg463359 date=1162759100]
[code=php:0]
$query = mysql_query("SELECT * FROM `leden` WHERE email = '" . $_POST['email'] . "' && id <> '" . $_COOKIE['id'] ."'") or die(mysql_error());
[/code]
[/quote]

ty m8, it worked ;)

[quote author=thorpe link=topic=113930.msg463362#msg463362 date=1162759495]
Yeah.. you can use either <> or !=

There is no such thing as EXCEPT.
[/quote]

lol, the except thing... i knew it was wrong, but with the word except, u guys would know what u mean, and give me the good answer ;) ty all