I'm stumped. I'm not so sure what is the answer to your question. I'll do some Googling and get back to you if I got an good answer. You should email the people at iPage as they probably could give you an answer..
I'm strugglling because I'm not sure what all the syntax means in that sql statment, the use of "." and the what p and pd and l all mean?..
I now have.
$products_query_raw = "select p.products_id, pd.products_name, pd.products_viewed, l.name, c.category_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_LANGUAGES" l, "TABLE_PRODUCTS_TO_CATEGORIES" c where p.products_id = pd.products_id and l.languages_id = pd.language_id, p.product_id = c.product_id order by pd.products_viewed DESC";.
But it gives me the error..
Check out URCHIN reporting. I'm not sure how you would integrate that but some OSC sites works with that...
Got an answer for you: p.product_id and c.product_id are non-existent, you forgot an 's' in both cases..
So what is left is:.
[CODE]select count(*) as total from products p, products_description pd, languages l, products_to_categories c where p.products_id = pd.products_id and l.languages_id = pd.language_id and p.products_id = c.products_id.
And that's does the job.....
I've been asked to extent the reports section of the site.
So that I can look at the products hits in terms of the gender of the customer,.
I'm a bit confused though where to start.
I have male and female categories so I could try to count the number of hits by gender by going the the number of hits on that category.
I could use the number of hits on a product depending on what category it's on, draw back being that either gender is able to the oppisites genders category if they wish, thus making the results merely a compilation of hits per category (if there's a contrib for counting categopry hits please let me know).
Or more accurately I could extract the gender from the user account and use that to select the hits results for each gender on the site. The drawback being then that unregistered user hits would not count..
I could just modify the hits counting page so that it only showed hits by category that might be the easiest way of manipulating/analysing information...
Right here is the sql that gets products (please help I as am not familiar with the use of "." in sql statements).
$products_query_raw = "select p.products_id, pd.products_name, pd.products_viewed, l.name from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_LANGUAGES" l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC";.
Now I've also find a table that stores products id alongside categoriy id called products_to_categories,.
What I am trying to do is pull out the number of product views for each product, but only for a specific category. In my case male category cPath=32 femal cat, cPath=33, I really only need to show them for male and female, so i'm thinking I'd just produce 2 pages and hardcode in the category id for viewing on each page...