Hi there,
You can use the column type to ‘string’ (on wpDataTables side when preparing the table), so it would not format it as a number. Next version will have an option to skip the thousands separator.
hi,
I am using wpdatatable plugin but i have one issue.
This below query i am using but it does not produce the results
$table=’wp_post’;
$user_id =1;
“SELECT ID,post_modified FROM $table WHERE post_author = ‘”.$user_id.”‘ AND post_type like ‘sfwd-courses’ AND post_status IN (‘draft’,’publish’)”
after that i trying the below coding its working
SELECT ID,post_modified FROM $table WHERE post_author = 1 AND post_type like ‘sfwd-courses’ AND post_status IN (‘draft’,’publish’)”
but i need to send the user_id dynamically. I don’t know what the issue exactly pls guide me
thanks
Hi there,
If I understand you right, you may want to set it like this:
$user_id = get_current_user_id();
Also maybe you need to check the quotes, try to var_dump the query that isn’t working, see if it’s valid, and try to execute it in PHPMyAdmin.
Also see if it does return any results.
