Hi there!

I'm trying to make a dynamic userpage where I want to show a picture of the logged-in user.
I've tried to do this several ways, but with no luck.
It always ends up with some sort of VBscript runtime error..

In my simple world all I had to do to make this work was to add a column in the db
with ref to a picture on the server (hyperlink).

Any ideas?

Regards, Sarre


Let's face it, designing is fun. Coding....not so fun.

When you don't store your path in your database use something like this:
<pre id=code><font face=courier size=2 id=code>
&lt;img src="photo/&lt;%=(recordset.Fields.Item("photo".Value)%&gt;"&gt;
</font id=code></pre id=code>

When you have stored the path in your database you have to use this instead:
<pre id=code><font face=courier size=2 id=code>
&lt;img src="&lt;%=(recordset.Fields.Item("photo".Value)%&gt;"&gt;
</font id=code></pre id=code>

Thank you Bandsma!

Your tip absolutely did the trick!


Regards, Sarre

Just one last question, though.
The page does not seem to filter the pictures, it shows only pic nr 1 in the list.

I'm guessing the error is in the DW recordset.
Any suggestions?

I have the pics in a folder under ../pics/users/pic01.jpg etc..
The designated picture for the logged in user is in a column named foto.

When you are using the standard User Authenticaion server behaviors of Dreamweaver then you have to filter your recordset on MM_username.

I've tried adding Foto-session to the login page, as regard to the Foto-column i the db,

If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
' username and password match - this is a valid user
Session("MM_Username" = MM_valUsername
Session("Foto" = MM_rsUser("Foto"

..but with no luck.

I think you should set it to your RecordSet Id.

I found a way:
Just did a response.write to the <font color=blue>Session("Foto" = MM_rsUser("Foto"</font id=blue>

Worked like a charm, thanx for helping me along, Bandsma! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Regards, Sarre

Could not get it to work in php. My code is something like

Quote

<img src="../userfiles/products/thumbs/<?php echo $row_products['ProductImage']; ?>" alt="<?php echo $row_products['ProductImage']; ?>" title="<?php echo $row_products['ProductImage']; ?>" width="80" border="0" />