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.
-Stut
On 6/6/07, Stut <stuttle@xxxxxxxxx> wrote:
Dan Shirah wrote:
> Ask and you shall recieve!! :)
>
> // My include statement at the beginning of the body
> <?php include '../../Conn/prpr_mssql.php'; ?>
>
> **Various plain HTML form data here**
>
> // My dropdown box that is not getting populated
> <?php
> // Query the credit_card_type table and load all of the records
> // into an array.
> $sql = "SELECT * FROM credit_card_code_types ORDER BY
> credit_card_type_desc";
> $res = mssql_query($sql) or die(mssql_error());
> while ($rec = mssql_fetch_assoc($res)) $credit_card_type_desc[] =
$rec;
>
> // die('<pre>'.print_r($credit_card_type_code));
>
> 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";
>
> }
> ?>
Ok, I can't see anything wrong with that. 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?
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?
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.
-Stut
> On 6/6/07, *Stut* <stuttle@xxxxxxxxx <mailto:stuttle@xxxxxxxxx>> wrote:
>
> Dan Shirah wrote:
> > If I put an echo into my included file, the echo displays on the
> screen.
> >
> > But no results are returned.
> >
> > However, if I copy the data from my include file and paste it
> directly
> > into my page, I get the results.
>
> Ok, so that's confirmed that the include file is being included
> properly. I think we need to see the code you're using to get the
data
> before we can help any more.
>
> -Stut
>
> > On 6/6/07, *Stut* <stuttle@xxxxxxxxx <mailto:stuttle@xxxxxxxxx>
> <mailto: stuttle@xxxxxxxxx <mailto:stuttle@xxxxxxxxx>>> wrote:
> >
> > Dan Shirah wrote:
> > > I have error_reporting set to E_ALL and display_errors is
> set to On.
> > >
> > > And no errors are displayed
> > >
> > > My code run through as it should...passes my include
> > statement...displays
> > > part of the form, but when it gets to a dropdown box that
is
> > populated by
> > > the database (Which the connection is set in the include)
it
> > returns an
> > > empty drop down and none of the rest of my form is
displayed.
> >
> > Try outputting something in the include file. If that gets
> displayed
> > then the problem is most likely that the code you have to get
the
> > dropdown contents is not returning anything.
> >
> > -Stut
> >
> > > On 6/6/07, Jim Lucas < lists@xxxxxxxxx
> <mailto:lists@xxxxxxxxx> <mailto:lists@xxxxxxxxx
> <mailto:lists@xxxxxxxxx>>>
> > wrote:
> > >>
> > >> Dan Shirah wrote:
> > >> > Okay, I'm stumped!!!
> > >> >
> > >> > I have all of my database connection info in a file:
> > connection.php
> > >> > This info is stored in a folder: Connections
> > >> > Example of connection.php:
> > >> > <?php
> > >> > $connection =
> mssql_pconnect('SERVER','user','password') or die
> > >> ('server
> > >> > connection failed');
> > >> > $database = mssql_select_db("my_database", $connection)
> or die
> > ('DB
> > >> > selection failed');
> > >> > ?>
> > >> >
> > >> > I am trying to include the connection.php file in all
of my
> > pages so I
> > >> > don't
> > >> > have to hard code the info into every page.
> > >> > But, my data never returns because the include
> apparently is not
> > >> working.
> > >> > If I remove the include and hard code the info, it
works.
> > >> >
> > >> > Here is an example of the include statement I am using
> on my
> > pages.
> > >> >
> > >> > <?php include '../../Connections/connection.php'; ?>
> > >> >
> > >> > The Connections folder is two level above my form
> > page. Example file
> > >> > structure below.
> > >> >
> > >> > ROOT
> > >> > Connections
> > >> > connection.php
> > >> > Submit
> > >> > Current_Forms
> > >> > My_Form.php
> > >> >
> > >> > I've tried ../../../Connections/connection.php,
> > >> > ../../Connections/connection.php,
> > ../Connections/connection.php but
> > >> nothing
> > >> > works.
> > >> >
> > >> > Any ideas what I am doing wrong???
> > >> >
> > >> Set your error_reporting to E_ALL.
> > >> and set display_errors to On
> > >>
> > >> Then you should be able to see all the errors.
> > >>
> > >> Because, without the error messages, we are not going to
> be able
> > to help
> > >> you.
> > >>
> > >> Might I recommend to use include_once instead. This way,
it
> > will only
> > >> create one connection
> > >>
> > >> --
> > >> Jim Lucas
> > >>
> > >> "Some men are born to greatness, some achieve
greatness,
> > >> and some have greatness thrust upon them."
> > >>
> > >> Twelfth Night, Act II, Scene V
> > >> by William Shakespeare
> > >>
> > >>
> > >
> >
> >
>
>
