Totally Zenned
- Join Date:
- Feb 2008
- Posts:
- 1,386
- Plugin Contributions:
- 0
Added a new Mod to the Site and now it is not Functioning proberly
Hello
I added a mod that I had a guy develop for me which is based on Scripts. here is the link to take alook at: https://www.coolcarpartsonline.com
Now the mod function proberly in store front but In the admin panel when I add a new item (first item) under any categorie the Select Year will show up BUT if I go to add a second item under the same categorie (Or Sub-categorie) the Select year will not Show up. Iam assuming it is a condition in the script. Here is a link to the script that belong to that function in the Admin folder> <?php
$date = getDate();
$year = $date['year'];
$nextyear=$year+1;
?>
<tr bgcolor="#ebebff">
<td class="main"><?php echo "Year"; ?></td>
<td class="main">
<select name="yearname[]" rows="6" multiple><option value=''>--Select Year--</option>
<?php if(isset($_GET['pID'])) { $sqlyr=mysql_query("select distinct year_id from make_to_categories where products_id='".$_GET['pID']."' and year_id='".$nextyear."'"); if(mysql_num_rows($sqlyr)>0) { echo "<option value=\"$nextyear\"SELECTED>$nextyear</option>"; } else { echo "<option value=\"$nextyear\">$nextyear</option>"; } for($i=1;$i<=30;$i++) { $yr=$year; $sqlyrs=mysql_query("select distinct year_id from make_to_categories where products_id='".$_GET['pID']."' and year_id='".$yr."'"); if(mysql_num_rows($sqlyrs)>0) { echo "<option value=\"$yr\"SELECTED>$yr</option>"; } else { echo "<option value=\"$yr\">$yr</option>"; } $year=$yr-1; } } ?>
</select>
</td>
</tr>
<tr>
<td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
If any one of the developer can fix that issure please advise.