in reply to Accessing information pulled from mysql
in thread Accessing information pulled from mysql

One other hint is: always specify your field names in your SELECT statments. It helps tracking down problems like this down (eg. you know for certain that the column name is spelled correctly in your code, or your statement would fail) also it prevents MySQL from pulling extra information you do not need

Also please mark the line your error is coming from - I miscounted lines (my browser doesn't make it easy - where an editor does) and was looking at the wrong code :(. It just helps us help you :).



grep
Mynd you, mønk bites Kan be pretti nasti...
  • Comment on Re: Accessing information pulled from mysql

Replies are listed 'Best First'.
Accessing information pulled from mysql
by blaze (Friar) on Aug 19, 2002 at 07:45 UTC
    I finally got it, because i was pulling from mysql where pword=$password, if the password was wrong then $user was blank, therefore causing an invalid username error even if the username was correct...i could shoot myself :)

    Thanks for the input grep, normally i would have a more general error message but in this case since i was trying to specify where i was getting an error (and since this is just for my wife anyway) i needed to keep the username and password errors separated so i could know where to look, i did change my select statement to pull to specify my field names, thanks again
[reply]

In Section Seekers of Perl Wisdom