[bindvalue] Forum Topics

why is the code below is not working? $sql = "SELECT password, fullname, active FROM ".$mysql_table.""; $sql = $sql . "WHERE username = :username, password = :password"; $statement = $pdo->prepare($sql); $statement->bindValue(':username', $_POST['username']); $statement->bindValue(':password', md5($_POST['password'])); $statement->execute();

I don't know what I'm doing wrong here, but I'm having hard time trying to insert data from a form into the database.The $_session['username'] is set and the database is included and working Here is my table CREATE TABLE IF NOT EXISTS `accounts` ( `accid` int(11) NOT NULL AUTO_INCREMENT, `acc_number` …