Jump to content

Database Schema


Go to solution Solved by Barand,

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. 

Edited by glendango
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • 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.