Posted on: 12/30/04 07:03pm
By: sharon
<tr> <td valign="top" align="right">{lang_movie}:</td> <td><select name="jap_movie"> <option value="">Select One</option> {movielist}</select></td> </tr>
$jap_template->set_var('movielist', custom_movielist());
function custom_movielist() { global $_CONF, $_TABLES; $retval = array(); $sql = "SELECT artistpage.jap_movie, g2_FileSystemEntity.g_pathComponent FROM artistpage, g2_FileSystemEntity WHERE g2_FileSystemEntity.g_pathComponent LIKE '%.mpg' OR g2_FileSystemEntity.g_pathComponent LIKE '%.mov' ORDER BY g2_FileSystemEntity.g_pathComponent ASC"; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $japmovie = $row['jap_movie']; $movielist = $row['g_pathComponent']; if ($japmovie == $movielist) { $select = " selected"; } else { $select = ""; } $retval .= "<option value="$movielist"$select>$movielist</option>n"; } return $retval; }
Posted on: 12/30/04 07:41pm
By: machinari
Posted on: 12/30/04 07:48pm
By: sharon
function custom_photolist2() { global $_CONF, $_TABLES; $retval = array(); $sql = "SELECT DISTINCT g_pathComponent FROM g2_FileSystemEntity WHERE g_pathComponent LIKE '%.jpg' ORDER BY g_pathComponent ASC"; $result = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $photolist = $row['g_pathComponent']; $retval .= "<option value=\"$photolist\"$select>$photolist</option>\n"; } return $retval; }
Posted on: 12/30/04 08:18pm
By: machinari
Posted on: 12/30/04 08:21pm
By: sharon
Posted on: 12/30/04 09:10pm
By: machinari
$retval .= "<option value=\"$photolist\"$select>$photolist</option>\n";to this
$retval .= "<option value=\"$photolist\"$select >$photolist</option>\n";...notice the extra space added after select variable.. the lack of space before the option's closing bracket seems to return no selected options is some browsers. this was pointed out to me recently in some of my own code.
Posted on: 12/30/04 09:34pm
By: sharon
<option value="aanderson.mpg" selected >aanderson.mpg</option> <option value="abodden.mpg" >abodden.mpg</option> <option value="bdonohue.mpg" >bdonohue.mpg</option> <option value="bsantiago.mpg" >bsantiago.mpg</option> <option value="cjohnson.mpg" >cjohnson.mpg</option> <option value="csportz.mpg" >csportz.mpg</option> <option value="dgabriel.mpg" >dgabriel.mpg</option> <option value="dreed.mpg" >dreed.mpg</option> <option value="egossling.mpg" >egossling.mpg</option> <option value="enieves.mpg" >enieves.mpg</option> <option value="eoshea.mpg" >eoshea.mpg</option> <option value="fcaliendo.mpg" >fcaliendo.mpg</option> <option value="gdee.mpg" >gdee.mpg</option> <option value="gedmonds.mpg" >gedmonds.mpg</option> <option value="iwitty.mpg" >iwitty.mpg</option> <option value="jbush.mpg" >jbush.mpg</option> <option value="jreep.mpg" >jreep.mpg</option> <option value="lcamp.mpg" >lcamp.mpg</option> <option value="mcollins.mpg" >mcollins.mpg</option> <option value="mjr.mpg" >mjr.mpg</option> <option value="mmooney.mpg" >mmooney.mpg</option> <option value="rcollier.mpg" >rcollier.mpg</option> <option value="retta.mpg" >retta.mpg</option> <option value="rparavonian.mpg" >rparavonian.mpg</option> <option value="skennedy.mpg" >skennedy.mpg</option> <option value="tess.mpg" >tess.mpg</option> <option value="tgabrielson.mpg" >tgabrielson.mpg</option> <option value="tpescatelli.mpg" >tpescatelli.mpg</option> <option value="tthirdgill.mpg" >tthirdgill.mpg</option> <option value="tyoung.mpg" >tyoung.mpg</option> <option value="vhenley.mpg" >vhenley.mpg</option> <option value="vmason.mpg" >vmason.mpg</option> <option value="wfox.mpg" >wfox.mpg</option> </select>
Posted on: 12/31/04 12:46am
By: sharon
function custom_movielist() { global $_CONF, $_TABLES, $jap_id; $retval = ''; $select = ''; $sql = "SELECT g_pathComponent FROM g2_FileSystemEntity WHERE g_pathComponent LIKE '%.mpg' OR g_pathComponent LIKE '%.mov' GROUP BY g_pathComponent ASC"; $result = DB_query($sql); while ($row = DB_fetchArray($result)) { $movielist = $row['g_pathComponent']; $sql2 = "SELECT jap_movie from artistpage WHERE jap_id='$jap_id'"; $result2 = DB_query($sql); while ($row2 = DB_fetchArray($result2)) { if ($movielist == $row2['jap_movie']) { $select = " selected"; } } $retval .= "<option value="$movielist"$select>$movielist</option>n"; } return $retval; }
Posted on: 12/31/04 01:20am
By: machinari
$sql2 = "SELECT jap_movie from artistpage WHERE jap_id='$jap_id'"; $result2 = DB_query($sql);should say
$sql2 = "SELECT jap_movie from artistpage WHERE jap_id='$jap_id'"; $result2 = DB_query($sql2);
Posted on: 12/31/04 02:02am
By: machinari
function custom_movielist($jap_id) { global $_CONF, $_TABLES; $retval = ''; $sql = "SELECT a.jap_id, g.g_pathComponent FROM artistpage a, g2_FileSystemEntity g WHERE g.g_pathComponent LIKE '%.mpg' OR g.g_pathComponent LIKE '%.mov' GROUP BY g.g_pathComponent ASC"; $result = DB_query($sql); while ($row = DB_fetchArray($result)) { if ($row['jap_id'] == $jap_id){ $select = 'SELECTED'; } else { $select = ''; } $retval .= '<option value="{$row['g_pathComponent']}" $select >$movielist</option>n'; } return $retval; }give this version a shot assuming you can pass the id to the function. --notice that i went with the two table select... I just like em better.
Posted on: 12/31/04 10:37am
By: sharon
function custom_movielist() { global $_CONF, $_TABLES, $jap_id; $retval = ''; $sql = "SELECT a.jap_id, g.g_pathComponent FROM artistpage a, g2_FileSystemEntity g WHERE g.g_pathComponent LIKE '%.mpg' OR g.g_pathComponent LIKE '%.mov' GROUP BY g.g_pathComponent ASC"; $result = DB_query($sql); while ($row = DB_fetchArray($result)) { $movielist = $row['g_pathComponent']; $id = $row['jap_id']; if ($id == $jap_id) { $select = 'selected'; } else { $select = ''; } $retval .= "<option value="$movielist" $select >$movielist</option>\n"; } return $retval; }
Posted on: 12/31/04 02:10pm
By: machinari
retval .= '<!-- id equals' . $row['jap_id'] . ' and the passed var equals ' . $jap_id . ' -->';hopefully that helps.
Posted on: 12/31/04 04:33pm
By: sharon
function custom_photolist1() { global $_CONF, $_TABLES, $jap_id; $retval = ''; $path = "/home/jedmonds/www/gallery/albums/headshots/"; $dir_handle = opendir($path); while ($file = readdir($dir_handle)) { $fileExt = strtolower(substr($file,-4)); if (!($fileExt==".jpg")) continue; if (strpos($file,'.thumb.')) continue; if (strpos($file,'.highlight.')) continue; $sql = "SELECT jap_photo1, jap_id FROM artistpage WHERE jap_id='$jap_id'"; $result = DB_query($sql); $A = DB_fetchArray($result); if ($A['jap_photo1'] == $file) { $select = " selected"; } else { $select = ""; } $retval .= "<option value=\"$file\"$selected>$file</option>\n"; } closedir($dir_handle); return $retval; }
Posted on: 01/15/05 06:16pm
By: sharon
$path = "/home/jedmonds/www/gallery/albums/movies/"; $dir_handle = @opendir($path) or die("Unable to open $path"); $dirList = array(); while ($file = readdir($dir_handle)) $dirList[] = $file; sort($dirList); foreach ($dirList as $file) { $sql = "SELECT jap_movie, jap_id FROM artistpage WHERE jap_id='$jap_id'"; $result = DB_query($sql); $A = DB_fetchArray($result); $fileExt = strtolower(substr($file,-4)); if (!($fileExt==".mpg" || $fileExt==".mov")) continue; if (strpos($file,'.thumb.')) continue; if (strpos($file,'.highlight.')) continue; if ($A['jap_movie'] == $file) { $select = " selected"; } else { $select = ""; } $retval .= "<option value="$file"$selected>$file</option>n"; } closedir($dir_handle); return $retval;