Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Help please! User Password  

Posted by michelle (michelle), 15 April 2005
Q: I have a users table contain three fields - name password and level. The first three values which if editor, change and level 2 is working well. But when the value of the next colum are added which are: "viewer", "viewer", "1". It don't pass and working. Why?? What are the reasons could be?

part of script:

function check_a_password($name,$password,&$level) {
     global $error;
 //$users = array ("editor" => "change", "viewer"
                             => "viewer");
 $qr=mysql_query("select * from users where
                              name=$name");
 //$result=mysql_query($qr);
 $row=mysql_fetch_assoc($qr);
 //$ulevels = array ("editor" => 2, "viewer" => 1);
 $retstr = "";
  if ($row[password] != $_POST[$password]) {
        $error = 1;
            $retstr = "Not a valid password";
            } else {
       $level = $row[level];
       }
      return $retstr;
}

Thanks

Posted by admin (Graham Ellis), 15 April 2005
$qr=mysql_query("select * from users where name=$name");  

should probably read

$qr=mysql_query("select * from users where name='$name'");

Your original was checking whether the name contains the same values as the column named in the variable $name.  You probably meant to check whether the name had the same value as was in the $name variable.  


Posted by michelle (michelle), 15 April 2005
It's solved! Thanks very much. The reason it don't work because there is no script like $_REQUEST request from the form! Therefore, no name and password is varified . Thanks graham!



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho