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. Help with a $wpdb MySQL Query
  44. How i can obtain all the post meta for a specific post as an array?
  45. Multiple meta_key in one global $wpdb;
  46. WordPress member notification
  47. Can’t Query Custom Table Using $wpdb Method
  48. Moving wordpress site from localhost to live server using GoDaddy cPanel
  49. How does WP work in conjunction with a web server?
  50. $wpdb returns duplicate posts
  51. Update postmeta after theme switch
  52. Location of core code for database connection and get_header
  53. Creating Database Table vs. Adding MetaData to Post & User
  54. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  55. Most commented posts by time period (last 12h, last 24h and etc)
  56. How can I add a new row in a separate database when someone registers via WordPress?
  57. Hide posts if user is added to it WP_query
  58. How to unserialize data from MySQL
  59. How to use mysql LIKE with wpdb?
  60. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  61. WordPress WP_Query without query GET parameters
  62. Known Issues in WordPress When Upgrading PHP to ver 7
  63. Processing ajax call to php to insert into mysql database
  64. Get the id of the row from database on click of a button [closed]
  65. WPDB secure custom form
  66. Query the links Database
  67. WordPress Custom Query: Combining Two Functions
  68. SQL error with custom query
  69. Modify WooCommerce used to get all orders in dashboard
  70. Display Results of SQL Query on WP site
  71. Weird fonts showing which are coming from database
  72. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  73. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  74. How to optimize and reduce excessive database queries
  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. How to import woocommerce custom fields data into another site?
  81. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  82. autocomplete in wordpress using ajax with json-data
  83. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  84. Inserting other fields to existing registration form in a WordPress theme
  85. Query doesn’t display text data with apostrophes
  86. I want show only data for today
  87. Splitting table data to pages with numbers
  88. WordPress WPDB::insert 13th param is always blank (only if format)
  89. Ajax not updating to database
  90. SQL Query Search page
  91. MySQL query in WordPress with AJAX
  92. MySQL queries in WordPress
  93. How to connect database table to each registered wordpress user.
  94. retrieve wordpress post-meta using php not wordpress functions
  95. Splash pages on a high traffic site
  96. Let users register weight each day and save it in DB
  97. Submit cf7 form to cfdb as pdf/BLOB [closed]
  98. How to set variable to specific field when querying
  99. How to get a database field value from a WordPress table? [closed]
  100. Error resetting database index using ALTER TABLE in $wpdb->query
tech