# Data Viewer List + PHP + MySQL **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [July 29, 2020, 1:27am UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896 "2020-07-29T01:27:16Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![lamagalhaes](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/lamagalhaes/32/76611_2.png) [@lamagalhaes](https://community.thunkable.com/u/lamagalhaes)\ **Post date:** [July 29, 2020, 1:27am UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/1 "2020-07-29T01:27:16Z")
First of all, I’m enjoying Thunkable X and the awsome community here! Now… some weird stuff “of course” 😆 maybe some Thunkable gods like @domhnallohanlon can help! 🙌 🙏 🙏 The ideia: push notifications will be stored in a mysql database and replicated to local datasource , in the app, user can view, mark as read/unread and delete notifications… everything is fine here, the problems is not related to push itself or OneSignal. I’m using a `Web API` component that calls PHP script to get/update the database. A `Data Source (local table)` is used to store a “clone” of mysql rows. For this, at “sync process”, I delete all rows in my Data Source, and insert the new ones from list that came from Web API, as JSON… all using a `stored variable` as `list` to store the local row id’s. A `Data Viewer List` to display notifications… and that’s where the are **two** problems: **1. When new notification is inserted in MySQL database with no notifications in `local data source`**. Clicking the reload `button`… new row is created, as you can see the row id, on the top `label`. But, the `Data Viewer List` shows “no data found”. Then I close app, open it again, and the data is there. ![problem1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/0/f065e4a3500062f40699bed21e51f762e235a46f.gif) **2. When reopen app, the message is ok.** Clicking the reload `button`… I delete the `local data source` rows and insert the new ones from API, but it’s like the displayed row was the deleted one, no contents is shown. Again, the new row was created as seen by the rowid on top `label`. After swiping down on list, message is ok again. ![problem2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/8/b82975955fce862af3b9cf77195db81a388baa7d.gif) Hoping to be a bug! 😆 Thank in advance!! 👊 ---
**Author:** ![lamagalhaes](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/lamagalhaes/32/76611_2.png) [@lamagalhaes](https://community.thunkable.com/u/lamagalhaes)\ **Post date:** [July 30, 2020, 6:41pm UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/2 "2020-07-30T18:41:01Z")
Anybody could help please? 😭 I can show blocks and stuff in private. Tks ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [July 30, 2020, 6:58pm UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/3 "2020-07-30T18:58:31Z")
If I understand you correctly, there is a problem with displaying data in Data List Viewer, which becomes correct only after a swipe to update? If this is the case, I can say that the Data Source and Data Viewer components are currently unstable and have bugs. What to do? Either use ListViewer, or wait for developers to make these components work reliably. ---
**Author:** ![lamagalhaes](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/lamagalhaes/32/76611_2.png) [@lamagalhaes](https://community.thunkable.com/u/lamagalhaes)\ **Post date:** [July 30, 2020, 7:30pm UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/4 "2020-07-30T19:30:31Z")
Tks for your reply @actech Yes, that’s one of the problems. List viewer is too limited, I need columns or multiple lines for each record. If you have any suggestions about this, I appreciate. Any predictions about these components updates by the developers? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [July 30, 2020, 7:32pm UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/5 "2020-07-30T19:32:54Z")
You can create a table from several Listviewers located next to each other. If you find it difficult, then look in my project scrTableViewer [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/) Any ListViewer with image [https://x.thunkable.com/projects/5d90cb81aab4c26ef753f324/project/properties/designer/](https://x.thunkable.com/projects/5d90cb81aab4c26ef753f324/project/properties/designer/) ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:26pm UTC](https://community.thunkable.com/t/data-viewer-list-php-mysql/707896/6 "2024-11-08T12:26:54Z")