PHP - Php Echo Table Dependent On Drop Down Box's On Same Page

I have a table in a database that I need to filter upon using dependent select boxes.  The database was poorly designed and would be difficult to break into separate tables without affecting code written in other places.  I have found some good code and understanding of how to implement the dependent select boxes if you have two tables with one column functioning as a lookup value between the two.

I have provided a short bit of sql of what the table looks like with some column names changed.  I would need to first sort by lastname and have firstname dependent on the selection of lastname.  Any help would be greatly appreciated.

Code: [Select]
create table `user` (
`id` int(3) Not Null Auto_increment,
`firstname` varchar (60),
`lastname` varchar (24),
`age` double ,
`hometown` varchar (75),
`job` varchar (75),
`birthdate` date
);
insert into `user` (`id`, `firstname`, `lastname`, `age`, `hometown`, `job`, `birthdate`) values
('1','Peter','Griffin','41','Quahog','Brewery','1960-01-01'),
('2','Lois','Griffin','40','Newport','Piano Teacher','1961-08-11'),
('3','Joseph','Swanson','39','Quahog','Police Officer','1962-07-23'),
('4','Glenn','Quagmire','41','Quahog','Pilot','1960-02-28'),
('5','Megan','Griffin','16','Quahog','Student','1984-04-24'),
('6','Stewie','Griffin','2','Quahog','Dictator','2008-03-03');

I am trying to write some data from multiple SQL tables to a page. In the first table is a list of places. I then have more tables that are named after the different places. For example, say my first place in the list is called Place1. I have a table named Place1 with data that corresponds to place1. The data contained in the table named Place1 is a list of things to do in this place. It has 21 columns and each one is something to do in the morning, afternoon, and at night for each day of the week in the place Place1. What I am trying to do is display a sort of weekly calendar as a table on a webpage that lists all of the places in one column and then lists seven days of the week as 7 more columns. Then in each data cell I would want to list the things to do in the morning, afternoon and at night for the certain day of the week and for the place. The problem is that I am creating a CMS to allow other users with no coding knowledge to update events for other places, so I have to display data that could have been altered.

The only solution I know of is to do a while loop that gets all of the place names and while there are still place names, write the place names to the page and set a variable equal to the place name. Inside the while loop I would create another while loop that each time the first while loop is executed uses the variable set in the first while loop to know which table to reference and then make a call to that table pulling out the 21 columns and writing them to the page. Each time the outer while loop executes, it would (hopefully) write the place name, and then set the variable as the current place name so that the inner while loop uses the variable to write the rest of the information about that place.

I don't know if that would even work and if it did, I know it cannot be the best way to do this. I am pretty stuck here and don't really have a good solution so if anyone proposes a solution that is radically different to anything I have done, I am open to everything. Thank you!

Need some help to define the php logic to echo back a selection if/when chosen from the drop down menu.
Note: I'm using just a small subset of the USA states to show setup and what I'm trying to accomplish - it will be the same for all the other drop down menus as well....

Here's the example code:

Code: [Select]

<form name="form1" method="post" action="<?php $_SERVER[PHP_SELF]; ?>">
<select name="address_state" id="address_state" tabindex="25">
<option value="" selected> - Select State -</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DC">District of Columbia</option>
</select>

<input name="submit" type="submit" value="submit" tabindex="900" id="submit" />
</form>

Issue: I have validation (logic) define to check all the (other) text, radio, and check boxes of the form and that all works great! However, any time one of those particular fields fail validation, any selected "drop down" item is lost - it defaults back to no selection and the user has to make all drop down menu selections again.

Can someone provide method to echo back - in php being the page reloads to itself - the drop down selection as in the example above?
Thanks!

Hi

I have written the below code to echo a table

Code: [Select]
<table>
              <?php
  //start top 10 loop
$sql=mysql_query("SELECT * FROM Games ORDER BY up DESC LIMIT 10");
while($row=mysql_fetch_array($sql))
{
$title=$row['gametitle'];
$gameid=$row['gameid'];
$up=$row['up'];
?>

                <tr><td><a href="Reviews.php?gameid=<?php echo $gameid ?>"><?php echo $title ?></a>
                <td align="right"><?php echo $up ?></td>
               
                </tr>
                <?php
//end top 10 loop
}
?>
</table>
I want to add a new column to the table that lists them as 1 through to ten.

Can anybody advise the best way to do this?

Thanks

for some reason it will not render to the row... ive added the php echo to the row in question and it runs with the top row... can someone take a look and let me know what i am doing wrong...

thanks
trey

here is the code... the php echo in bold red should show up on the next row; but, it doesnt...

<?php
/**
* @version $Id: mod_gridiron_game_results.php, v1.5.0 March 2011 01:32:15
* @author Fastball Productions
* @package Gridiron
* @copyright Copyright (C) 2011 Fastball Productions
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();

// get the module parameters
$heading = $params->get( 'heading', '' );
$showpast = $params->get( 'showpast', '1' );
$numberpast = $params->get( 'numberpast', '1' );
$linkboxscore = $params->get( 'linkboxscore', '1' );
$shownextgame = $params->get( 'nextgame', '1' );
$numbernext = $params->get( 'numbernext', '1' );
$linknext = $params->get( 'linknext', '1' );
$seasonid = $params->get( 'seasonid', '1' );
$gametypes = $params->get( 'gametypes', '1' );
$teamids = $params->get( 'teamids', '' );
$leagueids = $params->get( 'leagueids', '' );
$divisionids = $params->get( 'divisionids', '' );

if (is_array($gametypes)) {
   $gametypes = implode(',', $gametypes);
}
if (is_array($teamids)) {
   $teamids = implode(',', $teamids);
}
if (is_array($leagueids)) {
   $leagueids = implode(',', $leagueids);
}
if (is_array($divisionids)) {
   $divisionids = implode(',', $divisionids);
}

// if there is a league configured, get the teams within the league/division;
if ($teamids == '' && ($divisionids || $leagueids)) {
   if ($divisionids) {
      // get a listing of all team ID's that belong in the league and division;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(divisionid, '$divisionids'))";
   }
   else {
      // get a listing of all team ID's that belong in the league;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(leagueid, '$leagueids'))";
   }
   $db->setQuery($sql);
   $rows = $db->loadResultArray();
   $teamids = implode(',', $rows);
}
else if ($teamids == '') {
   // get the default team (single team component only);
   $db->setQuery("SELECT id FROM #__gridiron_team WHERE (defaultteam = 1)");
   $teamids = $db->loadResult();
}

// get the last x number of games played and the results;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   b.finalv, b.finalh
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_boxscore AS b ON a.id = b.gameid
   WHERE (a.scored = 1 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND a.gamedatetime < now())
   GROUP BY a.id
   ORDER BY a.gamedatetime DESC LIMIT 0, {$numberpast}");
$pastgames = $db->loadObjectList();

// get the next x number of games scheduled;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   t.description AS gametype
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_gametype AS t ON a.gametype = t.id
   LEFT JOIN #__gridiron_location AS l ON a.location = l.id
   WHERE (a.scored = 0 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND DATE_ADD(a.gamedatetime, INTERVAL 3 HOUR) > now())
   GROUP BY a.id
   ORDER BY a.gamedatetime ASC LIMIT 0, {$numbernext}");
$nextgames = $db->loadObjectList();
?>
<table width="100%" border="0" align="center">
   <?php if ($showpast && $numberpast > 0) { ?>
   <tr>
      <td colspan="2" style="text-align:center;"><b><?php echo $heading;?></b></td>
   </tr>
   <tr>
      <td width="43%"><b><u>Matchup</u></b></td>
      <td width="57%" style="text-align:center;"><b><u>Result</u></b></td>
   </tr>
   <?php foreach ($pastgames as $past) { ?>
   <tr>
      <td>
         <?php echo $past->visitingteam;?> vs.<br /><?php echo $past->hometeam;?>
      </td>
      <td style="text-align:center;">
      <?php if ($linkboxscore) { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=boxscore&id=$past->id");?>"><?php echo $past->finalv;?><br /><?php echo $past->finalh;?></a>
      <?php } else { ?>
      <?php echo $past->finalv;?><br /><?php echo $past->finalh;?>
        </td>
      <?php } ?>
   </tr>
   <tr>
      <td colspan="2"></td>
   </tr>
   <?php } ?>
   <?php } ?>
   <?php if ($shownextgame && $numbernext > 0 && $nextgames) { ?>
   <tr>
      <td colspan="2"><b><u>Next Game</u></b></td>
       
   </tr>
   <?php foreach ($nextgames as $next) { ?>
   <?php $next->visitingteam == '' ? $next->visitingteam = 'TBA':$next->visitingteam = $next->visitingteam;?>
   <?php $next->hometeam == '' ? $next->hometeam = 'TBA':$next->hometeam = $next->hometeam;?>
   <tr>
      <td colspan="2">
      <?php if ($linknext) { ?>
      <?php if ($next->visitingteam == 'TBA') { ?>
      <?php echo $next->visitingteam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->visitingteamid");?>"><?php echo $next->visitingteam;?></a>
      <?php } ?>
       vs.
      <?php if ($next->hometeam == 'TBA') { ?>
      <?php echo $next->hometeam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->hometeamid");?>"><?php echo $next->hometeam;?></a>
      <?php } ?>
      <?php } else { ?>
      <?php echo $next->visitingteam;?> vs. <?php echo $next->hometeam;?>   
      </td>
   </tr>
   <tr>
     <td colspan="2"><?php } ?><?php echo $next->gamedate . ' ' . $next->gametime;?> </td> 
  </tr>
   <?php } ?>     
   <?php } ?>   
</table>