custom forms - data collection

[Veronika7747]

Should this special order work with 1.3.8? When I installed all the files and put link in "more information" sidebox it show there as SIDEBOX_LINK_TEXT_specialorder
and the link address is: main_page=FILENAME_specialorder
(when I specify address main_page=specialorder, form shows up.
Thanks

O.K. for those who may run into the same problem with Form_specialorder as I did:

to include it in information box this is in the instruction in the read me file:
$information[] = '<a href="' . zen_href_link(FILENAME_specialorder) . '">' . SIDEBOX_LINK_TEXT_specialorder . '</a>';

Just remove FILENAME_

in /indludes/languages/english/extra_definitions/specialorder.php
replace this;
define('SIDEBOX_LINK_TEXT_BAND_SIGNUP','Special Order Request');
WITH THIS:
define('SIDEBOX_LINK_TEXT_specialorder','Special Order Request');

[Veronika7747]

I am trying to update one of text fields of the form to be a dropdown field populated with a result of my slq. I already asked couple days ago - http://www.zen-cart.com/forum/showthread.php?t=84820), but no suggestion yet, so I thought I would ask here.. This is what I have;

<?
$query = mysql_query("SELECT products_description.products_name'
        . ' FROM products_description LEFT JOIN products_to_categories ON products_description.products_id = products_to_categories.products_id'
        . ' WHERE (((products_to_categories.categories_id)=13))'
        . ' ORDER BY products_description.products_name" ); 
$result = mysql_query ($query);
?>    
 <label class="inputLabel" for="band_name"><?php echo 'Select a Painting: '; ?></label>
<?php echo zen_draw_pull_down_menu('band_name', $result) . '&nbsp;' . (zen_not_null(ENTRY_REQUIRED_SYMBOL) ? '<span class="alert">' . ENTRY_REQUIRED_SYMBOL . '</span>': '');?>
<br class="clearBoth" />

obviously I am missing something/lot (I tried different things by emulating my ASP code which I can work with), but no luck. I even tried to actually code in the values (since there will be only few at any given time), but even that did not work for me. Can some please give me help?

Thanks Veronika

[bigbadboy]

Anyone have this working on 1.3.8a?

I just installed and it loads fine but when you click send it just refreshes the page and no mail is sent.

I need to create 3 custom forms for the same site so I would appreciate any advice/ tips or help.

Thanks in advance.

[bigbadboy]

timed out!

Scrub my last request as I got it to work.

The problem was with the T and C's acceptance at the bottom of the page was commented out.
I removed it and now it works fine.

[bigbadboy]

Bit of an update. I have everything working great except I need to add a dropdown selection.

What is the dropdown equivalent of a checkbox?
<?php echo zen_draw_checkbox_field('option1', 'Option 1', false, 'id="checkbox"');?>

[bigbadboy]

OK, update again!

(once I get this working I'll post the results)

I got the pull down working but can only get it to use the manufacturers as an array (taken from the advanced search):
<?php echo zen_draw_pull_down_menu('bedrooms', zen_get_manufacturers(array(array('id' => '', 'text' => TEXT_PULLDOWN))), $sData['bedrooms']); ?>

Anyone know how I can point this to use another array besides the manufacturers?
Preferably one built in the header_php.php file with this mod.

[bigbadboy]

I'm still stuck with this one.
Put simply I can get the pull down to display but it has no content.

I tried using the pull downs in advanced search and tried to adapt them, but nothing.

Anyone?