Jump to content

form question


bagnallc

Recommended Posts

I have a very basic form as below on page which when called displays stats

<form name="countrystats" action="countrystats.php" method="get">
<?php
include("hidden_fields_for_separate_forms.php");
?>
<input type="submit" value="Stats">
</form>

For this example it works fine and produces the stats as per the mysql query in the code below

<?php
require("connectmysql.php");
include("get_set_criteria.php");
$countryqry=mysql_query("SELECT country.country_name as countryname, count(all_details_inc_prev.race_no_id)
FROM country
JOIN tracks ON country.country_id=tracks.country_id
JOIN race_numbers ON tracks.track_id=race_numbers.track_id
JOIN all_details_inc_prev ON race_numbers.race_no_id=all_details_inc_prev.race_no_id
$nh_flat_aw_join
WHERE race_numbers.race_no_id > 0 $nh_flat_aw_where $datesettings $trackid
group by countryname;
");

if(mysql_num_rows($countryqry) > 0) {
echo "<table cellpadding=3 border=1 bgcolor=#66CCCC>";
echo "<tr align=center>";
echo "<th> </th> <th>Qualifiers</th>";
echo "</tr>";
while($row = mysql_fetch_row($countryqry)) {
echo "<tr align=center>";
echo "<td>".$row[0]."</td>";
echo "<td>".$row[1]."</td>";
echo "</tr>";
}
echo "</table>";
}
echo "<br/>";
if(!$countryqry) {
die ('<p> Can\'t use query :</p>' . mysql_error()); }

?>

What i want though is to alter the "countrystats" form and make it communal to many pages so that when called stats are produced for the relevant page. so if i could tell which page the stats form is being clicked i could have many mysql queries in the one statspage ready to produce depending on where the user came from
Link to comment
https://forums.phpfreaks.com/topic/12932-form-question/#findComment-49646
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.