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
- Alex
-
- Newbie area
- Wednesday, 19 March 2014
- Subscribe via email
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.
Last questions
Hi,
I'm working with Hotspots for my new website and I love it! After trying ...
0 Replies
Posted on Monday, 31 March 2025
Hi guys,
Just started to update my old J3x website. Is there J5 compatibility p...
1 Replies
Posted on Monday, 24 February 2025
- #Hotspots
- #hotspots Joomla 5
Hello. How can I increase the font size in the comment input field?
For examp...
0 Replies
Posted on Wednesday, 26 February 2025
- #CComment 6
Hello. When you click on the image in the comments, it does not appear in the ce...
1 Replies
Posted on Wednesday, 26 February 2025
Hello. In comments instead of images I see black squares. Here is an example.
h...
0 Replies
Posted on Wednesday, 26 February 2025
- #ccoment pro