passwords in mysql..
Posted: Thu Jun 13, 2002 1:43 am
Ok, I have passwords stored in mysql, I realize its not very secure, but im not hiding anything very secure at the moment...
here is the table i built:
CREATE TABLE users (
fid TINYINT not null AUTO_INCREMENT,
username varchar(80) NOT NULL,
password varchar(50) NOT NULL,
email varchar(150) NOT NULL,
aim varchar(60) NOT NULL,
PRIMARY KEY (fid)
);
now how do i check if the username and password entered is valid, and then execute some statements if it is valid?
here is the table i built:
CREATE TABLE users (
fid TINYINT not null AUTO_INCREMENT,
username varchar(80) NOT NULL,
password varchar(50) NOT NULL,
email varchar(150) NOT NULL,
aim varchar(60) NOT NULL,
PRIMARY KEY (fid)
);
now how do i check if the username and password entered is valid, and then execute some statements if it is valid?