--0-1874414992-1237033661=:39795
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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 user=
s
=A0
Thanks=0A=0A=0A
--0-1874414992-1237033661=:39795--

On Mar 14, 2009, at 8:27, Wilson Osemeilu <engrwille [at] yahoo.com> 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
>
> Thanks
>
>

It's pretty simple.

Select * from content where id = $id and page='$page'

To get the content for a specific page

Bastien

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php