Quite a few options you have here but the simplest I suppose would be to change your SQL
query like so:
SELECT
0 AS id,
user_login AS name,
display_name AS tag,
user_status AS status
FROM wp_users;
You can see that now we have the needed order and when you will do the $row['id'] = $i;
assignment we will use that position instead of creating a new key => value
.
Another solution making use of MySQL
user variables:
SELECT
@idx := @idx + 1 AS id,
user_login AS name,
display_name AS tag,
user_status AS status
FROM wp_users
CROSS JOIN
(SELECT @idx := 0) idx;
With the above solution you won’t need to add the PHP
increment mechanism, you will get the id
column already formatted as you need.
Related Posts:
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Using wpdb to connect to a separate database
- Checking if Database Table exists
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How to fetch Data in WordPress using MySQLi or $wpdb
- Connect to database using wordpress wp-config file
- wpdb->insert multiple record at once
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- How to define composite keys with dbDelta()
- Is it possible to define two databases for one installation?
- Does WordPress use the InnoDB engine for MySQL by default?
- WordPress for a very large website
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Huge wp_options table
- “MySQL server has gone away” since update to 3.8
- Error establishing a database connection – with Debug Data
- How to execute mulitple statement SQL queries using $wpdb->query?
- Can I transfer a mysql database to another site?
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Is it safe to convert tables from MyISAM to InnoDB?
- Emojis getting converted to “?”
- Migrating database / content of non-CMS site to WordPress
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- Delete all post meta except featured image Using SQL
- How do I properly update the WordPress database password?
- wpdb_prepare with multiple or condition
- Adding new row to wp_post table
- WordPress Install and Database on separate hosting?
- SQL Error wp_commentmeta – incorrect table definition
- WordPress database error – Error in SQL syntax – I can’t identify any error?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- How do I get the posts within a certain year/date(with sql query)?
- Using GROUP CONCAT in my-sql query with wp_usermeta table
- Data storage for JS app using WP REST API
- Create table from array with prepare
- Migrating from PDO using SQLite to clean new install using MySQL
- Migration: Copying database content to a different server
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- Duplicated site isn’t recognized as a site
- Query multiple tables at once?
- Have working sql query… trying to adjust it to use $wpdb
- Changing root password in PHPMyAdmin for WordPress Database when going live
- How to properly check if a table exists in WordPress Database using Show Tables Query
- Can’t update WordFence Options, clear data manually
- creating new field on mysql
- Remove empty rows from the database
- Custom WordPress Table wpdb
- How and where is wordpress adding mySQL content to database?
- how to encyrpt DB_PASSWORD in wp-config
- SQL query to set posts in bulk based on the post content
- How can I detect right db type?
- How to create more than one new wpdb object?
- Files on Localhost, Database on Server
- Remote database -> massive response time increase?
- access JSON results from wordpress database with wpdb
- Second ezSQL initialization for MSSQL
- Fetch a single row from a custom table for to a given ID
- Database create or redirect
- Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
- Cloning blog to localhost via WAMP
- Counting post and changing roles in mysql database. Query not code
- How to escape percentage sign(%) in sql query with $wpdb->prepare?
- DB prefix not updating
- Whats the best practise on how to store json data from a custom settings page?
- Recovery – Restore Database after moving folder location locally
- Replacing javascript link in WordPress database without getting mysql syntax errors
- How to edit custom table data in frontend
- local wordpress broke after changing URL
- how to access 2nd Mysqli Database from different server for wordpress
- Error establishing a database connection – WordPress setup, everything else is working
- How to check and get json object in WP database?
- Exporting Post ID, Post Title, Primary Category and Primary Category ID
- Insert JSON output into WordPress Database
- How to map data on CSV to web pages?
- How to create index (sql) to a meta_key?
- Search and Replace in Windows XAMPP site
- WPCLI search and replace in a particlar site dir effect another site-dir
- How can i syn wordpress user table with a stand-alone php script?
- insert data from a form:: Warning Empty query mysqli::query()
- How can I get $wpdb to show MySQL warnings?
- After renaming MySQL database, I can no longer access my Blog page
- WordPress Database Posts Table query
- Hang Up Followed By Can’t select database
- How to extract some part of WordPress full source code
- Mysql Queries per Visit – Crazy High
- Why is converting my database to UTF-8 truncating entries?
- using same mysql user with many databases
- Why are my WordPress post queries so slow?
- How to back-up a database on IIS
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- export individual posts to text files or a single csv file
- Custom wordpress SQL statement for a website
- WordPress database connection failed, while mysql client is working [closed]