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. Link to comment https://forums.phpfreaks.com/topic/25261-change-values-in-a-mysql-array/ 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? Link to comment https://forums.phpfreaks.com/topic/25261-change-values-in-a-mysql-array/#findComment-115190 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. Link to comment https://forums.phpfreaks.com/topic/25261-change-values-in-a-mysql-array/#findComment-115342 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.