Support » Fixing WordPress » query a product list from mysql

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator justingreerbbi

    (@justingreerbbi)

    Forum Moderator

    Look into $wpdb

    Then you can use the class to do a SQL query

    Exmaple:

    global $wpdb;
    $results = $wpdb->query(SELECT * FROM table_name WHERE blah blah bah);

    Then you can return the object just like you would a normal MySQL query (as object and not array)

    okay, I’m not too familiar with this. This is an example of what I want to do

    http://www.mivila.com/products.php

    they list the product categories then you can click on one and it lists the items in that category. I’ve made a new table in mysql database called plist and I uploaded the CSV file.

    I don’t really know what to do from there

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘query a product list from mysql’ is closed to new replies.