Forums / Setting Up Categories, Products, Attributes / Added a new Mod to the Site and now it is not Functioning proberly

Added a new Mod to the Site and now it is not Functioning proberly

Locked

Views: 814

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
3 Aug 2008, 2:32 PM
#1
coolcarpartsonline avatar

coolcarpartsonline

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.