//set colour change for each row $rowcolour=1; //set font size $fontsize="font face='arial' size='1'"; // Include the header file include ("../../include/header.php"); // get data connection require("../../include/sqlcon.php"); $sql = new MySQL_class; $sql->Create("triumphstag_db"); $sql1 = new MySQL_class; $sql1->Create("triumphstag_db"); $time =time(); $date1=(time() - 2592000); If ($order =='updated desc') { $listby ='Date of last update';} If ($order =='commnumber') { $listby ='Commission number';} If ($order =='stolen desc') { $listby ='Starting with Stolen Stags';} If ($order =='forsale desc') { $listby ='Starting with Stags for sale';} If ($order =='paintcode') { $listby ='Colour';} If ($order =='etype desc') { $listby ='Engine type';} If ($order =='name') { $listby ='Owners name';} If ($order =='homepage desc') { $listby ='Starting with entries with Homepages';} If ($order =='country') { $listby ='Country Order';} If ($order =='state') { $listby ='Location Order';} echo("
" " | Commission | Colour | Engine Type | Owner | Homepage | Country | Location | $icon | "); echo("<$fontsize $fontcolour>$cnumfull | "); echo("<$fontsize$>$paint | <$fontsize>$eng1 | <$fontsize>$name1 | $homepage1 | "); echo("<$fontsize>$cname | <$fontsize>$state | $stagpic1 | \n"); } echo("
---|