Two Submit Buttons > One page

[cheyner11]

I need some help putting two seperate submit values on one page.

I am building a chart program, that selects symbols from different exchanges and puts them into "exchange specific catagories" in the form of drop-down boxes.

This is done using PHP and mySQL. I have everything set up, and working when dealing with only one variable (ex. Toronto exchange). When I add a second field (NYSE) and another submit button, all this data is screwed up.

Relevant info:

I am posting variable ($tsx) to my chart template "analysis.php".
This works great when only one drop down box is in place. How do I distinguish that there will be seperate forms, and only one submit button is used for one seperate drop down box.

Your help is appreciated.

Is this even possible?????

[dalecosp]

Sure it's possible.

But, I'm having a little trouble grokking your issue from what you've posted.

You can have two forms on one HTML page; you can have two submit buttons on one HTML form. You could even have two submit buttons on each of two HTML forms on one page.

The common way of handling two submit buttons that submit to the same handler script is to check the value of each submit.

if ($_POST['submit']=="Check Toronto stocks") {
   do_Toronto();
} elseif ($_POST['submit']=="Check NYSE stocks") {
   do_NYSE();
} else {
   die("How'd you get here, anyway?");
}

Now, all that said, I'm not really sure I'm answering what you are asking...

What it sounds like you are really saying is that you are using the same variable ($tsx) to represent the data in two different drop boxes. That would cause problems. Rewrite the form (and the handler script "analysis.php" if necessary) so that this doesn't happen that way.

Now, if I'm wrong (and I usually am) ... could you either clarify the issue or post the code so we can actually see the problem?

🙂

[cheyner11]

Yes I am using $tsx for both the variables. I am pretty new to PHP so I thought that because only one item is ultimatly selected then I could get away with using one variable.

How could I could this so that my 'template' analysis.php can process the info......

Currently my code for chartroom.php is:

@ $db = mysql_pconnect('localhost', '', '');

if (!$db)

{

$message_new = 'Error: Could not connect to database. Please try again.';
include("add_company.php");
exit();

}

mysql_select_db('johnt_core')
or die ("Could not select database");

$query = "SELECT symbol, company FROM companies WHERE exchange='toronto'";

$result = mysql_query($query)
or die ("Could not select Toronto.");

<form action="analysis.php" method="post">
<select name="tsx"><option selected value="default">-- Our Picks --</option>

//*******Code for Drop Down*******//

<?php

while ($row = mysql_fetch_array($result))

{

extract($row);
echo "<option value='$symbol'>$company";

}

?></select>

Now how would I change all this to include to list-boxes. Thanks for your help.......

Here is the code form analysis.php if it helps:

$query = "SELECT * FROM companies WHERE symbol='$tsx'";

$result = mysql_query($query)
or die ("Could not execute query");

while ($row = mysql_fetch_array($result))

{

extract($row);

}

Your Help is greatly appreciated...

[dalecosp]

I would expect that if you have two list boxes, both with "tsx" as the name, you would have issues similar to those you described above.

If you select something on the first, but not the second, then I'd expect that you'd get a null value when passed to the handler, because the most recent value (Null in this case) would be the one that gets passed.

Anyway, the question now is, "how do I make two selects ('list-boxes')?"

Not a problem; just copy the code for the first one into the script again, change the select name to "tsx2", change the SQL stuff to reflect New York or wherever, and post the form.

Then, in analysis.php, something like this I'm thinking ...

if ($_POST['tsx2']!='') {  // double check this
//when you run it

   $tsx=$_POST['tsx2'];
} else {

   $tsx=$_POST['tsx'];
}

and then do the rest of the work once you've decided whether they were looking for a Toronto or NYC stock....

[cheyner11]

Analysis.php ----------->

mysql_select_db('johnt_core');

$query = "SELECT * FROM companies WHERE symbol='$tsx'";

$result = mysql_query($query)
or die ("Could not execute query");

while ($row = mysql_fetch_array($result))

mysql_select_db('johnt_core');

$query = "SELECT * FROM companies WHERE symbol='$tsx2'";

$result = mysql_query($queries)
or die ("Could not execute query");

while ($now = mysql_fetch_array($desult))

if($tsx)

{

extract($row);

}

if($tsx2)

{

extract($now);

}

CHART ROOM ----------->

mysql_select_db('johnt_core')
or die ("Could not select database");

$query = "SELECT symbol, company FROM companies WHERE exchange='toronto'";

$result = mysql_query($query)
or die ("Could not select Toronto.");

mysql_select_db('johnt_core')
or die ("Could not select database");

$queries = "SELECT symbol, company FROM companies WHERE exchange='NYSE'";

$desult = mysql_query($queries)
or die ("Could not select Toronto.");

<form action="analysis.php" method="post">
<select name="tsx"><option selected value="default">-- Our Picks --</option>

<?php

while ($row = mysql_fetch_array($result))

{

extract($row);
echo "<option value='$symbol'>$company";

}

?></select><input type="image" SRC="submit.jpg" value="tsx"></td></form>

<form action="analysis.php" method="post">
<select name="tsx2"><option selected value="default">-- Our Picks --</option>

<?php

while ($now = mysql_fetch_array($desult))

{

extract($now);
echo "<option value='$symbol'>$company";

}

?></select><input type="image" SRC="submit.jpg" value="tsx2"></td></form>

I am trying this now and only ONE submit button is actually working, and when I submit the first value it says 'Could not execute query'.

Thanks again for all your help.