Hi,
If I create a view or use a query with joined tables (in MySQL) Ithat include images there is a problem displaying images in PHPRunner. I'm assuming I'm doing something wrong but don't know how to sort it out.
I don't get the problem if I do a read on a table that contains images, only when a joined read/view is used.
Here's my example.
select `link`.`Inv_val_temp`.`stylename` AS `stylename`,
`link`.`Inv_val_temp`.`warehouse` AS `warehouse`,
`link`.`Inv_val_temp`.`vld` AS `vld`,
`link`.`Inv_val_temp`.`shop` AS `shop`,
`link`.`Style Images`.`tnimage` AS `tnimage`,
`link`.`Style Images`.`image` AS `image`
from
`link`.`Inv_val_temp` join `link`.`styles` on `link`.`Inv_val_temp`.`sequence` = `link`.`styles`.`StyleSequence`
left join `link`.`Style Images` on `link`.`styles`.`StyleSequence` = `link`.`Style Images`.`style`
When I create a report in PHPRunner4.2 everything is correct execpt for the image. The first image is displayed for each record.
I have checked the query in NAVICAT and the image returned for each line is different (they are the correct images).
If I create a table using the output from the query and use that table as the report source all the images print correctly.
Any suggestions? This is driving me nuts!
Thanks
Darren