Your problem is likely that $wpdb->jch_gigs is undefined. Is jch_ the prefix of your DB tables, as defined in wp-config.php? If so, try this:
$wpdb->prepare(
"UPDATE {$wpdb->prefix}gigs
SET available = available - %d
WHERE ID = %d",
$quantity,
$item )
);
wpdb class on the Codex
Related Posts:
- $wpdb->get_row() only returns a single row?
- wpdb->insert: do I need to prepare against SQL injection?
- How to parse row results from $wpdb -> get_results
- Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
- what is the way to see the currently executing query in wordpress?
- Fetch array with $wpdb
- How do I check for a duplicate record before inserting using wpdb
- WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
- How to use $wpdb to delete in a custom table
- $wpdb->insert not working in any way
- WPDB prepare – like % – placeholders?
- $wpdb->update multiple rows, like IN in normal SQL
- Matching database content types to PHP types
- Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
- get_results on large datasets
- $wpdb->insert() and Values for Datetime Columns?
- $wpdb->last_error doesn’t show the query on error
- Avoiding “Usage of a direct database call is discouraged”
- dbDelta does not create Table, but returns success
- Theoretical Multi-Server WordPress Setup with Shared Users
- Change post status based on meta value
- wpdb->insert not working
- Saving custom form data into database
- passing variables as parameters to stored procedures via wpdb from php-script
- Get data from database table by post_id to get data from second database table
- wp-content/db.php : where is this file?
- Quotes in table name
- Delete/replace img tags in post content for auto published posts [closed]
- $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
- $wpdb->get_results() returns good result only in first foreach iteration
- $wpdb->insert – inserting multiple rows
- Speed optimization of $wpdb->get_results
- How do I create a single.php for a specific category?
- $wpdb prepared with search term
- WPDB->insert with special characters
- What does wp_update_post() do that the $wpdb class does not?
- How Can I Use $wpdb in PayPal IPN file?
- $wpdb is get_results escaped
- $wpdb->query() multiple query support
- wpdb-> not adding prefix to custom table
- Is there a (better) way to access $wpdb results?
- Using $wpdb generates DB error
- WordPress insert NOW() in TIMESTAMP column returns all zeros
- How do you use prepare when asking for a list of id’s
- Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
- $wpdb prepare issue with mysql DATE_FORMAT
- How-To: wpdb Insert Record With Date
- How to use prepare to query with variables
- Use $wpdb in wordpress theme files
- How to pass NULL in where array for $wpdb->update
- how to execute different sql query in non-sanitized $wpdb->get_results function
- $wpdb not returning data
- Get random row from custom table
- How to get top 10 user is based on user meta value
- $wpdb Query Result not coming but in phpmyadmin it works [closed]
- WPDB update row with != in where clause
- store custom WP table names in a global variable
- wpdb prepare: passing varible number of fields as second argument
- $wpdb insert array
- I am not understandinhg $wpdb->prepare correctly
- Wpdb query for comment meta for current post
- How to update records using $wpdb?
- wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
- Problem in creating table through plugin code
- I want to update my postcontent with $wpdb
- How to save html and text in the database?
- XOR functionality for meta_query
- How to email user after inserting the username in database in WordPress
- $wpdb->replace / Replace or update primary key
- Join inside a wpdb query.. confused!
- Create an array with a string key from wpdb->get_results
- How to fetch an array in $wpdb?
- $wpdb – do you have to use foreach even if there will always only be one result?
- How to Modify this $wpdb query to accept an array of post statuses
- Replicating the WP_Query ‘s’ param with $wpdb
- Why doesn’t my insert query work?
- Need help writing a $wpdb query
- How to prevent $wpdb->prepare stripping a leading zero in variable value?
- Generate a unique hash/number for tracking on $wpdb insert
- get the number of queries made on a page(inside my plugin)
- Doing a loop with multiple DBs simultaneoulsy
- Using WPDB class
- show badge with count for pending items in custom post type
- WPDB Update using Conditional Arrays
- $wpdb->insert query changes to SHOW COLUMNS query Output
- How can I migrate mysql_fetch_array to $wbpdb?
- $wpdb->get_results returns empty but value exists
- Fixing wpdb->get_results and wpdb->prepare?
- How does the WXR file differ from the WPDB?
- WP Sql query multiple where clause
- Problem displaying inserted form
- What is _transient_random_seed for?
- WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
- wpdb->insert and stripslashes against sql injection
- Get published posts and pages?
- Rolling Back from current WordPress version to previous one
- create drop down menu in theme customizer from custom db
- Modify the structure of data returned by $wpdb
- Are there risks associated with using wp_options table using wpdb to update theme options
- wpdb get_results() and prepare when to use prepare?