Jump to content

Database Schema


Recommended Posts

Hi..  I have a database which works fine. I ve just started using google charts to make the results look better for the U.Experience. .


The example tables are very basic like:


Country       Visits


England         4

Usa                6

Brazil            3



I  get all my results form where statements so I have no tables which actually count the entries and show them in a basic table like this.


My question is :  Should I be using where, count()   etc  statements to populate the charts or should I have mini tables in my schema that present the information neatly like the above or a counter next to the id of the user/country etc e.g. so I don't need to worry about statements in the chart code....


thx for reading. 

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.