directorypress theme error mysql_error() [closed]

Thanks all, I got it
I changed the code to be

 $SQL = "SELECT * FROM 
   ".$wpdb->prefix."orderdata
   WHERE cus_id='".$userdata->ID."' 
   GROUP BY order_id 
   ORDER BY autoid DESC"; 
$results = $wpdb->get_results($SQL);

That solved the issue

Related Posts:

  1. Undefined function mysql_connect()
  2. Fatal error: Call to undefined function mysql_connect()
  3. MySQL “Or” Condition
  4. the_date() not working
  5. How to return number of found rows from SELECT query
  6. Transaction when using WP functions rather than vanilla SQL?
  7. How to make WordPress plugin check for database changes and then do something?
  8. Custom SQL query to get List of posts with featured image url
  9. Jquery ajax to custom php file: returning blank data
  10. Add value to usermeta without removing previous values?
  11. Problems migrating WordPress to localhost
  12. How can I call a row of user specific data from a custom table added to the WP Database
  13. How to merge local and live databases?
  14. Successful or Error Message after running mysql code in functions.php
  15. Performance issues with large website [closed]
  16. Create a quick start wordpress installation [closed]
  17. theme options echoing multiple times
  18. PHP/MySQL issues when running WP on EC2 cloud [closed]
  19. WordPress 3 – how are passwords stored and how do I compare to them?
  20. WordPress get pagination on wpdb get_results
  21. How to create another version of my site based on the same database
  22. how to echo all tables that start with a prefix
  23. Looking for most performant way to execute several similar WP queries within shortcodes
  24. How to select WooCommerce products by post_meta and order them
  25. Stumped on migration
  26. PHP code inside shortcodes
  27. Show MySQL errors that occur when I excute $wpdb->insert()
  28. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  29. Remove one value in dismissed_wp_pointers?
  30. WordPress Site Running Extremely Slow on Dedicated Server
  31. Accessing data from a non-WP database/table within a page content
  32. Get updated query results on page after insert in database
  33. WordPress not reflecting changed of the database
  34. How can I fix WordPress installation errors?
  35. How can I save unique user data on my site? [closed]
  36. Ordering users by custom user meta
  37. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  38. Hacked WordPress website /Homepage redirect [closed]
  39. Refresh table data with Ajax
  40. Database query works fine outside WordPress
  41. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  42. Using custom tables for old posts
  43. Multiple meta_key in one global $wpdb;
  44. Custom array from a query only write the last row of the query
  45. WordPress member notification
  46. Can’t Query Custom Table Using $wpdb Method
  47. Moving wordpress site from localhost to live server using GoDaddy cPanel
  48. How does WP work in conjunction with a web server?
  49. WordPress Block developer from exporting Database via PHP
  50. Update postmeta after theme switch
  51. Location of core code for database connection and get_header
  52. How do I display offsite database info on my wordpress site?
  53. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  54. Most commented posts by time period (last 12h, last 24h and etc)
  55. Use $wpdb or other PHP script method to find/replace in WP database
  56. Issue with fetching mysql data and displaying results via shortcode in webpage
  57. Hide posts if user is added to it WP_query
  58. Custom route and query
  59. How to unserialize data from MySQL
  60. WordPress WP_Query without query GET parameters
  61. Known Issues in WordPress When Upgrading PHP to ver 7
  62. Edit Account – read and write to MySQL
  63. Get the id of the row from database on click of a button [closed]
  64. Why when I create a new post I found 2 record related to this post into the posts database table?
  65. mySQL queries are executed twice on wordpress website
  66. Query the links Database
  67. Most viewed posts in WordPress
  68. SQL error with custom query
  69. Modify WooCommerce used to get all orders in dashboard
  70. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  71. Get mysql data for Quick Edit panel
  72. Display Results of SQL Query on WP site
  73. Weird fonts showing which are coming from database
  74. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  75. WordPress Bad Request Error 400
  76. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  77. How to display MySQL table data which is stored as an array?
  78. What is the correct way to search 3 custom fields only in WordPress?
  79. cant insert data in a custom table in phpmyadmin
  80. Change upload URL by mime type
  81. autocomplete in wordpress using ajax with json-data
  82. Unexpected behavior when trying to manually install WordPress on macOS Sierra
  83. WordPress post insertion from PHP file
  84. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  85. Query doesn’t display text data with apostrophes
  86. I want show only data for today
  87. Rewrite SQL query as a prepared statement and use in foreach loop
  88. SQL Query Search page
  89. Include a custom field in mysql query
  90. MySQL queries in WordPress
  91. retrieve wordpress post-meta using php not wordpress functions
  92. Let users register weight each day and save it in DB
  93. How to pass username into form that sends data to database
  94. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  95. How to set variable to specific field when querying
  96. How to get a database field value from a WordPress table? [closed]
  97. Getting invalid user ID error when creating a new user with wp_insert_user
  98. Custom form that stores data in mysql database
  99. Error resetting database index using ALTER TABLE in $wpdb->query
  100. Trying to GET data with ajax from database and show in fullcalendar