I am having an issue trying to run an sql query from a php script. I have checked the query through phpmyadmin and it runs fine but whenever I run it through php i get an error. The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given" I have seen lots of threads on this error and people commenting the error is caused my names not matching between the query and the db but I know this is not the case.
$result = mysql_query("SELECT name, company, email, active FROM members WHERE username='".$_POST['username']."' AND password=md5('".$_POST['pwd']."')"); $mem_details = mysql_fetch_array( $result );
I would really appreciate a fix to this if anyone can see it.