I can access the db but it always displays first record in container field. All other fields display correct data.

Code:

<?php

session_start();

include_once('includes/verify_login.php');

include_once('FX/FX.php');

include_once('FX/server_data.php');

require_once('FX/image_proxy.php');

$company = $_SESSION['company'];

$companyrep =new FX($serverIP,$webCompanionPort);

$companyrep -> SetDBData('xxx.fp7','xxx');

$companyrep -> SetDBPassword($webPW,$webUN);

$companyrep -> AddDBParam('Company_Name','='.$company);

$query = $_GET['query'];

$companyrepData = $companyrep->FMFind();

$currentKey = key($companyrepData['data']);

?>

Doesn't Work

<?php echo $companyrepData['data'][$currentKey]['Company_ContactName'][0]; ?>

Works

Any help would be greatly appreciated.

Try this:

Good Luck.

Garry

Garry,

Using that code it produces no image at all. With the code I currently have it always produces the first record no matter who I login with.

Josh

Did you replace "localhost" with the address of your server. You can also check the rendered html in the page to check if the path to the database is correct.

I've seen the same thing happening with the previous code; i.e. the first image showing for all records.

All the best.

Garry

Look at this page is this what you are trying to accomplish.

http://fmwebschool.com/mpetrov/file_manager.php

This is where I add my once every 6 months whine about there needing to be a better solution for displaying container fields (ie image proxy).

Venue Information

<? echo $show_found_venueData['Venue_Information'][0]; ?>

Steven,

It worked for us with the image stored in the Container field.

The table should resize ok to fit the image.

The IP address would the same as the one in "server_data.php".

I believe it should be an issue for FM Inc. as this is not an isolated problem.

I guess you have attempted the standard code:

Good Luck.

Garry

Hi Garry,

I abandoned use of Container fields and solved the problem as follows:

<? echo $show_found_venueData['Venue_Map_URL'][0]; ?>

In the database field 'Venue_Map_URL' I have quoted the image file path and name as follows:

All the referenced maps are stored in the Graphics folder on the web server.

Thanks for your help and yes FM need to look at this issue.

Cheers,

Steven

One thing you could try to improve what you have is:

Store the url in a field "imageurl" in your database.

Then your code is:

img scr=<? echo $show_found_venueData['imageurl'][0]; ?> >

You would store all images in your Graphics Folder.

Remember one important thing - if you want to get image proxy working you need to run the echo_key to get the security key.

Next copy and paste that security key into your image proxy file.

Then the standard image_proxy code should work...