Changeset 324 for trunk/lib/TemplateGlue.inc.php

Timestamp:

Apr 26, 2008 1:25:46 AM (16 years ago)

Author:

quinn

Message:

Minor updates.

File:

• trunk/lib/TemplateGlue.inc.php (modified) (2 diffs)

trunk/lib/TemplateGlue.inc.php

@@ -302 +302 @@
  * @param  string $extra_clause     SQL exclude cluase. Something like "WHERE girls != 'buckteeth'"
  */
-function printSelectForm($db_table, $key_column, $val_column, $preselected, $blank=false, $extra_clause='')
+function printSelectForm($db_table, $key_column, $val_column, $preselected, $blank=false, $extra_clause='', $sql_format='SELECT %1$s, %2$s FROM %3$s %4$s')
 {
     $db =& DB::getInstance();
@@ -326 +326 @@
         }
     }
-    $qid = $db->query("SELECT $key_column, $val_column FROM $db_table $extra_clause",false);
+    // $qid = $db->query("SELECT $key_column, $val_column FROM $db_table $extra_clause",false);
+    $qid = $db->query(sprintf($sql_format, $key_column, $val_column, $db_table, $extra_clause),false);
     while ($row = mysql_fetch_assoc($qid)) {
         $selected = in_array($row[$val_column], $preselected) ? ' selected="selected"' : '';