SELECT query not including xx

[CanMan2004]

Hi all

I have a simple query

[code]$q = "SELECT * FROM logins WHERE name='$name'";[/code]

Is it possible to make the query ignore a particular row id number?

So the code would look something like

[code]$q = "SELECT * FROM logins WHERE name='$name' WHERE id != '342'";[/code]

That would select everything apart from id number 342

Any help would be great

Thanks in advance

Ed

[Orio]

In SQL, the not-equal sign is not != like in PHP, it's <>. For exmaple:
SELECT * FROM logins WHERE name='$name' AND id <> '342'

(And you use the "AND" or "OR" oparetors, not multiply "WHERE")

Orio.