Report section

[smart]

Hi

 

Can you get the products purchased and the best viewed products lists in the Report section,

back to zero for each product, so I can see what new people do when they visit the site.

 

 

 

Thanks <_<

[RyanSmith]

Hi

 

Can you get the products purchased and the best viewed products lists in the Report section,

back to zero for each product, so I can see what new people do when they visit the site.

Thanks <_<

<{POST_SNAPBACK}>

 

UPDATE products_description SET products_viewed = 0;

 

that will reset the products viewed report.

 

UPDATE products SET products_orders = 0;

 

That will reset the products ordered report.

 

I think both those should work fine.

[smart]

Thanks

 

Ryan

 

were is products SET products_orders

[RyanSmith]

Thanks

 

Ryan

 

were is products SET products_orders

<{POST_SNAPBACK}>

 

 

I'm not sure that I understand your question.

 

If you asking where to run this, it's a query against the database. If you don't know how to get into your db admin, you need to open up the mySQL prompt. Also many people also use phpMyAdmin to control their database, however I haven't used this tool as I perfer to just enter my queries in the command line.

 

Let me know if you need more information.

[smart]

Thanks Ryan

 

I can use phpMyAdmin - even I am new to it?

 

I'm not sure that I understand your question.

 

So how do you enter my queries in the command line.

 

PS. I like you flash website

 

Thanks

[RyanSmith]

Thanks Ryan

 

I can use phpMyAdmin - even I am new to it?

 

I'm not sure that I understand your question.

 

So how do you enter my queries in the command line.

 

PS. I like you flash website

 

Thanks

<{POST_SNAPBACK}>

 

Ya, I'm not sure how you run a direct query against a database using phpMyAdmin, but I'm sure that it's possible. I bet 75% of the people in these forms could tell you, hopefully someone will read this and answer, or you can just open it up and look around. Find a place where you can select the database then there should be a place to run a query and you can just use the previous code I sent you.

 

UPDATE products_description SET products_viewed = 0;

UPDATE products SET products_orders = 0;