Creat table with therteen month
Posted: Wed Mar 18, 2009 2:09 pm
pickle | Please use [ code=php ], [ code=text ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:
Posting Code in the Forums to learn how to do it too.
I have mad this simple script to retrieve data from myself I want to show the preview 13 month I did manually but I want php to create the table so i don't have to updated next month
Please Help me
____________________
pickle | Please use [ code=php ], [ code=text ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:
Posting Code in the Forums to learn how to do it too.
I have mad this simple script to retrieve data from myself I want to show the preview 13 month I did manually but I want php to create the table so i don't have to updated next month
Please Help me
____________________
Code: Select all
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'beta_insideschools';
mysql_select_db($dbname);
$query = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 1 AND YEAR(createTime) = 2008)';
$result = mysql_query($query) ;
$com = mysql_result($result, 0);
$query1 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 2 AND YEAR(createTime) = 2008)';
$result1 = mysql_query($query1) ;
$com1 = mysql_result($result1, 0);
$query2 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 3 AND YEAR(createTime) = 2008)';
$result2 = mysql_query($query2) ;
$com2 = mysql_result($result2, 0);
$query3 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 4 AND YEAR(createTime) = 2008)';
$result3 = mysql_query($query3) ;
$com3 = mysql_result($result3, 0);
$query4 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 5 AND YEAR(createTime) = 2008)';
$result4 = mysql_query($query4) ;
$com4 = mysql_result($result4, 0);
$query5 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 6 AND YEAR(createTime) = 2008)';
$result5 = mysql_query($query5) ;
$com5 = mysql_result($result5, 0);
$query6 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 7 AND YEAR(createTime) = 2008)';
$result6 = mysql_query($query6) ;
$com6 = mysql_result($result6, 0);
$query7 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 8 AND YEAR(createTime) = 2008)';
$result7 = mysql_query($query7) ;
$com7 = mysql_result($result7, 0);
$query8 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 9 AND YEAR(createTime) = 2008)';
$result8 = mysql_query($query8) ;
$com8 = mysql_result($result8, 0);
$query9 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 10 AND YEAR(createTime) = 2008)';
$result9 = mysql_query($query9) ;
$com9 = mysql_result($result9, 0);
$query10 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 11 AND YEAR(createTime) = 2008)';
$result10 = mysql_query($query10) ;
$com10 = mysql_result($result10, 0);
$query11 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 12 AND YEAR(createTime) = 2008)';
$result11 = mysql_query($query11) ;
$com11 = mysql_result($result11, 0);
$query12 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 1 AND YEAR(createTime) = 2009)';
$result12 = mysql_query($query12) ;
$com12 = mysql_result($result12, 0);
$query13 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 2 AND YEAR(createTime) = 2009)';
$result13 = mysql_query($query13) ;
$com13 = mysql_result($result13, 0);
$query14 = 'SELECT COUNT(*) FROM `SchoolComments`where (MONTH(createTime) = 03 AND YEAR(createTime) = 2009)';
$result14 = mysql_query($query14) ;
$com14 = mysql_result($result14, 0);
?>
<p align="center"><strong>Total School Comments Received</strong></p>
<table width="100%" border="1" cellpadding="2" cellspacing="2" bordercolor="#9999FF">
<tr>
<td bordercolor="#9999FF" bgcolor="#9999FF"><strong>Jan. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Feb. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Mar. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Apr.. 2008</strong></td>
<td bgcolor="#9999FF"><strong>May. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Jun. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Jul. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Aug. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Sep. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Oct. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Nov. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Dec. 2008</strong></td>
<td bgcolor="#9999FF"><strong>Jan. 2009</strong></td>
<td bgcolor="#9999FF"><strong>Feb. 2009</strong></td>
<td bgcolor="#9999FF"><strong>Mar. 2009</strong></td>
</tr>
<tr> <strong>
<td bordercolor="#9999FF"><?echo $com;?></td>
<td><?echo $com1;?></td>
<td><?echo $com2;?></td>
<td><?echo $com3;?></td>
<td><?echo $com4;?></td>
<td><?echo $com5;?></td>
<td><?echo $com6;?></td>
<td><?echo $com7;?></td>
<td><?echo $com8;?></td>
<td><?echo $com9;?></td>
<td><?echo $com10;?></td>
<td><?echo $com11;?></td>
<td><?echo $com12;?></td>
<td><?echo $com13;?></td>
<td><?echo $com14;?></td>
</tr> </strong>
</table>pickle | Please use [ code=php ], [ code=text ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: