HEADER

hi,
I'm newbie in programming...tried to do a dropdown using the code below but i can't make it works. Maybe there is mistake on my codes. Anybody plz help me...

Code: Select all

<?php
global $database;
   
$database->setQuery( "SELECT * FROM #__chronoforms_15;" );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."');
  window.history.go(-1); </script>
";

$rows = $database->loadObjectList();
}
?>

<select name="orgtype_id">
    <?php
    foreach($rows as $key=>$value) {
    ?>
    <option value="<?= $value["cf_id"] ?>">
      <?= $value["orgtype_name"] ?></option>
    <?php
    }
    ?>
  </select>

Edited to add code tags

Thanks alot!!:)

I have a similar issue, and don't really understand how to do this with php...visual studio makes this so easy with asp.net, but I digress...

I'm using community builder at my website, but the code for basically everything is quite extensive and I'd rather not modify any of it. What I want to end up doing using chronoforms is create a new community builder registration form.

Background: With CB, it allows you to create custom fields. CB stores all the fields (regardless of type) in jos_comprofiler_fields with any field values (for a radio, multi select, or drop down) in a table called jos_comprofiler_field_values. I've created many such fields and added field values, e.g field = state, field values = all U.S. states. On the CB registration form the user can then select the state from a drop down which is populated by the fields in the database.

What I want to do on my chronoforms registration page is recreate the population of the drop down field using the same tables (no need to reinvent the wheel).

Any ideas?

Thanks,

Steve Nims
www.gammanu.org

I think what the CF plugin only does is map the CF form field name entered data to the correct database field in jos_comprofiler, not load values from jos_comprofiler_field_values.