can this be done?

[PaulaRun]

I have an admin page that will display a db record into a form that allows the user to update the fields. One of the fields is an image path to a flat file containing the photos of the products. When I display the db record, I have a dropdown that lists all the photos of the products in the flat file. I want to highlight the product photo that the image path currently in the db record. I hope I'm explaining this clearly.

if ($handle = opendir("./images/cardimages")) {
			echo '<br><font size="2">Photo of product:</font><br>';
		  	echo '<select size="1" name="photo">';
	   	// loop through the directory. 

	while (false !== ($file = readdir($handle))) {

		if( $file != '.' && $file != '..' && $file != '_vti_cnf' ){

   			if ($row["image_path"] = "images/cardimages/$file"){
   				echo "<option> $file\n selected</option>";
   			}else{
   				echo "<option> $file\n </option>";	
   				}
		}
	}
	echo '</select>';
	closedir($handle);
	}   

What is happening is all the dropdown values now contain the word "selected" after the product1.gif. I want to select the dropdown that is equal to the image path in the db record.

Does anybody have any advice?

Thanks!!

[cgraz]

I just did a quick skim so I may have the variable name wrong, but here's the logic behind it:

<? // are you assigning a value or checking here? if checking, use 2 equal signs
   if ($row["image_path"] = "images/cardimages/$file") { ?> 
      <option value="<?= $file ?>"<?if ($file == $row["image_path"]) { echo " selected"; } ?>>  

<? } else {
      echo "<option value=\"" . $file . "\"> " . $file . "</option>";    

}

Cgraz

[PaulaRun]

Is there a way to do this and stay in php rather than dropping in and out?

[PaulaRun]

OK, I modified your code (see below) and it is highlighting the right spot but it is blank - the photo.gif is missing.

<?php
if ($handle = opendir("./images/cardimages")) {
    echo '<select size="1" name="photo">';
    // loop through directory.
    while (false !== ($file = readdir($handle))) {
    if( $file != '.' && $file != '..' && $file != '_vti_cnf' ){
       if ($row["image_path"] == "images/cardimages/$file") { ?>
         <option value="<?= $file ?>"  selected>
       <? } else {
          echo "<option value=\"" . $file . "\"> " . $file . "</option>";
          }
      }
    }
    echo '</select>';
    closedir($handle);
}
?>

It looks like the option value, just for the selected option, isn't showing up. Any ideas?

And, thanks so much for your help cgraz!!

[cgraz]

Does it make that big of a diff? I usually weave in and out cause it's cleaner, but something liek this would probably work:

<? // are you assigning a value or checking here? if checking, use 2 equal signs
   if ($row["image_path"] = "images/cardimages/$file") {  

      echo "<option value=\"".$file."\""; if ($file == $row["image_path"]) { echo " selected"; } echo ">";
 } else {
      echo "<option value=\"" . $file . "\"> " . $file . "</option>";    

}

Cgraz

[cgraz]

that was my mistake. In both my posts I forgot to echo out $file after the <option> tag. Just add that in and it'll work.

Cgraz

[PaulaRun]

YAY!!! I got it to work but I had to take out the middle if statement.

<?php
if ($handle = opendir("./images/cardimages")) {
    echo '<select size="1" name="photo">';
    // loop through directory.
    while (false !== ($file = readdir($handle))) {
    if( $file != '.' && $file != '..' && $file != '_vti_cnf' ){
       if ($row["image_path"] == "images/cardimages/$file") {
          echo "<option value=\"".$file."\""; echo " selected"; echo ">"; echo $file;
       } else {
          echo "<option value=\"" . $file . "\"> " . $file . "</option>";
       }
      }
    }
    echo '</select>';
    closedir($handle);
}
?>

Thank you so much cgraz!!