Listing Stags that match the selected criteria from the International Online Triumph Stag Registry at TriumphStag.net

\n"); //set table headings echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $sql->Query("Select commnumber, paintcode, concat(eprefix, enumber, esufix) as 'engine', name, email, emailpvt, homepage, country, state,newpaint, stolen, forsale,stagpic from stagdata where status <> 'deleted' and $item ='$data' $query order by $order"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $commnumber = $sql->data[0]; $paintcode = $sql->data[1]; $engine = $sql->data[2]; $name = $sql->data[3]; $email = $sql->data[4]; $emailpvt = $sql->data[5]; $homepage = $sql->data[6]; $country = $sql->data[7]; $state = $sql->data[8]; $newpaint = $sql->data[9]; $stolen=$sql->data[10]; $forsale=$sql->data[11]; $stagpic=$sql->data[12]; // Single selects to get paint description, full country name the full Commision number,engnum & type $colour = $sql1->QueryItem("select description from stagdatatrimpaint where code = '$paintcode'"); $cnumfull = $sql1->QueryItem("select concat(comprefix, commnumber, comsufix) from stagdata where commnumber = $commnumber"); $engnum = $sql1->QueryItem("select enumber from stagdata where commnumber = $commnumber"); $engtype = $sql1->QueryItem("select etype from stagdata where commnumber = $commnumber"); $cname = $sql1->QueryItem("select countryname from stagdatacountry where countrycode = '$country'"); //***********change font colour for stolen and for sale stags******** // //$fontcolour ="color='#333333'"; // //if ("Yes" == $forsale) { // $fontcolour ="color='#0000FF'"; // //} // //if ("Yes" == $stolen) { // $fontcolour ="color='#FF0000'"; // //} //**************Set special colours for stolen new in 30 days and for sale in list.************************************* //set "new or updated" icon at front of table for new entries. if ($datestamp > $date1 AND $datestamp == $updated) { $icon =""; }else{ if ($updated > $date1 and $updated <> $datestamp) { $icon =""; }else{ $icon =""; } } $fontcolour ="color='#333333'"; if ($updated > $date1) { $fontcolour ="color='#800080'"; } if ($datestamp > $date1) { $fontcolour ="color='#800080'"; } if ("Yes" == $forsale) { $fontcolour ="color='#0000FF'"; $icon =""; } if ("Yes" == $stolen) { $fontcolour ="color='#FF0000'"; $icon =""; } if (""==$stagpic){ $stagpic1=" "; }else{ $stagpic1=" "; // $stagpic1=urlencode($stagpic1); } //*******************************************************8 //test if there is text in the homepage field, if yes then the feild is hyperlinked if ( $homepage == NULL) { $homepage1="No"; } else { $homepage1=("Yes"); } //test if there is text in the homepage field, if yes then the feild is hyperlinked if ( $homepage == NULL) { $homepage1=" "; } else { $homepage1=("<$fontsize color='#0000FF'>Yes"); } //test if there is text in the email field, if yes and the emailpvt field is no then the field is hyperlinked if ( $email == NULL or "No" == $emailpvt) { $name1="$name"; } else { $name1=("<$fontsize $fontcolour>$name"); } //test to see if an engine number is given, if yes then that is output, if no data is taken from engine type if ( "Triumph V8" == $engtype ) { $eng1="$engine"; } else { $eng1= "$engtype"; } //test to see if data in field "newpaint" has been changed from "Same as Original" //if it has we need to use the value from new paint for the colour if ( "Same as Original" == $newpaint ) { $paint="$colour"; } else { $paint= "$newpaint"; } //if (""==$stagpic){ // $stagpic1=" "; // }else{ // $stagpic1=""; // } //assemble each row of the table //check row colour and alternate if (1==$rowcolour){ $bgcolour="bgcolor='#FFFFFF' bordercolor='#FFFFFF'"; $rowcolour=0; } else { $bgcolour="bgcolor='#f4f4f4' bordercolor='$defaultbgcolour'"; $rowcolour=1; } //assemble the table echo(""); echo(""); echo(""); echo(""); } echo("

XXxx	Commission No	Colour	Engine No	Owner	Homepage	Country	Location	xxxx
$icon	<$fontsize$fontcolour>$cnumfull	<$fontsize$fontcolour>$paint	<$fontsize$fontcolour>$eng1	<$fontsize$fontcolour>$name1	<$fontsize$fontcolour>$homepage1	<$fontsize$fontcolour>$cname	<$fontsize$fontcolour>$state	$stagpic1

\n"); ?>