1. Alex
  2. Newbie area
  3. Wednesday, 19 March 2014
  4.  Subscribe via email
Hi,
I am creating a custom list of hotspots directly from the database.
http://russianchurchindandenong.com.au/orthodox/ch/en/list-of-churches
I need to build a HREF link to individual hotspot from the database.
I've noticed the individual hotspot URL is excellent for SEF but quite complex to generate from the database, example
http://russianchurchindandenong.com.au/orthodox/ch/en/map/3-greek-church/4-cathedral-of-the-annunciation-of-our-lady-s
You have both category name and spot name, with special characters stripped or substituted, and length capped at 45 chars...
Can you please help? Perhaps there is an easier way to generate a link just by using the ID?

PS so far my SQL query:
SELECT j0385_hotspots_marker.name as Name, cat_name as Type, CASE left(plz,1) WHEN '0' THEN 'Northern Territory' WHEN '2' THEN 'New South Wales' WHEN '3' THEN 'Victoria' WHEN '4' THEN ' Queensland ' WHEN '5' THEN ' South Australia' WHEN '6' THEN 'Unknown' WHEN '7' THEN 'Tasmania' ELSE 'Unknown' END as State , town as Suburb, plz as Postcode, street as Address FROM j0385_hotspots_marker, j0385_hotspots_categorie where j0385_hotspots_categorie.id = catid
Responses (0)


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Last questions

coupons valid just for certain categories of event
We are using Matukio I guess from the beginning of the extension and nearly all ...
2 Replies
Posted on Friday, 21 January 2022
  • New
  • Kann man Matukio auch unter Typo3 einbinden?
    Ich habe Matukio bereits sehr lange unter Joomla am laufen und habe nun das &quo...
    2 Replies
    Posted on Sunday, 21 February 2021
    I cannot modify the content of a comment using the
    Hi, When I try to edit a comment by clicking ContentItem, I got a blank page....
    0 Replies
    Posted on Wednesday, 19 January 2022
  • New
  • Can't install CComment
    When I try and install CComment Core via "Install from Web", it fails....
    1 Replies
    Posted on Monday, 17 January 2022
  • New
  • CMC for Joomla 4
    Was wondering if you have intentions to make CMC work with Joomla 4?...
    1 Replies
    Posted on Friday, 14 January 2022