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. Fatal error: Call to undefined function mysql_connect()
  55. Insert post without actions/hooks
  56. Import 10,000 Users into WordPress WITH a specific ID for each user
  57. Custom Plugin For Converting CSV To MySQL
  58. $wpdb->wp_users returning empty value for
  59. Using custom tables for old posts
  60. Multiple meta_key in one global $wpdb;
  61. WordPress member notification
  62. Moving wordpress site from localhost to live server using GoDaddy cPanel
  63. How does WP work in conjunction with a web server?
  64. Location of core code for database connection and get_header
  65. Wpdb->insert() doesn’t insert new row after the last one
  66. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  67. Most commented posts by time period (last 12h, last 24h and etc)
  68. How to get specific attribute from DB
  69. Hide posts if user is added to it WP_query
  70. How to unserialize data from MySQL
  71. PHP -> SQL Query with Summing
  72. How to insert wp_users ->user login name to wp_terms when a new user registering?
  73. Known Issues in WordPress When Upgrading PHP to ver 7
  74. Change MySQL PDO connection to a WPDB connection
  75. $wpdb->get_results breaking page?
  76. Get the id of the row from database on click of a button [closed]
  77. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  78. SQL error with custom query
  79. Modify WooCommerce used to get all orders in dashboard
  80. WordPress SQL Prepare
  81. Weird fonts showing which are coming from database
  82. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  83. WordPress Bad Request Error 400
  84. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  85. cant insert data in a custom table in phpmyadmin
  86. autocomplete in wordpress using ajax with json-data
  87. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  88. Query doesn’t display text data with apostrophes
  89. I want show only data for today
  90. SQL Query Search page
  91. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  92. At what point during a typical request does the $wpdb object become available?
  93. Let users register weight each day and save it in DB
  94. Fetching wpdb data from a php file seems to break?
  95. posts_clauses drop ACF get_field function
  96. Execute multiple PHP Snippets causes error?
  97. use wpdb object on other file
  98. Warning: Undefined property: wpdb::$question_overview in C:\Wamp.NET\sites\proxyvragenmodule\wordpress\wp-includes\class-wpdb.php
  99. what to do after instlling cyberpanel on VPS
  100. Trying to GET data with ajax from database and show in fullcalendar