still stuck with querie via form

Anon

Hi all, I'm still having a hard time trying to keep the values selected on the form after submiting the information using <? ECHO $PHP_SELF ?>. I used phpinfo() command on my code (thanks for the help -geoff) to see the variables available and the problems is that I don´t want to keep the value of each option of the form (its just a part number with no sense to the client). What I want is to keep displaying the option description (text) on the form so that the client can still see the options that generated the table's result. Does anybody know how can I accomplish this???? An example should be great :-).

            Once again, thanks in advice,
                  Alejandro Islas
                       Mexico

amcgrath

"An example should be great :-)...."

Right back atcha, can you give us the code to see what you are doing?

amcgrath

Author: Alejandro Islas (200.36.33.35)
Date: 2001-11-15 11:34:52

Hi Allen, here's part of my code

<FORM ACTION="<? ECHO $PHP_SELF ?>" METHOD="POST">
<table border=0>
<tr><th align=middle>Voltaje de alimentación</th>
<td><SELECT NAME=aliframer>
<OPTION>
<OPTION VALUE="EFR1IDCM-1000">-48 VDC
<OPTION VALUE="EFR1IACM-000">110/220 AC
</SELECT></td></tr>
<tr><th align=middle>Arnés</th>
<TD><SELECT NAME=arnframer>
<OPTION>
<OPTION VALUE="SARMPED25D2500">Arnés Kb Switch 1 (DB25 macho)
<OPTION VALUE="SARMPED25D2600">Arnés Kb Switch 2 (DB26 macho)
<OPTION VALUE="SARMPED25WNH00">Arnés DCE Winchester hembra
</SELECT></td></tr></TABLE><br><br>
<input type="submit" value="Continuar">
</FORM>

<?
IF(isset($aliframer) and isset($arnframer)) {
$base="catco";
mysql_connect();
$cadena="SELECT * from Catalogo"
." WHERE Componente LIKE '$aliframer'"
." OR Componente LIKE '$arnframer'";
mysql_select_db($base);
$Result=mysql_query($cadena);
$RowCount=mysql_num_rows($Result);
phpinfo();
ECHO "<P align=center>";
ECHO "<TABLE border=2 CELLSPACING=2>";
ECHO "<TR><TH>COMPONENTE</TH><TH>DESCRIPCIÓN</TH><TH>CANTIDAD</TH>";
$i = 0;
WHILE ( $i < $RowCount){
ECHO "<TR>";
ECHO "<TD>" . MYSQL_RESULT($Result,$i,"Componente") . "</TD>";
ECHO "<TD>" . MYSQL_RESULT($Result,$i,"Descripcion") . "</TD>";
ECHO "<TD>"."1"."</TD></TR>";
$i++;
} // end while
mysql_free_result($Result);
ECHO "</table></P>";
} //acaba isset
?>

sorry for the words in Spanish :-), thanks again

amcgrath

Try this version instead:
<?

$aliframer_list = array(
"EFR1IDCM-1000" => "-48 VDC",
"EFR1IACM-000" => "110/220 AC");

$arnframer_list = array(
"SARMPED25D2500" => "Arnés Kb Switch 1 (DB25 macho)",
"SARMPED25D2600" => "Arnés Kb Switch 2 (DB26 macho)",
"SARMPED25WNH00" => "Arnés DCE Winchester hembra");

<FORM ACTION="<? ECHO $PHP_SELF ?>" METHOD="POST">
<table border=0>
<tr><th align=middle>Voltaje de alimentación</th>
<td><SELECT NAME=aliframer>
<OPTION>
<? while (list($k,$v) = @each($aliframer_list)) { ?>
<? $sel = ($aliframer == $k ? "SELECTED" : "") ?>
<option <?= $sel ?> value="<?= $k ?>"><?= $v ?>
<? } ?>

</SELECT></td></tr>
<tr><th align=middle>Arnés</th>
<TD><SELECT NAME=arnframer>
<OPTION>
<? while (list($k,$v) = @each($arnframer_list)) { ?>
<? $sel = ($arnframer == $k ? "SELECTED" : "") ?>
<option <?= $sel ?> value="<?= $k ?>"><?= $v ?>
<? } ?>
</SELECT></td></tr></TABLE>
<input type="submit" value="Continuar">
</FORM>

<?
if(isset($aliframer) && isset($arnframer)) {
$base="catco";
mysql_connect();
$cadena="SELECT * from Catalogo"
." WHERE Componente LIKE '$aliframer'"
." OR Componente LIKE '$arnframer'";
mysql_select_db($base);
$Result=mysql_query($cadena);
$R....

Anon

thanks for your help allen..be sure I'll stay on my original thread next time :-)

                          Alejandro

amcgrath

Well, did it work or not?

Anon

it works fine the only problem is that the first time you enter the page marks a warning
Undefine variable: aliframer on line 21
Undefine variable:arnframer on line 30
After that it works great...

Another thing, when I run it the first time it marked a parse error on line 15. I solve it putting a ?> before declaring the form tag.

Anon

is there a command to disable warnings on php????????

amcgrath

yea, u can set error message levels http://www.php.net/manual/en/features.error-handling.php, or you can just check to see if these vars are not set, if not set them to blank....

Anon

ok, thanks a lot again, bye