Re: Automatic Colspan from database data

Hi! Well I have 12 table for 2 years which makes it 24 tables named as: jan_2002, feb_2002 ...etc dec_2002 jan_2003, feb_2003 ...etc dec_2003 Each table has fields according to the number of days in the month plus 1 field as a unique key. Each registration will create 1 entry in 24 tables each and it can only be modified as 1 entry per registrant per table. the fields in each table will take values ranging rom 1-20. Well that's all about how my tables are in the database. Thank You for your time Dhaval Desai

From: Marco Tabini <marcot@tabini.ca> To: Dhaval Desai <da_linuxguru@hotmail.com> CC: php-general@lists.php.net Subject: Re: [PHP] Automatic Colspan from database data Date: 09 Nov 2002 13:34:20 -0500 How is your database organized? you might be able to pull this information from the query by using an appropriate group-by clause. Marco -- ------------ php|architect - The magazine for PHP Professionals The first monthly worldwide magazine dedicated to PHP programmers Check us out on the web at http://www.phparch.com On Sat, 2002-11-09 at 11:57, Dhaval Desai wrote: Hi everybody! Well this is how it goes... For the month of January there are 31 days... so there are 2 rows in this table on the top row there are 31 columns showing 31 days...and in the row below this one we will have to generate....colspan based on the below information pulled from the database... 2222211111111111111999999992222 in the above case we will have to get a colspan as follows: <tr>

     <td colspan="5"> 2 </td>
     <td colspan="15"> 1 </td>
     <td colspan="8"> 9 </td>
     <td>colspan="4"> 2 </td>

</tr> This is all I want to do....I know it is difficult...but still waiting for some genius! Thank You! Dhaval _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail