Why is no data saved when pull data from mysql ?

[Tao Guan]

Why is no data saved when pull data from mysql whatever save format is table or list?
My sql statement is as below:
SELECT t.id, t.selection_odds, t.selection_column, t.selection_betoffer_type_id, t.selection_stake, t.selection_time, m.u_event_id
FROM `#__socceridea_tips_auto` AS t
LEFT JOIN `#__socceridea_mapping` AS `m` ON (`m`.`s_event_id` = `t`.`event_id`)
WHERE `t`.`tmp_pending`=1 AND (`t`.`selection_provider_id`=2 OR `t`.`selection_provider_id`=35) AND `m`.`e_time` > NOW()

 

[lokiys]

Why is no data saved when pull data from mysql whatever save format is table or list?
My sql statement is as below:
SELECT t.id, t.selection_odds, t.selection_column, t.selection_betoffer_type_id, t.selection_stake, t.selection_time, m.u_event_id
FROM `#__socceridea_tips_auto` AS t
LEFT JOIN `#__socceridea_mapping` AS `m` ON (`m`.`s_event_id` = `t`.`event_id`)
WHERE `t`.`tmp_pending`=1 AND (`t`.`selection_provider_id`=2 OR `t`.`selection_provider_id`=35) AND `m`.`e_time` > NOW()

Hello. I'm sorry to say, but there is no enough information to help with something.

Not sure what You ask and what You want to do.
Try to be more specific and maybe attach some screenshots to explain better.

 

[Tao Guan]

Hello. I'm sorry to say, but there is no enough information to help with something.

Not sure what You ask and what You want to do.
Try to be more specific and maybe attach some screenshots to explain better.

Hi,
Thank you for your reply..........
Here is database setting from my project screenshot in the attachment.
I want to connect to mysql and get data from mysql, so I query this statement above, actually which is useful because I have tested successfuly with mysql tool. But in Zenno project, I use this query to get data and save the data into table, nothing happened, table is empty always. That is the question.
Can you understand my meaning?

 

[VladZen]

What data should saved? what format in?
What if you save extracted data to variable?
Also, please check execution in program. is there any info

 

[Tao Guan]

T

What data should saved? what format in?
What if you save extracted data to variable?
Also, please check execution in program. is there any info
Посмотреть вложение 30046

Thank you for your help.
With you help, I find solution.