The reason why it wasn’t working was because of my form action. I moved the code to insert data to the search results page and it added the the data to the table like I needed.
Related Posts:
- How to join tables?
- Custom Queries: Joining On Meta Values From Two Custom Post Types
- How to use filter hook posts_join for querying taxonomy terms in posts_where?
- How to search for posts IN OR title OR content OR author?
- WP_Query hit max joins… How else can I build a search function that uses custom fields?
- Query All users that has post
- Join inside a wpdb query.. confused!
- Join new table with SQL query
- writing inner join in wpdb
- How to display upcoming events by dat with Modern Events Calendar Lite
- WordPress post_where & posts_join not working only for custom post type
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Using $wpdb to fetch posts with meta data
- Inner Join user tables to select users with roles
- List author’s posts with SQL
- $wpdb – joining shows no result
- What does the $posts_join filter join to?
- Are term_taxonomy_id and term_id the same? [duplicate]
- Reordering content using a meta value
- WordPress SQL JOIN query
- How to display specific data from a custom table to logged in users with a custom role
- Custom SQL query slows down when using multiple OR … LIKE … in posts_where filter
- can I extend the WP_Query class to deal with ‘duplicate’ posts created by joining to wp_posts?
- order posts by a secondary query that counts items
- Build table using Advanced Custom Fields
- Custom user query – orderby meta_key (that may not exist)
- WP_Query to show post from a category OR custom field – Not 100% answered
- Joining tables not working in the post editor page
- Custom wordpress SQL statement for a website
- WPML posts_joins on translated items