My dilemma: I want my web page (not a blog) to display products from my "SQL table that was created with phpMyAdmin." It should show the "product name," "product image" and "product price."
My host is "Hostgator."
WP version: 3.3.1
The SQL database in Cpanel has been created.
I've created a user and gave the user "all permissions" to modify the table.
My database table is: "wp_prod_table."
The wp_prod_table has 11 records (rows) of info ready to be queried.
Wordpress Theme: “a simple love.” - child theme of “Thematic."
I want to be able to query the table by using the product ID (which is the affiliate publisher's part number for the queried product) and call for the "product name, price, and image URL. to be displayed within a div on the web page.
I've read the Codex on interfacing with the database but I must have not read it correctly - or what am I missing? I don't know how to query the table. I've entered the php code in my web page but that clearly doesn't work. So how do I query the table and show the results within a "div" on my web page? It's like being on one side of a river without a bridge to the other side How do I build a bridge to gain access to the database, query the info in the table, and then have it show up on my web page? - Yet another mountain to climb.
I’m familiar with html and css but have not worked with PHP. I don’t know if I need to create another php file, separate from the php files that are already included in the WordPress theme , or if there are certain WordPress php files I need to use.
Any help would be greatly appreciated.