filter the information

Thank you for chronoconnectivty
I've created a table. I need to filter the information by user name. table contains the user name.
where and what do I write(mysql code)?

Hi asabikertenkele,

There is a 'WHERE' box in the ChronoConnectivity setup - you can add filters directly there; or you can create a 'filter form' in the header section and use the results of that to create a more complex 'WHERE' clause. There are several examples in the forums here.

Bob

thanks. I'll call forums.
I'm using chronoform for forms. nickname in a column is available. (to record the user name.) this HiddenField on the form. How do I make the user's name into the HiddenField?

Hi asabikertenkele,

Try this

<?php
if ( !$mainframe->isSite() ) { return; } 
$user =& JFactory::getUser();
?>
. . .
<input type='hidden' name='username' value='<?php echo $user->username; ?>' />

Bob

ok. I'm trying now. Thank you for your very quick and helpful response.

Hi asabikertenkele,

Sorry, there was a '{' missing in my code - I've fixed it now.

Bob

ok!

works nice. Thanks

Ah ha, I needed this. Thanks so much for posting!

Just as I'm about to give up, I found the answer to my plight. thanks for this post!

Work great. THanks you so much

Wow.. you guys are so helpfull.
Thanks! Now I have some things to try out.