close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I am trying to display the members picture, name and date of birth in a recordset. I can display the name of the picture in the recordset but I can not display the actual picture. See more below.

Thread began 3/01/2022 5:43 pm by msmoose2400634 | Last modified 3/18/2022 1:22 pm by Ray Borduin | 231 views | 29 replies |

msmoose2400634

I am trying to display the members picture, name and date of birth in a recordset. I can display the name of the picture in the recordset but I can not display the actual picture. See more below.

Basically what I am trying to do is display the picture of the member with their date of birth and their picture. Thank you!

I have a recordset that has 3 fields, member name, avartar ( varchar100, that holds the picture name of the member, and the perseq (primary field) I also have a folder membersPage/avartar/thumbnails (that holds the actual picture and the name of the picture); when I create a table to display the picture name and the member's name everything works fine, but I want to display the actual picture and not the picture name. I tried using the File Manipulation but I am unsucessful.

Sign in to reply to this post

Ray BorduinWebAssist

You probably just need something like:

php:
<img  src="membersPage/avatar/thumbnails/<?php echo($rs_birthdays->getColumnVal("avartar ")); ?>">
Sign in to reply to this post
Did this help? Tips are appreciated...

msmoose2400634

Didn't work (sad)

I changed the code as you suggested and I get an image icon for the recordset but not the actual picture itself. I also tried the File Maniuplation as I thought this is where I would download the picture and I get an error message (you will see it in the attachment.

I tried it both ways as well:
<td><img src="/membersPage/avatar/thumbnails/<?php echo($rs_birthdays->getColumnVal("avartar ")); ?>">
<td><img src="membersPage/avatar/thumbnails/<?php echo($rs_birthdays->getColumnVal("avartar ")); ?>">

Attached Files
Doc3.pdf
Sign in to reply to this post

msmoose2400634

oops I did put the closing </td> just forgot to put it in the previous post to you, sorry

Sign in to reply to this post

Ray BorduinWebAssist

It looks like your column name may have a typo try:


<td><img src="/membersPage/avatar/thumbnails/<?php echo($rs_birthdays->getColumnVal("avatar",false)); ?>"></td>

Sign in to reply to this post
Did this help? Tips are appreciated...

msmoose2400634

Originally Said By: Ray Borduin
  It looks like your column name may have a typo try:


<td><img src="/membersPage/avatar/thumbnails/<?php echo($rs_birthdays->getColumnVal("avatar",false)); ?>"></td>  


I copied and paste your code and I still get the same results, the image does not appear but just a broken image icon. I have attached a document and circled on the property for the ima scr property and it shows a broken image icon, is that showing me an error. And I really appreciate your time and efforts to help me (as I am rewritting all my websites because I used Dreamweaver CS3 and the Developer's toolkit so this is somewhat of a big learning curve for me). Do you know of a tutorial for webassist on how to download a dynamic image from a recordset so I can try to understand the process instead of reaching out to you all of the time).

I also circled the image icon on the birthday list so you can see what is being displayed.

Sign in to reply to this post

Ray BorduinWebAssist

Can you attach the .php page and include a url where I can see the problem? Are you sure the column name is correct? Are you sure the database has a valid image name?

Sign in to reply to this post
Did this help? Tips are appreciated...

msmoose2400634

I have attached the .php page and I also attached a screen image that displays the person's image name, the image icon and on the far right is the remote server avatar directory that shows the image name, I wanted to make sure that the person's image name under the birthday list is also in the membersPage/avatar directory, which it is. http://testkaren.site/home1.php my working website that I am trying to rewrite is www.OldUnionWGA.com and you can see how the birthday image is suppose to display.

Thank you

Attached Files
Doc4.pdf
home1.php
Sign in to reply to this post

Ray BorduinWebAssist

It looks like the images are showing now. Did you find the solution? One of them has a missing image, so you probably just need an IF statement to show an image not found image instead.

Sign in to reply to this post
Did this help? Tips are appreciated...

msmoose2400634

Originally Said By: Ray Borduin
  It looks like the images are showing now. Did you find the solution? One of them has a missing image, so you probably just need an IF statement to show an image not found image instead.  



Yes I am sorry I thought I replied that I found my error, here is the correct path. You had it right but I didn't catch the silly quote mark.

<td><img src="membersPage/avatar/<?php echo($rs_birthdays->getColumnVal("avartar")); ?>" width="50" height="50"> </td>

I needed to put the php statement inside the quotes. And yes you are right I will need an IF statement for those who do not have a picture.

But now I have a worst problem, but I am trying to work around it before I reach out to you (oops i guess I am reaching out to you). It is so strange. The home1.php shows my mysql recordsets under the binding panel, but when I either refresh or click the plus sign to add the database it gives me this error message. "No tables found. Please check your connection. Which is strange because I haven't changed anything. I attached the screen shot.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...