hi,i have create registration form using chronoforms.i have relation table between jos_user and table containing the other data that create using chronoforms on cf_user_id.
so,my problem now to retrieve data from both table and user can update that data.
i have search around this forum but not found any tutorial how to using profile plugin.
i thinks this is my step to display data using profile plugin,its correct or not..if i wrong correct me
1.create new form to retrieve data from database and save.
2.tick the from and click profile page.
3.fill the information for the profile page.
4.insert the select query like this $query = 'SELECT u.username AS username, u.email AS email, c.cb_schoolloyalty AS school FROM #__users AS u LEFT JOIN #__comprofiler AS c ON (u.id = c.user_id) WHERE u.id = ' . $user->id';(but i don't know where to insert this query).
5.insert <?php echo ... ?> on html code
6.insert update query(don't know where to insert this query)
so,my problem now to retrieve data from both table and user can update that data.
i have search around this forum but not found any tutorial how to using profile plugin.
i thinks this is my step to display data using profile plugin,its correct or not..if i wrong correct me
1.create new form to retrieve data from database and save.
2.tick the from and click profile page.
3.fill the information for the profile page.
4.insert the select query like this $query = 'SELECT u.username AS username, u.email AS email, c.cb_schoolloyalty AS school FROM #__users AS u LEFT JOIN #__comprofiler AS c ON (u.id = c.user_id) WHERE u.id = ' . $user->id';(but i don't know where to insert this query).
5.insert <?php echo ... ?> on html code
6.insert update query(don't know where to insert this query)
This topic is locked and no more replies can be posted.
