Re: More include issues

I only added those echo's since we have been trying to figure this out, so I could see how far it was getting before it stopped. When I select "VIew Source", the last line of code is: <SELECT name="credit_card"> On 6/6/07, Stut <stuttle@gmail.com> wrote:

Dan Shirah wrote: <SELECT name="credit_card"> <?php * *** This is the query that uses the inlude file database connection info that is currently returning no results * // Query the credit_card_type table and load all of the records // into an array. echo "Pre-SQL"; **** This does not echo out* $sql = "SELECT * FROM credit_card_code_types ORDER BY credit_card_type_desc"; $res = mssql_query($sql) or die(mssql_error()); echo $sql; **** This does not echo out* echo $res; **** This does not echo out* while ($rec = mssql_fetch_assoc($res)) $credit_card_type_desc[] = $rec; // die('<pre>'.print_r($credit_card_type_code)); * *** No data is returned in the dropdown list* foreach ($credit_card_type_desc as $c) {

    if ($c['credit_card_type_code'] == $_POST['credit_card'])
      echo "<OPTION value=\"{$c['credit_card_type_code']}\"

SELECTED>{$c['credit_card_type_desc']}</OPTION>\n";

    else
      echo "<OPTION

value=\"{$c['credit_card_type_code']}\">{$c['credit_card_type_desc']}</OPTION>\n"; } ?> </SELECT> Get rid of the echo statements in there - they will really screw up the output of the select box. Alternatively view the source of the page this displays - chances are that the options are being output properly, but the HTML is so messed up that you end up with an empty select box. -Stut