Re: faulty small cgi/mysql login

You've shown the setup of the table, you have shown the select, but do you have an insert?

Also, you should read about Placeholders in the DBI docs, then 'prepare' will make much more sense (and it will be lots safer).

Comment on Re: faulty small cgi/mysql login

Replies are listed 'Best First'.
Re^2: faulty small cgi/mysql login by Anonymous Monk on Feb 12, 2005 at 17:54 UTC
There is no insert. There's just one username and password in the admin table and that's setup via the DEFAULT statement. .... at least I thought that's how it worked.	[reply]
Re^3: faulty small cgi/mysql login by Animator (Hermit) on Feb 12, 2005 at 17:56 UTC
Nope, The default values are used whenever a value for that particular thingie isn't filled in. If there is no data in the table, then the select will always fail.	[reply]
Re^4: faulty small cgi/mysql login by Anonymous Monk on Feb 12, 2005 at 18:06 UTC
Ahh. Well that would explain it then! I think I can figure out from here, lol. Thanks!	[reply]