xsl src = /home/linweb06/j/johnbulmer.co.uk-1036832748/user/htdocs/news/news.xsl
xml src =
transformation mode =

content=SELECT cID, cArea, cSub, cURL, cTitle1, cTitle2, cContent1, cContent2, cMetaDesc, date_format(cDate,'%d %M %Y') AS cDate, cDate AS cDateSort FROM content WHERE cArea = 1 AND cActive = 1 AND cDeleted = 0 ORDER BY cDateSort ASC;
<content>
<cID>16</cID>
<cArea>1</cArea>
<cSub>15</cSub>
<cURL>
</cURL>
<cTitle1>John Bulmer's 'The North' Book</cTitle1>
<cTitle2>
</cTitle2>
<cContent1>
<p>
<strong>NEW BOOK</strong>
<br /> &nbsp;</p> <p>New Edition 2020 Signed copies &pound;28 plus &pound;6 shipping&nbsp;</p> <p>
<img width="500" height="439" src="/media/image/NORTH-cover3-B.jpg" alt="" />
</p> <p>
<span style="line-height: 1.4em;">Signed copies are available from John Bulmer</span>
</p> <p>
<span style="line-height: 1.4em;">please email john@johnbulmer.co.uk</span>
</p> <p>
<span style="line-height: 1.4em;">Price &pound;25 plus &pound;6 p&amp;p (UK)</span>
</p> <p>Postage for Europe &pound;20 &nbsp;for USA &amp; Canada &pound;25</p> <p>&nbsp;</p> <p>
<strong>PRINT SALES </strong>&nbsp;</p> <p>
<br /> For print sales &nbsp;contact John Bulmer &nbsp;john@johnbulmer.co.uk</p>
</cContent1>
<cContent2>
</cContent2>
<cMetaDesc>
</cMetaDesc>
<cDate>02 October 2013</cDate>
<cDateSort>2013-10-02</cDateSort>
</content>
<content>
<cID>1</cID>
<cArea>1</cArea>
<cSub>0</cSub>
<cURL>news</cURL>
<cTitle1>NEWS SEE BBC ARTS INTERVIEW LINK -http://bbc.in/1J4Lydl</cTitle1>
<cTitle2>
</cTitle2>
<cContent1>
</cContent1>
<cContent2>
</cContent2>
<cMetaDesc>
</cMetaDesc>
<cDate>03 October 2014</cDate>
<cDateSort>2014-10-03</cDateSort>
</content>
<content>
<cID>18</cID>
<cArea>1</cArea>
<cSub>17</cSub>
<cURL>
</cURL>
<cTitle1>John Bulmer's 'Wind of Change' Book</cTitle1>
<cTitle2>
</cTitle2>
<cContent1>
<p>
<img width="500" height="398" src="/media/image/Winds-of-Change.jpg" alt="" />
</p>
</cContent1>
<cContent2>
</cContent2>
<cMetaDesc>
</cMetaDesc>
<cDate>03 October 2014</cDate>
<cDateSort>2014-10-03</cDateSort>
</content>
<content>
<cID>19</cID>
<cArea>1</cArea>
<cSub>18</cSub>
<cURL>
</cURL>
<cTitle1>BBC Interview</cTitle1>
<cTitle2>
</cTitle2>
<cContent1>
<p>&nbsp;SEE THE INTERVIEW ON BBC ARTS</p> <p>&nbsp;</p> <p>LINK-</p> <p>&nbsp;</p> <p>
<a href="http://bbc.in/1J4Lydl">http://bbc.in/1J4Lydl</a>
</p>
</cContent1>
<cContent2>
</cContent2>
<cMetaDesc>
</cMetaDesc>
<cDate>11 July 2015</cDate>
<cDateSort>2015-07-11</cDateSort>
</content>
<content>
<cID>21</cID>
<cArea>1</cArea>
<cSub>20</cSub>
<cURL>
</cURL>
<cTitle1>New Book "A Very English Village"</cTitle1>
<cTitle2>
</cTitle2>
<cContent1>
<p>
<span style="font-size: 12px;">&nbsp;</span>
</p> <p>
<img src="blob:http://www.johnbulmer.co.uk/931ff404-a2eb-4783-9da2-bd5d50769be1" alt="" />
</p>
</cContent1>
<cContent2>
</cContent2>
<cMetaDesc>
</cMetaDesc>
<cDate>14 November 2020</cDate>
<cDateSort>2020-11-14</cDateSort>
</content>


Array
(
        [areaName]   ⇒   news
        [subName]   ⇒  
        [dubName]   ⇒  
        [pubName]   ⇒  
        [area]   ⇒  
        [sub]   ⇒  
        [dub]   ⇒  
        [pub]   ⇒  
        [siteName]   ⇒   John   Bulmer
        [domain]   ⇒   johnbulmer.co.uk
        [local]   ⇒   1
        [page]   ⇒   index
        [id]   ⇒  
        [success]   ⇒  
)