Having problems using a MySQL view instead of a MySQL table.
Having problems using a MySQL view instead of a MySQL table.
Hello Allan.
BTW: This discussion is a duplicate. New Forum hung on save. You can delete this discussion, keep the other, longer one -SH
I have used datatables to successfully get data from a MySQL table. Now I want to use a MySQL view as I need to concat some fields.
See problem at: http://www.chester.open-sourced.com/tracking2.html
It appears to be a PHP/JSON issue because if you run the underlying PHP you just get NULLs. Any Ideas?
See NULLS at: http://www.chester.open-sourced.com/scripts/tracking2.php
There are links in ./scripts so you can see the code too. It's basically your server-side example with my data & fields.
Thank You
Stephen
BTW: This discussion is a duplicate. New Forum hung on save. You can delete this discussion, keep the other, longer one -SH
I have used datatables to successfully get data from a MySQL table. Now I want to use a MySQL view as I need to concat some fields.
See problem at: http://www.chester.open-sourced.com/tracking2.html
It appears to be a PHP/JSON issue because if you run the underlying PHP you just get NULLs. Any Ideas?
See NULLS at: http://www.chester.open-sourced.com/scripts/tracking2.php
There are links in ./scripts so you can see the code too. It's basically your server-side example with my data & fields.
Thank You
Stephen
This discussion has been closed.