Drop-down selection help

Kris78424

On my form, I have a drop-down that's populated based on a query result and a submit button for whichever option from the drop-down is selected:

echo "<form method='post' action='myform.php'>";
echo "<h3>Select One:";
echo "<input type='hidden' name='action' value='searching' />";
echo "<select name='choice[]'>";
echo "<option value=''> Your Choices </option>";
while ($row1 = mssql_fetch_row($result1)) {
if($i == 0)
echo "<option value='choice'> $row1[0] </option>";
$i++;
$i=0;
}
echo "</select> <input type='submit' name='display' value='Display' /><br><br>";
echo "</h3></form>";

I have about 35 queries that make up a table on the initial page. The drop-down choices will populate the table with another 35 queries that need to have variables (I assume) to calculate different numbers for the table, based on the selection made.
////////////////////////////////////////////////////////////////////////////////////////////////////////

This is kind of confusing. Let me try to give examples:

---My initial page will display the results of 35 queries ---

"select count(figure) from table where initial=1"
"select count(figure) from table where initial=2"
"select count(figure) from table where initial=3"

....and so on....

--Any selection from the drop-down (which is an array of 1 query) will display the result of--

"select count(figure) from table where initial=1 and factor=0"
"select count(figure) from table where initial=2 and factor=0"
"select count(figure) from table where initial=3 and factor=0"

....All of those queries will need to have something appended to them to signify what 'count' it's displying based on the choice that was made in the drop-down....

I'm guessing the queries may need to have something added to them that says something to the affect of: "and chosen=$choice"

And, then, how do I tell the form to display the chosen data when the submit button is clicked?

///////////////////////////////////////////////////////////////////////////////////////////////////////

Oh yeah, each row of the table looks like this:

$row101 = mssql_fetch_array($result101);
echo "<tr><td>row name1</td><td>row definition1</td><td>" . number_format($row101[0]) . "</td></tr>";

$row102 = mssql_fetch_array($result102);
echo "<tr><td>row name2</td><td>row definition2</td><td>" . number_format($row102[0]) . "</td></tr>";

$row103 = mssql_fetch_array($result103);
echo "<tr><td>row name3</td><td>row definition3</td><td>" . number_format($row103[0]) . "</td></tr>";

....and so on.....

Any help would be greatly appreciated!!!!! :-))

leatherback

... Hold it.. Stop right there!

Some 35 queries/ You must be doing something very inefficiently there.

Why not something like:

select count(figure) from table where initial<35 group by initial

I think it is important to first understand what you are doing and why you have 35 queries, before getting into the nitty gritty (Which would indeed be something like:
$selected = mysql_real_escape_string($_POST['selected'];
select count(figure) from table where initial=1 and selected = $selected )

Kris78424

(Sorry for the double post. I didn't know which sub-forum to post it in.)

I wanted to do something like that, but the "initial" value is not as cut & dry as 1-35 in order. I was just using that for the example. The values are very random, different, and longer strings of letters & numbers mixed. I tried many others ways to try to combine this, but there's no rythm to what I need to pull. It's just random crap. LOL

So, I think 'nitty-gritty' is, unfortunately, the only way to go about this. :-((

Kris78424

Also, don't know if this matters much with this, but it's using "mssql".

leatherback

Well.. Even then..

I do not know how you determine which records to pull. But at some point you know which queries to run. So you could use a structure like this:

select * from .. where field in (..., ..., ..., ... )

really, hardly ever is there a need to run more than a handfull of queries for an individual page. If you do, then more often than not, you should re-structure the database, the page-code etc.

The data which is posted from the form will be in the $_POST data array; At the top of your processing script you could place something like:

echo "<pre>";
print_r($_POST);
echo "</pre>";

to see exactly what was submitted. You can then adjust your query like:

if(isset($_POST['FormFieldName']))
  {
  // Cretae the query here
  }