Forums

Using while loop for manage item display

umanda 28 Jun, 2010
hello

I am using ChronoConnectivity and I am trying to display some form values. Of course no problem I can display that particular data by using ChronoConnectivity. but I need to display those data in two column.Actually those data containing Names.I need to put those name according their First name A to M in first column and N - Z names are second column

ex-


|Column A | Column B |

| A | N |

| B | O |

| C | P |

| . | . |

| . | . |

| M | Z |


I am try to use while loop for it.

<?php
//tabela select
$query2     = "SELECT * FROM `#__chronoconnectivity`" ;
$count = 1;
$column = 1;
//loop statement
while ($myrow = mysql_fetch_array ($query2))
{
// first column display
if ($column == 1)
{
//field is the column in  table

printf('<div id="agency" class="agencylist"><a href="http://74.54.206.217/~oakpark/index.php?option=com_chronoconnectivity&connectionname=agencydet&cat_id={cf_id}">',$myrow['{text_2}</a></div>']);
//printf();
}

else{
//second column display 
printf('<div id="agency" class="agencylist"><a href="http://74.54.206.217/~oakpark/index.php?option=com_chronoconnectivity&connectionname=agencydet&cat_id={cf_id}">',$myrow['{text_2}</a></div>']);
}

$count += 1;

$column = $count % 2;
}
//loop end
?>



I put this code block at under Body: in Connection View Settings.
So result is this error massage.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /../components/com_chronoconnectivity/libraries/connection.php(303) : eval()'d code on line 10

Ok I am agree with you here in my code I had lot of mistake.ok If can tell me either very better way to achieve this my requirement or other proper solution I am so glad.

cheers.

Umanda Jayo Bandara
GreyHead 28 Jun, 2010
Hi Umanda,

Basically you can't do this. ChronoConnectivity is designed to create a single column only and you can't over-rule the ChronoConnectivty code from the Body box.

You could possibly do this with a customised ChronoForm.

Bob
umanda 28 Jun, 2010
thank you very much for your instance reply. but I need to do this.OK no problem I am agree with you.
Yes I also think should be customized ChronoForm. OK But I am fear to take this risk, but you can help me because I think you already know my issue and I hope you an help me to correct customizations on ChronoForm.It of course very helpful and thankful.

Thank you very much.
Cheers
Umanda
umanda 29 Jun, 2010
could you help me please...?
GreyHead 29 Jun, 2010
Hi umanda,

Sorry, it's quite a complex piece of coding abd I simply don't have time.

The best answer is still not to use this layout.

Bob
umanda 29 Jun, 2010
ok thank you very much....for your help.....
This topic is locked and no more replies can be posted.