You have the where clause of the query in the wrong place.
Your query should be written like this:
$query= "SELECT *
FROM files
WHERE custom > 0
ORDER BY id DESC
LIMIT $from, $site";
As specified here https://dev.mysql.com/doc/refman/8.0/en/select.html in the MySQL reference.
Related Posts:
- correct validate and sql query
- correct sql query
- problem with sql query
- Remove posts that start with similar words (like a delete duplicate posts plugin)
- Show a different number of posts per page depending on context (e.g., homepage, search, archive)
- What are the common security flaws I need to look for? [closed]
- Making my plugin multi-site compatible
- Creating 20,000 Posts or Pages using a .csv file?
- Is their any way to Extend WPDB class and Overwrite the Default Query Function
- What’s the easiest way to duplicate an entire navigation menu?
- Using nextGen Gallery.. how can I call a list of all Gallery Names?
- Search and replace text across all posts
- Updating WooCommerce variable product stock issue
- bulk post_content update
- How can I get a list of plugins and which blogs are using them?
- What is the easiest way to implement cascading database upgrade for my plugin?
- [Plugin: Posts 2 Posts] How does it work?
- Post query – show posts from specified day and month and whole years
- Plugin Development sqlite or WordPress’ database
- Retrieving a Value from a wp-database
- Plugin echos text from shortcode function in gutenberg page editor
- Problem with creating tables for Plugin
- Prevent duplicate records in plugin table
- WordPress WPforms customization
- How do I run SQL queries on a WordPress web page? [closed]
- Migrating to WordPress Recipe Plugin and Some SQL Issues
- WP Query. Is there a maximum size?
- WordPress and a secondary database?
- plugin code is pulling information from database in one instance and not in other. What is wrong?
- WooCommerce search products between price range using WP_Query
- How to create multiple database tables on plugin activation?
- Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
- Speeding SQL queries for a large database?
- $wpdb update query in plugin only updating one column
- Create a post builder skin in a plugin
- Taxonomy Drill-Down / Plugin Help – hierarchical queries within plugin?
- How to customize a title by passing query string?
- What is the best way to cache pages on WordPress
- Always get creating a new table with foreign key
- Woocommerce Backend Search by Title and SKU
- add_query_arg not work in admin
- Deactivation Hook does not remove database
- How to return the values from a row where a value occurs for the first time among the rows available?
- How to use apply_filters?
- Using AJAX to run SQL statement and populate dropdown
- Adding CASE in WP_Query
- JOIN and SUM different statement results (Mailster Database)
- How to search post titles with whole words only, but not the exact word only?
- How to get specific column data conditionally in database in WordPress?
- Change language on website and change currency with url query
- Memcaching recurring SQL Queries
- add products to WordPress site automatically
- How to get database connection details without longing to cpanel in WordPress?
- Performing CRUD operations on front end in wordpress
- Displaying different content depending on variable
- How to create algorithm for ordering posts in WordPress?
- Display a number value from mysql query in WP
- Looping the data from WordPress database using foreach
- How To Toggle User_Meta in frontend in a form using PHP
- Get and Update Most Meta Value as an array in HTML form
- WordPress filter from custom table is not working properly
- errno: 150 “Foreign key constraint is incorrectly formed” [closed]
- Multiple Meta key in search
- Having trouble going from Jfiddle to implementing in WordPress :(
- Create Array from data in the OPTIONS table
- Proper way to trigger a MySQL query via link in a plugin
- get_var result empty for query of custom table in plugin admin
- WP-Snap too slow (caused by WP_Query?)
- why the current date do not update
- Custom Table doesn’t create on plugin activation
- Using wp config to connect to a DB from a plugin
- correct validate inputs
- Get all the related data from WordPress DB
- ‘Active lotteries’ only custom query for woocommerce lottery plugin and elementor
- How to change and edit users according to the extension in the URL
- Change comments ordering by custom value
- Struggling to edit the width of text in ‘Variations’ template
- How to verify/test that a custom built wordpress theme is as secure as possible?
- Using Widget Logic to place menu on multiple pages?
- Creating wordpress admin page panel [Theme Option]
- Get content and send to 3rd party
- ‘Easy Template Path Hints’ for WordPress?
- How to make wp multisite subdomain exist search
- WordPress SSO SAML
- Molpay recurring payment in WordPress
- Modify Plugin shortcode function code
- plugin not hooking to my custom hook
- Remove Url Parameter WordPress
- Adding javascript to header of MetroMagazine theme
- Wordress admin page is fetching error You do not have sufficient permissions to access this page.
- Populate select option with JSON file
- Create post loop that displays pages by cat ID
- “Listen” button on my main post page
- Enahanced search for edit.php and custom post type
- Rogue splash page keeps popping up
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- CMB2 Post Search Field displays/repeats initial post if left empty
- Why is the WordPress update_option not working in this code?
- Making a Custom Post Type Plugin – keep getting the white screen of death
- TinyMCE how to add css when inputing a text