Re: Dynamic text for every user

From:	Daniel Carrera	Date:	Sat, 14 Mar 2009 13:15:21 +0000
Subject:	Re: Dynamic text for every user
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-46068@lists.php.net to get a copy of this message

Wilson Osemeilu wrote:

How do i create a table with user id and password, where every user get to see a dynamic text related to them only I get the same dynamic text when every user logs in but i really want them to see their details in the mysql database only. Please help php/mysql users

You mean just a single piece of text? Like the anti-phishing thing some banks do where you enter a secret phrase and the bank displays it to you after you login, so if the text is wrong you know there is a problem? Is that what you want? CREATE TABLE users (

    id        INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    login        CHAR(30) CHARACTER SET utf8 UNIQUE,
    password    CHAR(40) CHARACTER SET ascii,
    secretPhrase    CHAR(40) CHARACTER SET utf8

); Is this what you want? Or did I misunderstand your question? Cheers, Daniel.