You should not use mysql_fetch_array()
Use wordpress built-in functions, like this:
$SQL = "SELECT * FROM pt_country ORDER BY name";
$rows = $wpdb->get_results( $SQL );
foreach($rows as $r){
print_r($r);
}
Related Posts:
- How to return number of found rows from SELECT query
- Can i use php sql functions instead of $wpdb?
- $wpdb->delete column values IN ARRAY()?
- Custom query to get post names beginning with a digit
- WordPress get pagination on wpdb get_results
- Ajax $wpdb not returning table data
- Converting MYSQL to WordPress $WPDB
- Why is variable not working on custom sql query using wpdb?
- Show MySQL errors that occur when I excute $wpdb->insert()
- Can’t get wp_insert_post to work
- WSoD being caused by this piece of code
- I want to select the from values from database in WordPress? [closed]
- Update results, Before deleting the related category [closed]
- wp query foreach deleting record returning only first or last item
- Database query works fine outside WordPress
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- $wpdb->insert() does not Insert record in a table
- Help with a $wpdb MySQL Query
- Custom array from a query only write the last row of the query
- $wpdb returns duplicate posts
- Mixing variables into an array when inserting values
- Use $wpdb or other PHP script method to find/replace in WP database
- How can I add a new row in a separate database when someone registers via WordPress?
- Basic wpdb update question
- I can’t update my data through $wpdb
- Output: “Array”
- How to use mysql LIKE with wpdb?
- How do I prepare strings for insertions as values into a MySQL table?
- How to use AJAX in WordPress in MYSQL query?
- form $_post action value gets truncated after it passes through two forms
- Why won’t this wpdb get_results query return results?
- WPDB secure custom form
- Add row to custom database Table and delete all rows older than 1 day
- select a single val though a table in wordpress
- Query the links Database
- MySQL Query Returns Array () In Shortcode
- Passing in MySQL prepare statement parameter separately throwing error
- Convert a column of a table containing an Array as response in HTML
- Database SQL query error
- MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
- Conditional formatting on data fetched from MYSQL
- What is the correct way to search 3 custom fields only in WordPress?
- Using wpdb to connect to a different database is not working
- Rewrite SQL query as a prepared statement and use in foreach loop
- Advanced WordPress SQL Query
- MySQL query in WordPress with AJAX
- Passed variable gets undefined variable error on insert on next page
- MySQL queries in WordPress
- Using the same shortcode to show any table from the database
- MySQL database migration to WordPress
- Error resetting database index using ALTER TABLE in $wpdb->query
- Putting form result in my database
- How can I update a value of a field depending on outside source?
- dbDelta support for FOREIGN KEY
- How to correctly submit a search form and display the result in an independent page
- Does WordPress cache get_user_meta() results?
- Using Echo in ShortCode – Stuck
- No wp-config.php file on local install of wordpress – site still displays
- Use ajax to update_post_meta
- What SQL / WordPress queries would need a nonce?
- Different database query in function.php using mysqli
- Call External Object in Class Function During Callback
- How to securely provide a $_POST var in WP_Query with PHP 7?
- How to display data from custom table in wordpress phpmyadmin
- How WordPress reacts to a lack of memory of the server [closed]
- Replacing mysql_escape_string in a custom plugin when moving to PHP7
- Weird 404 URL Problem – domain name being placed at end of urls
- database sent to a JSON file
- WordPress SQL injection
- multiple where condition in result query
- Grouping posts by a custom meta value
- Can’t update multiple rows with $wpdb query
- wpdb prepare insert table doesn’t work
- Delete database record using plugin from admin panel
- Wpdb get->results to out the the month from the db
- Live search from database table
- Why my query does not run with prepare
- wpdb getting avatars and author url
- phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
- WordPress SQL JOIN query
- Please help! I have a problem with getting wordpress databas
- How to run complex query using PHP
- Creating multiple tables with Plugin
- Can I split a huge wp_postmeta table across different databases or servers?
- WordPress mysql deos not work with php7
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- WP + MySql db / PHP
- The plugin generated 225 characters of unexpected output during activation
- append data to mysql table via submit button coded in php – not working
- WordPress select query issue
- How to do a MySql query in WordPress?
- Add two or multiple functions in WordPress Post or Page
- Send data from plugin to external database
- How to set max users to 17.000
- directorypress theme error mysql_error() [closed]
- Querying multiple meta_keys in WordPress SQL query
- Cannot Upload Custom Header Image into WordPress Dashboard
- Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
- inner-wrap div pushing custom table far down on page
- running an existing WordPress site from Visual Studio Code?