I wish to hide the contents of some columns produced by a JOIN.
MySQL docs show that
SET @previous:="";

SELECT IF(summary=@previous, "", @previous:=summary), ...

does it fine in PHPMyAdmin;
result 1 IVFDF Ceilidh Spot Fri 27 Feb 15 RichardA
result 2 ----- title hidden ---- Fri 27 Feb 15 RichardA


but produces syntax error 1064 in ARI Datatables output, with or without the semi-colon

Can we do this SET in the SQL Query box and what would be syntax be please?
Thanks
Trevor

Hello,

Only one query can be defined in "SQL -> SQL query" parameter. SET and SELECT are two queries. You can create a store procedure and then call it into the module or use a query something like this:


SELECT
IF(summary=@previous, "", @previous:=summary)
FROM
tbl, (SELECT @previous:="") T


Regards,
ARI Soft

Hello, can you clarify 1. how to create a store procedure and
2. does that secondary query have to HAVE a real table called eg tbl;

my single query starts
SELECT IF(summary=@previous, "", @previous:=summary) AS title, ,,,, from 'various joins' etc -
I am trying to suppress the second and subsequent display of the same event title (and date etc)

if in PHPMyAdmin I perform the SET query, then the main query works ie gets it from a session variable?
Thanks
Trevor

You can read about stored procedures here.

Replace "tbl" with a name of table which contains "summary" column.

Regards
ARI Soft