flyingeagle855 Posted October 27, 2006 Share Posted October 27, 2006 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 Optionif ($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. Quote Link to comment Share on other sites More sharing options...
btherl Posted October 27, 2006 Share Posted October 27, 2006 I don't recognize the database interface you are using.Can you give us a sample of what var_dump($rows) looks like? Or an example of how to access the result set? Quote Link to comment Share on other sites More sharing options...
flyingeagle855 Posted October 27, 2006 Author Share Posted October 27, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.