User Image based on database (HELP!)

[benoitlapointe]

Hello everybody,

 

I'm a newbie to PHP. I am building a simple member page protected by username and password. Its built, i can login and get to my member page. I can display the member name based on the user that is connected. NOW my only problem is i don't know how to get for each different user a different image to display (beside the name).

 

I have a database called "worker"

I have a table called "members"

I have 4 fields (id, real_name,username,password)

 

I wanna add another field called user_picture, in which each user has their own picture.  Let's say user Bob signs in, well "Welcome Bob will appear" and also the picture would appear.

 

So what i don't know how to do is make that picture appear, what kind of field do i need to create, and what is the php code for that

 

 

Thanks alot

[phpzone]

You want want it to be a BLOB.

 

However, you could also just upload the image to the filesystem with the insert_id as the filename prefix

when you create the user?  Do you _need_ it in the database?