So far so good. Now it seems as if the php file is working (ie no errors), but the page goes white and the URL is ...xcart/mmy.php It's like its loading a new page rather than just running the php and returning results. Here's what I have going now.
tpl
Code:
{capture name=menu}
<form method="post" action="mmy.php" name="mmysearchform">
<select name="year2" style="width: 80%;"onchange="javascript:document.mmysearchform.submit ();">
<option value="" selected="selected">Select Year</option>
<option value="2009">2009
<option value="2008">2008
<option value="2007">2007
<option value="2006">2006
<option value="2005">2005
<option value="2004">2004
</select><br>
<select name="make" style="width: 80%;"onchange="javascript:document.mmysearchform.submit ();">
<option value="" selected="selected">Select Make</option>
</select><br>
<select name="model" style="width: 80%;"onchange="javascript:document.mmysearchform.submit ();">
<option value="" selected="selected">Select Model</option>
</select>
</form>
<font class="CategoriesList"><a href="home.php?cat=" class="VertMenuItems"></a></font><br />
<font class="CategoriesList"><a href="home.php?cat=" class="VertMenuItems"></a></font><br />
{/capture}
{ include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title=$lng.lbl_mmy_search menu_content=$smarty.capture.menu cellpadding=$fc_cellpadding}
php
Code:
<?php
require "./auth.php";
$year = $_POST['year2'];
///////////////////////////////////////////////// make query for dropdown
$query = sprintf("SELECT DISTINCT makeid, makename FROM iemmy WHERE yearid='$year'");
$result = @mysql_query($query);
$rowMake = mysql_fetch_array($result);
/////////////////////////////////////////////////
if (mysql_num_rows ($result) >= 1)
{
$makeid = array();
while ($rows = mysql_fetch_array ($result, MYSQL_ASSOC)) array_push ($makeid, $rows);
$smarty->assign ("makeid", $makeid);
}
?>
What I am ultimately trying to do is to pass this query back to the form in my tpl file and populate the second dropdown box with the results. I tried adding a foreach loop to the tpl file to see the array, but the browser screen still went white.
I'm extremely grateful for your help. Thanks again.
Adam