Return-Path: 
 <users-return-7340-apmail-httpd-users-archive=httpd.apache.org@httpd.apache.org>
Delivered-To: apmail-httpd-users-archive@httpd.apache.org
Received: (qmail 60706 invoked by uid 500); 17 May 2002 23:25:56 -0000
Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
list-help: <mailto:users-help@httpd.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@httpd.apache.org>
list-post: <mailto:users@httpd.apache.org>
Delivered-To: mailing list users@httpd.apache.org
Received: (qmail 60695 invoked from network); 17 May 2002 23:25:56 -0000
Received: from unknown (HELO box.imptech.net) (66.250.21.181)
  by daedalus.apache.org with SMTP; 17 May 2002 23:25:56 -0000
Received: from succubus (c-24-130-128-84.we.client2.attbi.com [24.130.128.84])
	by box.imptech.net (8.11.6/8.11.6) with SMTP id g4HNOfv05560
	for <users@httpd.apache.org>; Fri, 17 May 2002 16:24:41 -0700 (PDT)
	(envelope-from rune@imptech.net)
Message-ID: <014b01c1fdfa$38fe3640$6401a8c0@succubus>
From: "RuneImp" <rune@imptech.net>
To: <users@httpd.apache.org>
References: <F9E3D1712F58D411B70D00508BDF897F03DA2F6B@msgdal07.sbc.com>
Subject: Re: PHP 4.2.1 / Apache 1.3.24...
Date: Fri, 17 May 2002 16:23:36 -0700
Organization: ImpTech
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
x-mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

This is a PHP issue. Look up session variables and/or
add the name of the variable & it's value to the URL
(GET header).


-=- RuneImp
ImpTech - Web Design, Hosting & Computer Tech
http://imptech.net
rune@imptech.net


----- Original Message ----- 
From: "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com>
To: <users@httpd.apache.org>
Sent: Friday, May 17, 2002 12:18 PM
Subject: PHP 4.2.1 / Apache 1.3.24...


I have a question about passing variables between web pages...  I am
running Apache 1.3.24 with PHP 4.2.1 and FrontPage 2002 Server Extensions.
My problem is that I have a web page that provides a list of systems
generated dynamically from a database.  The user selects a system, and then
is forwarded to another page that displays the results of the query based on
the name of the system that the user has selected.  The system list is
working fine, but when I "Submit" to display the results of the query, the
query results page is missing the result data.
The troubleshooting that I have done led me to discover that the
variable that holds the selected system name is apparently not being passed
correctly.  I determined this because if I replace the variable name on the
results page with a valid system name, I get the expected output.  I am not
sure if this problem is with Apache, FrontPage, PHP, or some combination of
these three.  Any help is appreciated.  Thanks in advance.
Below is the relevant section of both the query page, and the
results page:

Query:

        <p align="left"><span lang="en-us">Please select system:&nbsp;
</span></p>
      
        <?php
        mysql_pconnect("localhost","auto");
        mysql_select_db("LD_Systems");
        $results = mysql_query("SELECT Name FROM systems");
        $dropdown = "<select size=\"1\" name=\"system\">\n";
          while($name = mysql_fetch_row($results)) {
            $dropdown .= "<option>$name[0]</option>\n";
          }
          $dropdown .= "</select>\n";
        ?>
      <form method="POST" action="db_query.htm">
        <?php echo "$dropdown"; ?>

Results:

<h3 align="center">Results Of Your Query</h3>

<?php
  trim($system);
  $link = mysql_connect("localhost","auto");
  mysql_select_db("LD_Systems");
  $results = mysql_query("SELECT * FROM systems WHERE Name = '$system'");
  $data = mysql_fetch_assoc($results);
  printf ("Name:  %s <br>\n", $data["Name"]);
  echo ("<font color=\h3>"."System:  ".$data["Name"]."  IP Address:
".$data["IP"]."  Primary SA:  ".$data["SA"]."<br>"."");
?> </font></body></html>

Thanks again.

Scott Nipp
Phone:  (214) 858-1289
E-mail:  sn4265@sbc.com
Web:  http:\\ldsa.sbcld.sbc.com



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org