Hiding Text when MySQL has no data value

[stuckinbed]

When a user signs into my website, he/she sees the following personalized
information:

Name: sample user
Birthdate: 01/01/2005
Favorite color: brown
Favorite TV show: Desperate Housewives


Say my user did NOT specify his/her favorite color in my database. It would
look like this:

Name: sample user
Birthdate: 01/01/2005
Favorite color:
Favorite TV show: Desperate Housewives


Why should the text "favorite color" still be there? It is not necessary. I
want it to look like this:

Name: sample user
Birthdate: 01/01/2004
Favorite TV show: Desperate Housewives

sorry if i'm an idiot, but i can't figure this out! thanks a lot for any help
:-)

[Alexandro Colorado]

On Thu, 24 Mar 2005 04:59:19 +0000 (UTC), stuckinbed
<webforumsuser@macromedia.com> wrote:

> When a user signs into my website, he/she sees the following personalized
> information:
>
> Name: sample user
> Birthdate: 01/01/2005
> Favorite color: brown
> Favorite TV show: Desperate Housewives
>
>
> Say my user did NOT specify his/her favorite color in my database. It
> would
> look like this:
>
> Name: sample user
> Birthdate: 01/01/2005
> Favorite color:
> Favorite TV show: Desperate Housewives
>
>
> Why should the text "favorite color" still be there? It is not
> necessary. I
> want it to look like this:
>
> Name: sample user
> Birthdate: 01/01/2004
> Favorite TV show: Desperate Housewives
>
> sorry if i'm an idiot, but i can't figure this out! thanks a lot for
> any help
> :-)
>
>
>

Usually you display this on a conditional regarding his session variable.
In other words it will only display if he is inside a session. I guess the
best way would be to include the whole paragraph under the conditional,
unless you really want the unidentified user to be labled as a 'sample
user' :D

--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

[stuckinbed]

thanks for your reply...

the "sample user" is just a example of a record in the mysql database

i'd like to know how to hide "favorite color" if the user never specified
his/her favorite color in the database in the first place

thanks!