\r\n"; mail('jim.rolt@googlemail.com', $title, $error, $headers); } include('dataedit/sql.php'); $sql = "SELECT SQL_CACHE History.*, heading, displayorder FROM History INNER JOIN HistoryHeadings ON HistoryHeadings.RecordID = History.headingid ORDER BY displayorder, subheading"; $q = mysql_query($sql)or die(mysql_error()); $hist = mysql_query("SELECT SportHistories.*, SportTypes.TYPE FROM SportHistories INNER JOIN SportTypes ON SportTypes.ID = SportHistories.SportID")or mailjim("his", mysql_error()); ?> British History

Related links:

Famous dates | Town histories

id] = $row->heading; } mysql_data_seek($q, 0); for($i=1;$i<=5;$i++){ echo"
{$titles[$image[$i]]}
"; } ?>

British History

Historic Gun

heading){ if($check != ''){echo' | ';} echo"$row->heading\n"; $check = $row->heading; } } mysql_data_seek($q, 0); echo'

British Sport Histories: '; while($row = mysql_fetch_object($hist)){ $count = 1; $url = urlencode($row->TYPE); echo"$row->title | \n"; $count ++; } ?> History of Golf

heading){// heading once for each set of articles if($check != ''){echo'

';} echo"

$row->heading

\n"; $check = $row->heading; } $desc = ''; $description = explode(' ', $row->article); $num = (count($description) < 50) ? count($description) : 50; for($i=0; $i<$num; $i++){$desc .= $description[$i].' ';}//showing 1st 50 words of article if(!empty($row->subheading)){echo"$row->subheading
\n";} echo "$desc... more
\n"; } ?>