using phpmyadmin functions

Posted on 2005-05-04
Last Modified: 2006-11-18
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.

Question by:lucilue2003
    1 Comment
    LVL 20

    Accepted Solution

    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.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This is a general how to create your own custom plugin system for your PHP application that you designed (or wish to extend a third party program to have plugin functionality that doesn't have it yet).  This is not how to make plugins for existing s…
    Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit ( and similar technologies have enjoyed wide adoption, making it possib…
    The viewer will learn how to count occurrences of each item in an array.
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now