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

Errror on Google Captcha V3 in Matukio
Hi, I am experiencing spam-problems on contact-forms protected by google reCa...
0 Replies
Posted on Wednesday, 20 March 2024
  • New
  • Google map styles migrating......
    Google are updating their map styles. Is there anything we need to do to migrate...
    0 Replies
    Posted on Monday, 18 March 2024
    • #google maps
    • #map styles
    Latest Hotspots Makes Website Hang
    When using the Latest Hotspot module, the webpage slows down and does not load....
    3 Replies
    Posted on Monday, 15 January 2024
    Text ändern
    Hallo in der Übersicht der Veranstaltungen kann man ja auf "Mehr Informati...
    0 Replies
    Posted on Thursday, 14 March 2024
    When is CComment compatible with Joomla 5?
    When is CComment compatible with Joomla 5?...
    3 Replies
    Posted on Tuesday, 05 December 2023
    • #CComment
    • #Joomla 5