Link to home
Start Free TrialLog in
Avatar of jws2bay
jws2bay

asked on

php dropping ".gif" and appending "-sca1-1000.png "

I am working on a php/mySQL page which has been working fine for a long time, suddenly something which was working is not.  The problem shows up in a lightbox "click on image for more detail".  Noimages are being shown because the path is incorrect.  The actual statement is as follows:

=====================
<a href="images/<?php echo $row_Group1['Large_Image']; ?>" rel="lightbox" title="<?php echo $row_Group1['Name']; ?>"><img src="images/<?php echo $row_Group1['Featured_Image']; ?>" alt="<?php echo $row_Group1['Product_Code']; ?>" <?php echo $row_Group1['Display_Factor']; ?> border="0"></a>

====================

I am getting unexpected results from a php fetch to my db.

This   <?php echo $row_Group1['Large_Image']; ?>  is suppose to bring back this     GEN037CH_12862.gif

but it is bringing back      GEN037CH_12862-sca1-1000.png .

Why is it dropping the ".gif"  and appending  "-sca1-1000.png "
ASKER CERTIFIED SOLUTION
Avatar of Chris Stanyon
Chris Stanyon
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jws2bay
jws2bay

ASKER

You are correct.  A change was made in the database that selectively changed one of the columns in my table.  I am pulling the data in the table. I don't know why the changes were made to the table, but I have put in a patch to solve the problem for my pages.
Avatar of jws2bay

ASKER

Thanks for the help Chris.  Your answers are always spot on.
No worries. Glad I could help :)