Hey, just signed up to this forum so first of all would like to say Hi . I am currently working on a review website building from code I had written previously. The problem I am having is with my login script. I Have three pages set out index.html, login.html and loginCentre.html. The login previously worked on my old site however I changed the email login field to username( thought it looked more professional :)). I also changed the names of fields in mySQL database. I used a nice bit of code to echo out the query and got the error message on my login.html file :
There is something wrong with my query ! executed query = SELECT id,name,password FROM customers where username='asd' Error =Unknown column 'username' in 'where clause'
The query I was trying to run was:
$dbQuery="SELECT id,name,password FROM customers where username='$username'";
$result = mysql_query($dbQuery,$db)
Any input would be much appreciated.
Thanks in advance guys :)