Re: [PHP] simple mysql_result() question

Uhm .. I usually do: SELECT COUNT(id) FROM users WHERE name='$username' AND password='$password' if (username is found) // hopefully it's unique found ya else sorry This way you aleays have a value returned... HTH Richard Thursday, April 8, 2004, 3:29:11 AM, you wrote: > hello, > I am

[PHP] simple mysql_result() question

hello, I am trying to authenticate users. I run this MySQL query using vars provided via a form select password from dealers where username = '$user' this works great if $user is actually a user in the database. otherwise i get this error Warning: mysql_result(): Unable to jump to row 0