Re: More include issues

Okay, here's the entire thing: <body> <div align="center">

    <h3>Submit a New Payment.</h3>

</div> <?php include '../../Conn/prpr_mssql.php'; ****The echo in this include displays* include '../../Conn/prpr_common.php'; ****The echo in this include displays *$max_id = $_POST['max_id']; ?> <form name="inputForm" action="" method="post" enctype="multipart/form-data"> <input type="hidden" name="max_id" value="<?php echo $max_id; ?>"> <?php if(!empty($_POST['max_id'])) { **** For this test, max_id is empty* } else { ?> <table align="center" border="0" cellpadding="0" cellspacing="0" width="680"> <tr> <td height="13" align="center" class="tblhead"><strong>Credit Card Information</strong></td> </tr> <tr>

      <td colspan="6"><hr color="#006600"></td>

</tr> <tr> <td width="100%" class="cellbk1"> <table border="0" cellpadding="2" cellspacing="1" width="100%" height="100%">

           </table>

</td> </tr> <tr> <td width="100%" class="cellbk1"> <table border="0" cellpadding="2" cellspacing="1" width="100%" height="100%"> <tr>

    <TD CLASS="CELLBK2">
     <table border="0" cellpadding="2" cellspacing="1">

             <tr>
               <td width="129" height="42" align="left">
                 <div align="right">Is it a debit card?</div></td>
               <td width="112"><input type="radio" name="debit_card"

value="Y">

                 <span class="small">Yes</span> <input type="Radio"

name="debit_card" value="N">

                 <span class="small">No</span> </td>
               <td width="138" align="right"><div align="right"><a

href="javascript:CCTYPEhelp();" class="med">Credit Card Type:</a></div></td>

               <td width="274" align="left" class="tblcell_sm">

<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> </td>

             </tr>

</table> </table> On 6/6/07, Stut <stuttle@gmail.com> wrote:

You can't rely on everyone seeing the different colours in your text. Please lay out your replies so they can be read in plain text. Dan Shirah wrote: Ok, I can't see anything wrong with that. Me either Are you absolutely sure it works when you replace the include line with the contents of the include file? Are you sure you're replacing it exactly? Yes, because when I originally made the form I had the connection info hard coded. I "cut" the info from the form and pasted it into the newly created include file. One minor thing... that include file is not the same path and filename you gave in your original post. You are looking at the right piece of code yes? Yeah, in my previous post I changed the folder/file name just to be safe, but I forgot to do it before posting this one. One thing I'd suggest you add is a check after the mssql_query to see how many rows were returned. Beyond that I'm stumped. Something must be different. Assuming none of these files are being used inside a function or class the act of simply moving code out to an included file should not affect its operation. -Stut