Bharat  Bhushan

Bharat Bhushan

  • NA
  • 176
  • 158.8k

Help me in a graph

Sep 5 2011 8:34 AM
have two tables

1. tb_data with the following column
see this link

http://www.bd.bloodbankbdcnsr.org/tb_data.jpg

2. tb_strek with the following column
see this link

http://www.bd.bloodbankbdcnsr.org/streak.jpg


I need the following Chart
see this link
http://www.bd.bloodbankbdcnsr.org/chart_.jpg

when inside the column tb_strek there is a streal value >= 10 of any topic of

a user then i need the date  when he  completed the chapter or topic.
see the detail of the user inside the tb_data

http://www.bd.bloodbankbdcnsr.org/tb_data.jpg

and if the user not work on any date . this date is not available inside the

database.then i want to show that there is no work .you can see the straight

line inside the graph .

http://www.bd.bloodbankbdcnsr.org/chart_.jpg.

this image show that the 1st chapter completed by the user at first day and

second chapter is completed by the user at 8th day and so on.

Please help me. i need sql query and help to create a graph



can anybody help me.....
Thankx...