|
Author |
Message |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Tue Nov 09, 2004 11:16 am (19 years, 5 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Hi all,
I have been having some problems with thinking of the most efficient way to store graph data in a mysql database.
I want to store one graph data with the x access = (0h to 23h) and the y axes = (0 to 9). I want the user to input:
(whatever eg 3) for 0
(whatever eg 4) for 1
(whatever eg 9) for 2
(whatever eg -) for -
(whatever eg 7) for 23
This data is to be linked to the person and date (eg bob gave the score 7 at 23:00hrs on Sunday the 23 June)
I want to query the graph data and plot a trend (of a specific value say 7) over say the last 12 months and display the data in graph form.
I can think of ways to implement this, but the database structure that I have thought of does not lead to an efficient database.
It is the time factor that I am having problems with. I can not decide if I should encode the graph data "in a string and store it in the database" and have some algorithm to plot the data on the graph or store the entire graph with data in its entirety. The latter option would probably be easier for the database structure, but would provide lots of duplicated data.
Could some point me in the direction of a similar database structure, or a database that acts in this way.
I would be very grateful, Thanks in advance,
Dominic |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Vitopa
Junior WebHelper
![Junior WebHelper Junior WebHelper](images/rank_1.gif)
Joined: 26 Feb 2015
Posts: 12
Location: Ellicott City, Md.
|
Posted:
Sat Jul 11, 2015 8:40 pm (8 years, 9 months ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
I am Joy new to this forum I really need a help,
I have a mysql table
Field Type
match_id, int10
match_date, date
match_time, time
match_round, int10
home_team, varchar50
away_team, varchar50
prediction, varchar50
home_score, int3
away_score, int3
form, varchar50
and I am trying to retrieve data as the query mentioned below,
PHP Code: |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Vitopa Find all posts by Vitopa](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) ![Send email Send email](templates/4WebHelp2/images/lang_english/icon_email.gif) ![AOL Instant Messenger AOL Instant Messenger](templates/4WebHelp2/images/lang_english/icon_aim.gif) ![Yahoo Messenger Yahoo Messenger](templates/4WebHelp2/images/lang_english/icon_yim.gif) ![ICQ Number ICQ Number](templates/4WebHelp2/images/lang_english/icon_icq_add.gif) |
![](images/spacer.gif) |
|
|
You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot edit your posts in this forum. You cannot delete your posts in this forum. You cannot vote in polls in this forum.
|
Page generation time: 0.117264 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0
© 2001, 2002 phpBB Group :: Based on an FI Theme
| |