Jump to content

flyingeagle855

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

flyingeagle855's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I probably should have explained that I am a developing a module for Joomla! CMS www.joomla.com thier site can explain better then I can about the database interface. Also the section on PatTemplate.
  2. I am stuck on something here and need some help. What I am looking to do is take and array of some values that I pulled from a MySQL database query and then I need to loop though the aray and look at CB.AVATAR for reach record and do an "if" statment to look at the value and then change the record if needed. [code] $query = "SELECT DISTINCT users.id, users.username, cb.avatar"; // Display Users Real Name Option if ($display_realname != "0"){ require_once($mosConfig_absolute_path . '/administrator/components/com_comprofiler/ue_config.php'); if ($ueConfig['name_style'] == "1"){ $query .= ", users.name"; }elseif ($ueConfig['name_style'] == "2"){ $query .= ", cb.firstname, cb.lastname"; }elseif ($ueConfig['name_style'] == "3"){ $query .= ", cb.firstname, cb.middlename, cb.lastname"; } } if ($aboutme != "") { $query .= ", cb.". $aboutme." as aboutme"; } $query .= ' FROM #__users as users, #__comprofiler as cb, #__session as session WHERE users.id = session.userid and users.id = cb.id'; $database->setQuery($query); $rows = $database->loadObjectList(); [/code] Then latter in my code I push the array to patTemplate that automaticly goes through the array and iserts the fields I want to display.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.