Search the Nissan Parts Catalog - Experimental
mysql_pconnect("vader", "partsuser", ""); $result = mysql("nissanparts", "select model_desc from models"); $rows = mysql_numrows($result); echo "
\n"; for ($i=0;$i<$rows;$i++) { if ($i == 0) { echo "
"; } else { echo "
"; } echo mysql_result($result, $i, "model_desc"); echo "\n"; } echo "
\n"; ?> Production date:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
$result = mysql("nissanparts", "select min(valid_start) as valid_start from models"); if (mysql_numrows($result) > 0) $start_year = substr(mysql_result($result, 0, "valid_start"), 0, 4); $result = mysql("nissanparts", "select max(valid_end) as valid_end from models"); if (mysql_numrows($result) > 0) $end_year = substr(mysql_result($result, 0, "valid_end"), 0, 4); echo "
\n"; for ($i=$start_year;$i <= $end_year;$i++) { if ($i == $start_year) { echo "
"; } else { echo "
"; } echo "$i\n"; } echo "
\n"; ?>
Part Number:
(
RegEx
)
Part Desc:
(
RegEx
)
Section:
Any $result = mysql_query("select subsection_fkey as K from applications group by K"); $sectionList = ""; while ($row = mysql_fetch_array($result)) { if (strlen($sectionList) == 0) { $sectionList = $row["K"]; } else { $sectionList = $sectionList.",".$row["K"]; } } $result = mysql_query("select subsection_key, sections.descrip as D1, subsections.descrip as D2 from sections,subsections where subsection_key in ( $sectionList ) and section_key = section_fkey order by sections.descrip, subsections.descrip"); while ($row = mysql_fetch_array($result)) { echo "
".$row["D1"]." - ".$row["D2"]." [".$row["subsection_key"]."]\n"; } ?>