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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
