Here's the code:
Code: Select all
<?php
// Match Row in Database
$qChk = "select name from membership where name=='$name' and password=='$password' and (status=='Y' || status=='A' || status=='O' || status=='R') ";
$rsChk = mysql_query($qChk);
?>And the Errors:
I got most the scrpit from a toutorial, but I added the multiple status checks, and I honestly wasn't sure if that would work, but that doesn't seem to be the problem.Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\chibi\Membership\login.php on line 28
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=='Cookie_Monster' and password=='xxxx' and (status=='Y' || s