prepare stmt is not working set @sqlt = concat("select", @rowname_date," from  syslog_data.syslogs_index_1 ");
prepare stmt from @sqlt;
execute stmt;
deallocate prepare stmt;

gives me a eeror 1064 in the prepare statement?
Any advise please.
Thanks
Assuming that you have a valid column name or a properly escaped literal in @rowname_date and you don't have leading spaces in it then you have to have a space after SELECT clause

set @sqlt = concat("select", @rowname_date," from syslog_data.syslogs_index_1 ");
                         ^^


Here is SQLFiddle demo