PHP Question with vB

[HeTz]

I know I can't use PHP inside templates except in phpinclude. What I created was a select box that pulls the information from an SQL database and updates the next select box depending on what you selected in the other select box... here's an example if that explanation is a little confusing:

Click here to view concept

Now... I need these select boxes in the modifyprofile template (so the user can add their vehicle information in their profile)... but the select boxes are PHP code... example:

PHP Code:

SelectBox ('Year', 'reg_caryear'); 


And the function looks like this:

PHP Code:

function SelectBox( $Label, $selectName ){ 
  ?> 
  <tr ALIGN="LEFT"> 
    <td width="15%"><?php echo $Label ?></td> 
    <td align="left"> 
      <select name="<?php echo $selectName ?>"> 
        <option></option><option></option><option></option> 
        <option>--------- Not Yet Loaded ---------</option> 
      </select> 
    </td> 
  </tr> 
<?php 
}

Now, what I've done (and was unsuccessful) is put the information in the phpinclude template, like this:

PHP Code:

function SelectBox( $Label, $selectName ){ 
  ?> 
  <tr ALIGN="LEFT"> 
    <td width="15%"><?php echo $Label ?></td> 
    <td align="left"> 
      <select name="<?php echo $selectName ?>"> 
        <option></option><option></option><option></option> 
        <option>--------- Not Yet Loaded ---------</option> 
      </select> 
    </td> 
  </tr> 
<?php 
} 

$Year = "SelectBox ('Year', 'reg_caryear');";

Then, from the modifyprofile template, call $Year. This, of course, only prints out: SelectBox ('Year', 'reg_caryear'); - I also tried it without the quotes and it puts my select box at the top of the page

Anyways, I would GREATLY appreciate you if you could help me with this problem. Thank you all for your time.

-HeTz (Brian)