Images not showing on results webpage

msmysql

I am using PHP/MySQL4.x

I have a web page that based on selected check box values the results page will display a page of image names with check boxes.

Navigation:
Selection Page
select any of the radio buttons
on the next page you will see image names with check boxes
check up to 4 <submit>
No images appear, just outlines or blank boxes.

If this is a code problem where should I be looking?

the images are stored at the fileserver level

the selection page code for one of the check boxes:

<td valign=top height=20 class=body3><input type=checkbox name=shoes[] value="/images/mens/level1/eagle.gif">eagle</td>
</tr><tr>

images are stored at the fileserver level:

/images/mens/level1/eagle.gif

the query to select the images includes the IMAGES table that includes the image name and a path to the images that matches the file server.

tha_mink

Your psuedo-code looks fine, but maybe you should post the real code. As far as display goes, maybe your not chmod-ed the right way or something like that, but let's see some code.

msmysql

The chmod is currently set to 755. Should it be set to something else? This is on the images directory where the files are stored.

For the scripts it is set to 644, should this also be 755?

Here is a portion of the script for your review.

$result = mysql_query("SELECT DISTINCTROW products.product_id, products.product_name, images.product_image, products.gender, products_to_injuries.injury_id
FROM (products INNER JOIN products_to_injuries ON products.product_id = products_to_injuries.product_id) INNER JOIN images ON products.product_id = images.product_id WHERE (((products.gender)=$gender) AND ((products_to_injuries.injury_id)=$injury))", $dbh);

if ($myrow = mysql_fetch_array($result)) {
echo "<table cellpadding=0 cellspacing=0 border=0>\n";
do {
echo "<tr>\n\t<td valign=top height=20><input type=checkbox name=shoes[]";
echo " value=\"$myrow[product_image]\">";
echo "$myrow[product_name]</td>\n</tr>";
} while ($myrow = mysql_fetch_array($result));
echo "\t</table>";
} else {
echo "Sorry, no records were found";

} ?></td>
</tr>

liquorvicar

i may be way off the track here as my HTML knowledge is not that detailed but can you actually use the value attribute for a checkbox to display an image in this way??

msmysql

I don't have the answer to your HTML question. This is a joint project with another programmer. In regards to the images I got the following information from the hosting service:

For some reason, the images are not valid, please try reuploading them in Binary format and/or check that the extension is set properly on the file.

Initially the hosting service said it was a coding error.

I have uploaded these jpgs twice using globescape ftp -set to binary. Should I use a different software program? The extension is .jpg for the all the files, so I am not clear on what that comment means. I sent a reply back with the same questions.

Does anyone know how to validate images on a remote server? Or if that is possible? Is there anyway to confirm that they are in binary format?

liquorvicar

if the images are in your web directory tree you could try accessing them directly via a browser:
http://your.web.site/path/to/image.jpg

or try replacing

 echo "<tr>\n\t<td valign=top height=20><input type=checkbox name=shoes[]";
echo " value=\"$myrow[product_image]\">";

with

 echo "<tr>\n\t<td valign=top height=20><img ";
echo " src=\"$myrow[product_image]\">";

and see if that displays the image correctly.

msmysql

I had a support person re-check the ftp server again, and they have verified that some of the images were corrupt. I have deleted the files and reloaded the images and the site now show the images properly. Thank you for your assistance.