need help

[Odin1985]

ok i'm being working on a login function and this is giving me problem

[code:1]mysql_query("SELECT FROM members WHERE user_ID='$user_ID' AND nick='$nick' AND password='$password' AND activated='1'");[/code:1]

[snow]

Here is where i believe your problem is, in your not actually selecting anything.
[code:1]mysql_query("SELECT "here is where you put what your selecting" FROM members WHERE user_ID='$user_ID' AND nick='$nick' AND password='$password' AND activated='1'");[/code:1]

you can use * it's a random select so it will just select what you need. with the * it should work.

[Odin1985]

ok thx i'll check that

[zubaz]

I've been coding PHP for a while now, and I've never put anything in that space but *. It's always SELECT * FROM `table` WHERE...

[SileNceR]

* being all... returns it.... u could do SELECT rowname, where rowname might be something like posts were u looking for the total amount of posts said usernam ehad etc...

usually easier to get it all tho and break it down from what's returned

[omgwtfdan]

*exits thread quickly*

way to confusing for my simple mind...

wait - do i even have a mind? :?