MySQL queries in WordPress

I found the errors thanks to the help from @Milo

@Milo’s query on catno pointed me to my error with my first query involving catno, and I also noticed a double equals in $catno == $row[0]; when it should be $catno = $row[0];

Final coding is

function QueryStock($cat) {
    $query = "SELECT * FROM stock WHERE catno = '$cat'";
    global $wpdb;
    $row = $wpdb->get_row($query, ARRAY_N);
        $catno = $row[0];
        $itemname = $row[2];
        $price = $row[4];
        $stock = $row[5];

    echo "There are " . $stock . " bears, the price of each bear is £" . $price;
}

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. Custom query to get post names beginning with a digit
  5. WordPress get pagination on wpdb get_results
  6. Ajax $wpdb not returning table data
  7. Converting MYSQL to WordPress $WPDB
  8. Why is variable not working on custom sql query using wpdb?
  9. Show MySQL errors that occur when I excute $wpdb->insert()
  10. Can’t get wp_insert_post to work
  11. WSoD being caused by this piece of code
  12. I want to select the from values from database in WordPress? [closed]
  13. Update results, Before deleting the related category [closed]
  14. wp query foreach deleting record returning only first or last item
  15. Database query works fine outside WordPress
  16. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  17. $wpdb->insert() does not Insert record in a table
  18. Help with a $wpdb MySQL Query
  19. Custom array from a query only write the last row of the query
  20. $wpdb returns duplicate posts
  21. Mixing variables into an array when inserting values
  22. Use $wpdb or other PHP script method to find/replace in WP database
  23. How can I add a new row in a separate database when someone registers via WordPress?
  24. Basic wpdb update question
  25. I can’t update my data through $wpdb
  26. Output: “Array”
  27. How to use mysql LIKE with wpdb?
  28. How do I prepare strings for insertions as values into a MySQL table?
  29. How to use AJAX in WordPress in MYSQL query?
  30. form $_post action value gets truncated after it passes through two forms
  31. Why won’t this wpdb get_results query return results?
  32. WPDB secure custom form
  33. Add row to custom database Table and delete all rows older than 1 day
  34. select a single val though a table in wordpress
  35. populate select options from extra mysql table data
  36. Query the links Database
  37. MySQL Query Returns Array () In Shortcode
  38. Passing in MySQL prepare statement parameter separately throwing error
  39. Convert a column of a table containing an Array as response in HTML
  40. Database SQL query error
  41. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  42. Conditional formatting on data fetched from MYSQL
  43. What is the correct way to search 3 custom fields only in WordPress?
  44. Using wpdb to connect to a different database is not working
  45. Rewrite SQL query as a prepared statement and use in foreach loop
  46. Advanced WordPress SQL Query
  47. MySQL query in WordPress with AJAX
  48. Passed variable gets undefined variable error on insert on next page
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. MySQL “Or” Condition
  55. How to validate WordPress generated password in DB using PHP?
  56. wpdb::prepare was called incorrectly
  57. How To Make Connection To WordPress Data Base In A Plugin?
  58. How to track a users progress through pages by inserting data into WordPress Database?
  59. the_author_meta not working
  60. PHP syntax error when using wpdb update?
  61. “The plugin generated 2694 characters of unexpected output…” on Plugin activation, CREATE TABLE sql command not working
  62. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  63. mysqli_real_connect() – authentication method unknown to the client Warnings
  64. Do I need to prepare query before get_results(), get_row() and get_var()?
  65. How to create and work with custom data / tables (i.e., for arbitrary data)?
  66. Get stock by custom meta field on all Woocommerce variable products
  67. Display fields as values in array from external SQL DB
  68. Getting id of poll from WP database
  69. User management system similar to wordpress one?
  70. SQL Injection blocked by firewall
  71. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  72. Long running queries
  73. Moving wordpress site from localhost to live server using GoDaddy cPanel
  74. WordPress Block developer from exporting Database via PHP
  75. Querying Database with wpdb
  76. How do I display offsite database info on my wordpress site?
  77. Wpdb->insert() doesn’t insert new row after the last one
  78. Issue with fetching mysql data and displaying results via shortcode in webpage
  79. Custom route and query
  80. How to insert wp_users ->user login name to wp_terms when a new user registering?
  81. Edit Account – read and write to MySQL
  82. $wpdb->get_results breaking page?
  83. Why when I create a new post I found 2 record related to this post into the posts database table?
  84. mySQL queries are executed twice on wordpress website
  85. Most viewed posts in WordPress
  86. SQL error with custom query
  87. WordPress get last inserted user id
  88. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  89. Get mysql data for Quick Edit panel
  90. Change upload URL by mime type
  91. Unexpected behavior when trying to manually install WordPress on macOS Sierra
  92. WordPress post insertion from PHP file
  93. How to return count of items found in SQL query
  94. Include a custom field in mysql query
  95. Get null from POST
  96. How to pass username into form that sends data to database
  97. Insert into db with foreach problem
  98. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  99. inner-wrap div pushing custom table far down on page
  100. running an existing WordPress site from Visual Studio Code?