|
$Row[Year] Series Trucks - $Row[Sections_Desc]
![](\"Images/$Row[Photo]\")
$Row[Year] $Row[Name] ");
if($Row[Section]==2) print ("(This is vehicle number $Row[Series_Order] in the miniature collection) ");
print ("$Row[Description]
Model Information:
");
if($Row[Price]>0) print("Cost: $Row[Price]
");
if($Row[Limit]>0) print("Limit: $Row[Limit] per customer
");
print("Available: $mydate
");
if($DisplayYear){
print("To Purchase (if available):Jack Thyen's Sales Page
");
}
else{
print("To Purchase:Jack Thyen's Sales Page
");
}
print("Official Hess Link: http://www.hesstoytruck.com/
|
");
}
// Create a bit of space
if($DisplayYear)
$DisplayMsg = "Currently Displaying $DisplayYear";
else
$DisplayMsg = "Currently Displaying $CurrentYear";
if($DisplayYear<>1964){
print("| < Previous Year | $DisplayMsg | ");
}
else{
print(" | | < Previous Year | $DisplayMsg | ");
}
if($DisplayYear && $DisplayYear<>date("Y")){
print ("Next Year > |
| ");
}
else{
print ("Next Year >
|
");
}
print("| |
\n");
// Create query to display older trucks
// First, get list of series and move through them
$Section_Query = "SELECT * from Sections ORDER BY Section_Order";
$Section_Result = mysql_db_query($DBName,$Section_Query,$Link);
while($Section_Row = mysql_fetch_array($Section_Result)){
print("
");
$Query = "SELECT *,YEAR(`Date_Avail`) as YearN,DAYOFMONTH(`Date_Avail`) as DayN,Month(`Date_Avail`) as MonthN,MONTHNAME(`Date_Avail`) as MonthName from $TableName WHERE Section LIKE $Section_Row[UID] ORDER BY Series_Order";
$Result = mysql_db_query($DBName,$Query,$Link);
// Display Results
while($Row = mysql_fetch_array($Result)){
$timestamp = strtotime($Row[Date_Avail]);
if($Row[DayN]=="0"){
if($Row[MonthN]=="0"){
$mydate = $Row[YearN];
}
else{
$mydate = "$Row[MonthName] $Row[YearN]";
}
}
else{
$mydate = date("F d, Y",$timestamp);
}
print("
|
$Row[Year] $Row[Name]: $Row[Description]
");
if($Row[Price]>0) print("Original Cost: $Row[Price]
");
if($Row[Limit]>0) print("Original Limit: $Row[Limit] per customer
");
print("Originally Available: $mydate
|
");
}
print(" |
");
}
// Close connection to database
mysql_close($Link);
print("
These vehicles are not for sale. I am just showing them off. If you want to buy toy trucks,
or are looking for more detailed information, check out these links:
- Jack Thyen's Sales Page
(http://www.hesstrucks.net/)
- American Toys
- G & S Exchange
- Felix's Toy Truck Collection
|
");
require("../footer.php");
?>