SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'ifnull(SUM(case when name = ''',
name,
''' then donations end),null) AS `',
name, '`'
)
) INTO @sql
FROM
mytable2;
SET @sql = CONCAT('SELECT date, ', @sql, '
FROM mytable2
GROUP BY date');
PREPARE stmt1 FROM @sql;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
I have downloaded the shrinktheweb module on Drupal 8. Enabled the module, set the acces and sequrity keys and adjusted configuration. However, I can't find any direct information beyond that on how to run it on drupal. Copying and pasting a sample code somewhere ?. is not a direction.
I have already upgraded my Shrinktheweb account. However, I can't send support tickets to Shrinkthewrb.
Is it possible to focus on a specific field in form_alter?
I saw that there is a module that does this but I would like to understand how to do it programmatically in form_alter
I am trying to redirect visitors if it is their first time on site.
I beleive in drupal 7, this could be done on itialization using init().
Im using a gated content module to check with cookies if a user has already visited the site before. But this uses JS and is executed once dom is fully loaded.
Im trying to find a way to detect at the earliest point. Before any content is load if possible.
What sort of function should I be looking at?
I know is a generic question but just looking for a starting point. Thanks
I need some help related to php. I have connected my DB with frontend web application through PHP. But I have a little bit problem with it. I want to fetch specific record from the database. Can anyone guide me how can I do it. I will appreciate your suggestions.