After join term_id
exist two times. You should specify which term_id
you are querying by prefixing full table name (or alias).
Also there is a other error term_taxonomy.term_id = terms.term_id
missing table prefix.
So the updated query will look like
$query = 'SELECT term_taxonomy_id, ' . $wpdb->prefix . 'terms.term_id, taxonomy, name FROM ' . $wpdb->term_taxonomy . '
JOIN ' . $wpdb->terms . ' ON ' . $wpdb->prefix . 'term_taxonomy.term_id = ' . $wpdb->prefix . 'terms.term_id
WHERE taxonomy = \'category\'
AND name LIKE \'' . $search . '%\'
ORDER BY name ASC';
Related Posts:
- How to send multiple data fields via Ajax?
- Tags in WordPress 3.2
- Disable stored tags queries in admin page when posting a new post
- Searching multiple tags and adding jQuery dependant script onto page template?
- Assigning tags to a post from front end using tag-it jquery UI plugin
- I want to run Sql Query in script how can i do this
- My website frequently redirect to a different advertisement URL
- Clear custom field when new tag is added
- Submit a form using jQuery
- JavaScript: filter() for Objects
- Force a default browser on my android phone using a simple html shortcut page
- Is jQuery $.browser Deprecated?
- jQuery date formatting
- $ versus jQuery
- How to center image in carousel
- jQuery dynamic selector
- How to pass $(this) properly in click jQuery function
- How to remove specific value from array using jQuery
- e.preventdefault(); not working
- How to empty input field with jQuery
- Using WordPress 3.5 Media Uploader in meta box?
- how to remove default jquery and add js in footer?
- Lightbox popup on WooCommerce add_to_cart action
- Check if jquery library exist
- Loading style.css and Jquery using HTTPS
- AJAX function returning -1
- Access Customizer’s DOM – jQuery
- jQuery AJAX form validation
- Media manager multiple selection
- Trying to get single posts to load on the front page via ajax
- How to include jQuery properly?
- How to load whole WordPress pages dynamically with AJAX/jQuery like this following website?
- Creating custom AJAX requests
- How to pass jQuery ajax URL value
- trigger(‘change’) not working
- how to get the comment ID in the front end when the REPLY button is clicked?
- Gravity list field override and adding javascript [closed]
- Change header image loaded by jQuery to use HTTPS
- Admin wp_ajax hook returning 0
- Adding a character counter to the excerpt metabox
- Need To Deregister Scripts Via Functions.Php
- Add a Fancybox automatically to post type “post” images
- enqueued script with jquery dependency not getting jquery
- Uncaught TypeError: jQuery is not a function
- WordPress customizer refresh screen after save
- Creating multiple enclosing shortcodes and fixing JS issues on click
- How can I check email exists via a jquery keyup()?
- Include jQuery plugin in WordPress
- Hide metabox dependant on page template chosen
- Trying to remove duplicate jquery scripts
- How to make an WordPress element sticky? [closed]
- I want to import my Json file into a custom made display-modal. How do i link my Json file?
- Validating a cloned/repeatable input (jQuery) [closed]
- How do I remove WordPress Custom Menus hover event and replace it with jQuery onclick?
- How to get all users by custom current user meta (array)?
- wp_dequeue_script not working in my plugin
- jQuery script isn’t posting to database
- Do I need to use jQuery for my template?
- Loading scripts on a single page plants the script in the footer
- Problem Implementing parallax in header of bp-default theme
- jQuery Show DIV and Remove Button [closed]
- timeouts (ERR_CONNECTION_RESET) on seemingly random files after upgrading to HTTPS
- Moving jQuery to footer from header
- jQuery plugin not loading
- click event to unhide something after ajax not firing
- how to use wp_editor() here am getting empty result
- jQuery is not defined, working on local server but not online
- Why does WordPress load jQuery in my header instead of footer?
- Parse wordpress blog data using json api and ajax
- JQuery Issues With WordPress Theme Interface
- problems with jquery external rss feed integration
- wp_enqueue_script calling jQuery at different times for different browsers?
- AJAX calendar navigation returns -1
- A carousel slideshow plugin in JavaScript
- Retrive username of the loged in user using jquery
- How to setup multi-page using jquery?
- $ not defined using jQuery in WordPress
- Get with jQuery the value of an ACF field
- error: n.imagesLoaded is not a function
- WordPress forbidden 403 on delete in production vs local environment
- Homepage loads many unnecessary jquery-ui files
- How to change event in slider
- Get ajaxForm response value
- Update a parent theme JQuery property in the child theme
- Adding scripts before plugins scripts
- jQuery search function not running in WordPress but running locally (fiddle)
- Can’t seem to get JQuery working (wordpress plugin)
- Ajax Request with jQuery not happening
- Bootstrap with Flexslider jQuery Issue
- Console shows ReferenceError: jQuery is not defined, no clue why!
- slide change on hover with nextgen scrollgallery [closed]
- How to make jQuery load AFTER plugin’s script?
- jQuery not working internal pages [duplicate]
- jQuery .change() Event Bubbling in WP Admin
- Unable to understand this jquery code [closed]
- Combo box populating a DIV using ajax/jquery
- Accessing Advanced Custom Fields with Repeater using jQuery instead of PHP
- How to Add jQuery cod in wordpress [duplicate]
- can’t make jQuery work (change image on time interval) [closed]
- Enqueued jQuery not working