Hi!
Well let's make it simple.. We can see that the following values: 2222211111111111111999999992222 are stored in just one row in 31 different columns. Bsaed on this if we were to make a table with colspans how would it go..? Thank you Dhaval
From: Marco Tabini <[EMAIL PROTECTED]>
To: Dhaval Desai <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP] Automatic Colspan from database data
Date: 09 Nov 2002 15:10:39 -0500
Ouch...
well, assuming you have two columns: day_id and value, here's a possible
solution:
$rs = mysql_query ('select day_id, value from my_table order by
day_id');
$a = mysql_fetch_assoc ($rs);
do
{
$i = 1;
$control = $a['value'];
while (($a = mysql_fetch_assoc ($rs)) && $a['value'] == $control)
$i++;
echo '<td colspan=' . $i . '>' . $control . '</td>';
} while ($a);
This is a bit rough and can probably be optimized quite a bit, plus I
can't test it, so I'm not sure that it will work the first time.
Hopefully, it gives you an idea of how it could be done.
If I could make a suggestion without knowing how your system works, I
think you should revisit your database design a little.
Hope this helps,
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 14:32, Dhaval Desai wrote:
> 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 <[EMAIL PROTECTED]>
> >To: Dhaval Desai <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
