using phpmyadmin functions

I am writing some queries where my client can see the stats for the day , week, month, and year.
Is there a way were i can query my phpmyadmin program and have it display the results on my site.. ?

I have a hosting compnay where the files i located...

How do i send my queries to phpmyadmin and have it display the results on my site ?


Also, how do i modify this query -->

$banner_check_query = tep_db_query("select count(*) as count from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . (int)$banner_id . "' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')");

I just want to write a query where if today is wednesday, it shows you results from SUNDAY TO Wednesday.

if today is friday it shows you results from sunday to friday.....Thanks.

Who is Participating?
virmaiorConnect With a Mentor Commented:
while you can see all of this in PHPmyAdmin...
it seems like it would be wiser just to write a page that does this for them.
since you would have to pretty much spend more time destroying phpMyAdmin's functionality than it would take to write what you describe.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.