Step 1: build a Loop that loads the posts you want. Note: you can number the limit of results using the posts_per_page parameter. Step 2: style the posts using CSS. Give each post box a width and float them to the left.
You have several things going on there and I may not be able to sort them all out. Unless $wpdb->cf7dbplugin_submits has been added to the $wpdb object your query won’t work. You will need something like {$wpdb->prefix}cf7dbplugin_submits instead but I can’t really guess at the right value. You don’t need to swap in 9999. That … Read more
There isn’t an error. The square brackets are empty– aka “no error”. Put a spurious comma in the SQL and you will see what I mean. But your SQL is wildly complicated for you are doing. That is entirely equivalent to SELECT * FROM $table ORDER BY id DESC LIMIT 1 Though, I notice you … Read more
For Placehold to work, you should use $wpdb->query like: $wpdb->query( $wpdb->prepare( ” SELECT * FROM mailer WHERE id = %d “, $_GET[‘caId’] ) ); However in my opinion, the best option is to simply validate the get-parameter and than use it in $wpdb->get_results , like: $catId = $_GET[‘caId’]; if(is_numeric($catId)){ $_crds = $wpdb->get_results(” SELECT * FROM … Read more
Edit: You have an extra underscore in your table name, it becomes wp__posts in your case. Better use like how I have shown below 🙂 First, use table names like the following and try var_dump to see if it returns NULL. In case the Post ID doesn’t exist, $product will be NULL, which only var_dump … Read more
Easiest way to control column and/or row layouts I know of is to make use of modulus. I broke it down in a tutorial and use it with wordpress in my examples. WordPress and PHP Modulus The first example is basic, while the second is a bit more advanced and utilizes post images/attachments. If it … Read more
Try: $fields = get_field(“updates_list”). And then print_r to see what’s inside. You should have a nice looking array with all repeater fields and values inside. Then, stop using have_rows and get_row and just loop using a foreach loop. get_field() is usually used to retrieve a unique field, but because it’s a repeater field you get … Read more
Welcome! WordPress already have a table for users. Also, there is another table named usermeta that will allow you to save extra information for users. There are some functions that allow developers to get information from user and usermeta tables without using custom database queries. add_user_meta update_user_meta delete_user_meta get_user_meta Solution: As mentioned in the question, … Read more
This is essentially a SQL question. The only possible WordPress related component would be if you were asking about database structure, which is in the Codex. Or you could just look at the database itself. The post ID is incremented and never duplicated. The highest IDs are the last added. The query is simple. SELECT … Read more
global $wpdb; /* grab meta value, it is assumed you know the post id ($id) in question */ $dot_number = get_post_meta( $id, ‘dot_number’, true ); /* grab all rows with matching value in ‘dot_number’ column */ $matches_query = $wpdb->get_results( “SELECT * FROM ” . $wpdb->prefix . “csadata ” . “WHERE dot_number = ” . $dot_number, … Read more