once you have set of result in particular order you can achieve it simply as below : –
$pageposts=$wpdb->get_results("
SELECT * FROM $wpdb->posts
WHERE post_type="post" AND post_status="publish"
ORDER BY post_date DESC LIMIT 6
", OBJECT);
First time
$i=1;
foreach($pageposts as $pageposts_first){
//here goes your first post
if($i==1) break;
}
For rest of posts
$i=0;
foreach($pageposts as $pageposts_rest){
$i++;
if($i==1) continue;
//here goes you rest of posts
}
You can do same thing even if you use get_posts instead..
Related Posts:
- Sorting list of sites from multisite network using wp_get_sites
- Metabox repeating fields – radio buttons not saving correctly
- How can merge two arrays values in one array and save in database
- Compare two meta key values against each other inside the get_posts array?
- Need to get specific data from array
- Create an array from an array
- WP_User_Query order by meta_key that is an array
- Can an array be used as a meta_query value?
- List of posts by day of the week
- Must Use Plugin Causing Query Error
- ‘orderby’ => ‘rand’ alternative for better performance?
- How to convert objects into arrays
- Parsing php string in jquery [closed]
- Admin Options page. Save as Array
- Working with query_posts ( arrays and query strings)
- how can i show only the parents in owl-carousel?
- How can I add multiple ‘tax_query’ arrays via a loop?
- How to properly loop through these external URLs to get them into the sitemap using this hook
- Call global variable array() in woocommerce child/template
- Populate dropdown with Child Pages based on Parent Page chosen
- PHP Array Returning [object Object]. Tried existing answers results with no luck
- foreach loop still echoes array
- Alter required message using comment form api
- meaning of (array)function()
- How to fix this warning:call_user_func_array() expects exactly 2 parameters, 1 given in D:\wamp\www\…….\wp-includes\class-wp-hook.php on line 286
- How to use if statement in an array? [closed]
- How to array only one key from another array
- Get html data with javascript to php array and store to wordpress database
- How do I create a numbered list with PHP? [closed]
- Why is an array created in a function hooked to customize register populated when customizer is loaded but not when the front-end is loaded?
- How to use array in function to get only value I want
- Get categories names as an array to use it in theme settings
- How to get the last category name of a child category?
- How to use two meta_compare in an array?
- Warning: in_array() null given in PHP function
- Foreach loop inside an array_merge
- How to access or parse key/values that have “string”
- WordPress loop by meta key that is an array? and how loop multiple arrays
- Conditional multidimensional arrays and array_map
- Getting posts to exclude from array
- extract serialized array to use for wp-query
- get users search not working with array
- Comapare get_user_meta value
- how to make an array of post id’s in is_single
- How can I split my query result in 2 arrays?
- Multidimensional Array
- array_rand not working correctly?
- Get css class of menu item in custom menu structure
- Dynamically adding filters
- Order a WP_Query by meta value where the value is an array
- Only load certain artists on this page
- How to make sure relative URL works when site is not on root domain?
- Get URI from PodPress using PHP
- Finding and removing duplicates within WP Arrays
- Using multiple variables to assign categories to an array
- Custom functions for string data calculations
- Repeat a function with 24hrs gap for n number of days
- Problem with inserting multiple images in gallery of each WooCommerce product programmatically
- Sending simple variable on single page to WP JSON
- Order users by random not working?
- How can I show how much water got saved on this order (making use of the number of items bought) on a thank-you-page?
- how to separate an array into different arrays and save them into db?
- ACF – Get ID of relationship field in flexible content
- Replace an array (with identical values) with another array in the_content
- WP post meta – for loop inside for loop
- Combine multiple queries, array_unique returns nothing
- Store custom field’s multiple values in one user meta key
- Remove item from post_meta array via AJAX
- Make sticky post with FacetWP
- PHP array to jQuery array ” Uncaught SyntaxError: Unexpected token < "
- get_users when from meta key that has serialized values
- make an array in wordpress cusmization api?
- Trouble with checked() for array of multiple checkboxes
- How to replace hard-coded list of custom taxonomy terms based on custom field query [closed]
- Get a list of tags present in a paged front page
- How to use foreach and if statement within array of arrays?
- Add custom filter to register data in array
- Page returning ID from array, how to return the correct values for post in acf wordpress
- WP_Post is not from correct array
- How to find the function which is outputting Array
- Auto remove empty values in array
- Exclude Post ID from Array Specified in Custom Field
- Display a post based on its metabox selection
- Unserializeing multiple column values that are stored in one database results variable
- Adapting a php array to WordPress
- wp_get_archive for category returning different URLs on different but similar sites
- get_permalink returning first letter
- How to print array of specific item
- What is this mark for “? function()” [closed]
- How to combine array info [closed]
- PHP Use Declared array Variable inside already Declared Array
- Force array to be a string [closed]
- get_body_params() is always empty in POST request
- Grabbing value of input field inside of array
- save array of objects with update_option
- Custom WordPress Function – Adding items from Foreach Loop into an array and Updating Field based on array of IDs (ACF + WooCommerce)
- How to initialise WP_Query on the basis of a specific meta_value and continue iterating rest?
- Replace block content with an array
- Adding date and time to the same request
- PHP – Converting elements to actual values