Search results

  1. H

    radio list loading without selected default value

    I have a table with id and points. id points 1 10 2 20 3 30 i am using below code to generate radio list in Eval populate. here issue is radio list loading without selected any value. i need to select id (2) as default value every time form loads. how to do it...
  2. H

    How to use variable in Mysql WHARE Clause

    yes. its working. thank you so much. i have another requirement . that is i have a form with a field element with label of student id and another drop down element called subject. this student id field automatically get its value from browser URL. my requirement is when loading this form, the...
  3. H

    How to use variable in Mysql WHARE Clause

    WHERE name = '".$user ."' is not working without defining $user. so where to define $user to work it. or how to use {tablename___elementname} in (WHERE name = '".$user ."' ).
  4. H

    set default selected option in Eval populate

    how to use below code for radio list with default selected option in dropdown > advanced > Eval populate. $db = JFactory::getDbo(); $db->setQuery('SELECT id, text FROM #__tablename'); $rows = $db->loadObjectList(); foreach ($rows as $row) { $options[] = JHTML::_('select.option', $row->id...
  5. H

    How to use variable in Mysql WHARE Clause

    I use the following code to filter dropdown menu in 'Joins where and/or order by statement (SQL)' section. but it is not loading. $user =& JFactory::getUser(); WHERE name = '".$user ."'
  6. H

    Sql limit not working

    I am trying to get 2nd last record using below code in 'Default' option. but it outputs the last record not 2nd last record. what is the issue? $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('name')->from('mytable')->order('id DESC')->setLimit('1,2')...
  7. H

    Show/Hide a form field depends on other field's value

    I did it after go through your link. Thank you so much.
  8. H

    Dropdown list items from two tables

    I could not understand the code on your page. so pls give me the code for my above requirement. Thanks.
  9. H

    last updated data as default value

    Ok. Thank you so much.
  10. H

    Show/Hide a form field depends on other field's value

    Table A got 4 form items ID Status Name Age (here Status as radio button in the form) If form of Table A loads only ID & Status are visible. Status has two options (Yes/No). If we select Yes from Status, It will show Name & Age. If we select No from Status, It will hide Name & Age. How to...
  11. H

    Dropdown list items from two tables

    I have got three tables Table 1 ID Name 1 John 2 Paul Table 2 ID Name 1 Ricky 2 Waugh Table 3 has a dropdown. that dropdown should load name from both Table 1 & Table 2. How to do it?
  12. H

    last updated data as default value

    Fantastic! Its working. Thank you so much hugh...
  13. H

    last updated data as default value

    Thanks it is working for only field. but not working for dropdown box and radio buttons. any changes in the code should be done for those?
  14. H

    last updated data as default value

    my form got 2 fields. 1. ID 2. Name Stored data as folows ID Name 001 John 002 Alan oo3 Michel What i want is when i update a new record, the last updated data values (003 Michel) should automatically load in my form as default values in respective fields.
  15. H

    last updated data as default value

    I have a form with a field. I need to load last updated data to that field as default value, each time form submitted. How to do it?
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top