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:
- How to store the_title() into a variable to reutrn the value, not just echo it
- Metabox repeating fields – radio buttons not saving correctly
- How can merge two arrays values in one array and save in database
- How to update single value in multi dimensional Post Meta?
- Error in WP_update_post
- Compare two meta key values against each other inside the get_posts array?
- Looping through WP_Post Object
- Using a javascript file to access a get posts array
- WP_User_Query order by meta_key that is an array
- Generate an array of parent/child page IDs, based on parent page name
- How do I output a database option that is an array into a get_posts array?
- Can an array be used as a meta_query value?
- Listing and displaying WooCommerce Shipping Zones in the frontend? [closed]
- How do I dynamically generate args for wp_query?
- List of posts by day of the week
- Check if term object is in array
- ‘orderby’ => ‘rand’ alternative for better performance?
- Create shortcodes within foreach loop (using array)
- Using a variable in is_page(array())
- Remove duplicates – array_unique()
- Recent posts with featured image or fallback image with permalink
- Storing Array from returned database query and using the array in a new query
- get_the_tags() not iterating through for/while loop, but will with foreach
- get a simple array of all of the term names that exist in all taxonomies
- How to use $query->set with post__in?
- Reprinting tags with all attributes
- Exclude posts based on meta value
- Checking array against author id in loop
- Alter required message using comment form api
- Advanced Custom Fields – display label and value only if value entered
- Grouping posts by a custom meta value
- wp_force_remove_style’ not found
- How can I access string value in an array?
- How to array only one key from another array
- Filtering a function’ output for a new continued function
- 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?
- Error while setting role
- How to say if meta_value is greater than 0 in an array?
- Loop over Array and get the distinct ids
- If Array Values Match Another Array’s Values, Then
- Remove empty terms from array, sort alphabetically, update back to repeating field
- WordPress loop by meta key that is an array? and how loop multiple arrays
- Only show first image in foreach loop
- How can I get all values from my array in a loop in php? [closed]
- Get all posts as an array ID => Name
- I’m unable to call img path using single quotes in an array?
- Filter by field with array value in ACF on WP REST API
- Comapare get_user_meta value
- How can get all users by current user meta?
- Get the id of all images in a post
- Output category list inside array
- Separate array output into a
- add the value of a variable returned in a while loop [closed]
- Update value of a associative array with update_post_meta
- How To Pass Array To get_the_category_by_ID() and Get An Array Back?
- using images in next/previous_post_link [closed]
- Add custom fields from different posts
- MySQL Query Returns Array () In Shortcode
- Convert a column of a table containing an Array as response in HTML
- Sending simple variable on single page to WP JSON
- Create an array with all the links of the years’ archive (of a custom post type)
- Display just one post from a loop of 5 posts?
- Redux option doensn’t seem when include from functions.php
- in_array not working on dev server but works on localhost
- How to insert multiple rows and columns in database using array
- Display one random image from Media Library
- How to display MySQL table data which is stored as an array?
- Show the subcategory name based on current product
- How to filter specific element of an array in wordpress/php?
- get_category_parents to array
- Notice : Array to string conversion on array_intersect user meta
- Remove item from post_meta array via AJAX
- Fatal error when using array_diff() function inside of wp_update_nav_menu hook?
- PHP array to jQuery array ” Uncaught SyntaxError: Unexpected token < "
- How can get all users by current user meta (array)?
- Display posts using post ID’s in an array
- How can i iterate through this shortcode array?
- Display a single row from nested array of custom field data
- Reformat data within a nested array
- How to find the function which is outputting Array
- Create Customization Controls from Array
- Non-array argument in array_merge()-function [closed]
- How to get values from wordpress listings and use them in javascript array?
- Repeatable field within repeatable group of fields
- !in_array doesnt recognize category
- get_permalink returning first letter
- Showing all post from all post type in admin backstage
- How to set if meta_value is lower < than other meta_value in a get_posts array?
- Populate checkboxes from array
- Use php array outside his function
- PHP Use Declared array Variable inside already Declared Array
- Retrieve Array from within Array [closed]
- Why is my array_diff usage breaking things?
- Grabbing value of input field inside of array
- How to group by column a and sum column b and c in a php array
- Adding date and time to the same request
- PHP how to submit array elements to database
- Send emails to individual subscribers when CPT post is deleted (trashed)
- Get check box values inside array for use in posting form data
- Inserting more than one array into same row