flyingeagle855
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by flyingeagle855
-
-
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.
Change Values in a MySQL Array?
in PHP Coding Help
Posted