Presto
-
mySQL: Query two tables for multiple results from array in first table?
So I was able to get it to work by replacing WHERE IN with FIND_IN_SET: "SELECT e.*, (SELECT GROUP_CONCAT(DISTINCT o.title SEPARATOR ',') FROM #__raceschedule_options AS o WHERE FIND_IN_SET(o.id, e.options)) optiontitles FROM `#__rac…
-
mySQL: Query two tables for multiple results from array in first table?
I know it can be done with only two tables, as the backend of Joomla is currently doing it this one :O) So I think I have it almost working, this query pulls all of the option titles from the table: "SELECT e.*, (SELECT GROUP_CONCAT(DISTINCT …
-
mySQL: Query two tables for multiple results from array in first table?
Hello traq, thanks for the reply... CREATE TABLE `qmzi_raceschedule_events` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ordering` int(11) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL, `checked_ou…
-
iOS compatible audio player
I did this site some time back, I think the audio player (jPlayer) I used also works on iOS devices: http://www.hailun-pianos.com/hailun-piano-center/hailun-music-library.html Here is jPlayer's website: http://www.jplayer.org/
-
Displaying multiple thumbnail and a main image with different source
Hello @ajnoguerra, I would create a new folder in your images directory called thumbs so /images/thumbs/ then save your thumbnails in that folder with the same name as the larger images in the main images directory, then when calling the database g…
-
CSS first-child not working on site, but works on CodePen?
Thanks for the codepen Krish1980 sigh you are correct TheDoc, HugoGiraudel, yeah I was using :first-of-type at the start and that worked really well, but I needed to make it IE7 friendly, so should I just add a class to that first ul and style that…