odbc going nuts
| From: | George Pitcher | Date: | Fri, 04 Jul 2003 08:25:05 +0000 |
| Subject: | odbc going nuts | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29070@lists.php.net to get a copy of this message | ||
Hi all,
Just finishing off a site using odbc and Access and it's thrown up a problem
that wasn't there yesterday.
I have a simple login with a username and password. If either are blank, the
user gets bumped to the login page. otherwise the user table is searched for
the username and password.
my code looks like:
$strSQL = "select * from user where (Username='$username' and
Paswd='$paswd')";
I have an error script that kicks in if the query fails, and prints the
query to screen. I've pasted the query straight into Access' SQL query
window and it worked fine.
I just can't see anything wrong with the code, or anything else.
Any suggestions (apart from dropping Access in favour of another db - client
choice)
Cheers
George in Oxford