Cant Get Data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have a 3 step form that calls the data from a mysql DB.  First is a 
dropdown to select a state, which then brings up a dynamically created check 
list of the counties in that state, so far all works well.  I am unable to 
get the checkbox choices to appear on the third page.

If someone could take a look at this and tell me where I am going wrong.

This is the code for the page that creates the checkboxes.  There are some 
extra lines in there where I was trying to get it to work. Again this works 
fine, but my guess is that see this may shed light.

   <?php
   $county1=$_SESSION['county$i'];
$counties=$_SESSION['counties'];
$row_name=$_SESSION['name'] = $row[name];
$count_choice=$_SESSION['name'];
$result1=$_SESSION['$result'];
$choice=$_POST['state'];
if ( isset($_POST['submit']) ) { // if form is submitted, process it

for($i=1; $i<=$_POST['counties']; $i++) {
if ( isset($_POST["county$i"] ) ) {
print $_POST["county$i"]." is checked.<br/>";
}
}

} else { // if form isn't submitted, output the form
$county_choice=$_SESSION['county$1'];
print "<form action=\"phpForm3.php\" method=\"POST\">\n";

/*$link = mysql_connect("", "", "");
mysql_select_db("");*/
$result = mysql_query("SELECT * FROM `counties` WHERE state_id = '$choice'") 
or die(mysql_error());

if ($result) {
print "<table width=200 border=1>\n";

print "<th>&nbsp; </th>\n";
print "<th> State </th>\n"; //2 fields in Counties table, State and County
print "<th> County </th>\n";

print "</tr>\n";
//create table
$i = 0;
while ( $row = mysql_fetch_array($result) ) {
$i++;
print "<tr>\n";

print "<td><input type=\"checkbox\" name=\"county$i\" 
value=\"$row[name]\"></td>\n";

echo "<td>{$row['state_id']}</td>\n";

echo "<td>{$row['name']}</td>\n";

echo "</tr>\n";

}//end while
print "</table>\n";
} else {
echo("<P>Error performing query: " .
mysql_error() . "</P>");

}
print "<input type=\"hidden\" name=\"counties\" value=\"$i\"/>\n";
print "<input type=\"submit\" name=\"submit\" value=\"Go\"/>\n";
}


This is the page that I am unable to get to call the checkbox selections

<?php
$count_choice1=$_SESSION['county$i'];
$count_choice2=$POST['counties'];
$count_choice3=$_POST['name'];
$result1=$_SESSION['$result'];
/*$count_choice=$_SESSION['name'];  */
$count_choice=$_POST['county$i'];
$choice=$_SESSION['name'];
$_POST["county$i"];


$result = mysql_query("SELECT * FROM `counties` WHERE name = '$choice'") or 
die(mysql_error());
/*$query  = mysql_query("SELECT * FROM counties ");
$result = mysql_query($query) or die ("Error in query: $query. 
".mysql_error());;
 echo $row['name'];
 echo "$query";*/
while($row = mysql_fetch_array($result))
{
    echo $row['name'];
         /*"{$row['name']}<br>" ;*/


}
echo "$choice";
/*echo $_SESSION['county$i'];
echo $_SESSION['counties'];
echo $_SESSION['name'];
echo "$count_choice";
echo "$row['name']";
echo "$county$1";
echo "$counties";
echo "$row_name"; */
?>
-- 

Any Suggestions?

Thank you.


Gary 



__________ Information from ESET Smart Security, version of virus signature database 5893 (20110221) __________

The message was checked by ESET Smart Security.

http://www.eset.com





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux