Array Help

PHP
1

I think i’m just array brain dead today… I need my redbull

I’m trying to get my results into an array


$RetrieveAffID=mysql_query("
select 
	a.uid as UserSessID,
	b.field_name as FieldName,
	a.value as FormValue,
	b.gname as gName

from form_values a join form_fields b on b.id=a.fID where uid='46f96aa0780383a7ba1a6aba58cbbea7'",  $db);
while ($AffResults=mysql_fetch_assoc($RetrieveAffID))
{

print_array($AffResults)

Array
(
    [UserSessID] => 46f96aa0780383a7ba1a6aba58cbbea7
    [FieldName] => First Name
    [FormValue] => Mary
    [gName] => fname
)

Array
(
    [UserSessID] => 46f96aa0780383a7ba1a6aba58cbbea7
    [FieldName] => Last Name
    [FormValue] => Jane
    [gName] => lname
)

Array
(
    [UserSessID] => 46f96aa0780383a7ba1a6aba58cbbea7
    [FieldName] => States
    [FormValue] => FL
    [gName] => states
)

}

trying to take the above to put it into 3d dimensional array

Array
(
[UserSess] => ee4af77a65ac7ab613afd176c22e30de
[first_name] => Mary
[last_name] => Jane
[states] => FL
)

basically i’m creating a dynamic form system

logically i’m thinking it should be as simple as assigning an array with Key being “gname” and Value being “FormValue” :confused:

2

You may want to filter the data but its basically like this:

$arr=array();

while ($AffResults=mysql_fetch_array($RetrieveAffID))
{
array_push($arr,$AffResults);
}
3

nah… nice try though…

i figured it out

it’s
$UserSessID[$AffResults[‘gName’]] = $AffResults[‘FormValue’];



	$UserSessID = array();
	$RetrieveAffID=mysql_query("
	select 
		a.uid as UserSessID,
		b.field_name as FieldName,
		a.value as FormValue,
		b.gname as gName
	
	from form_values a join form_fields b on b.id=a.fID where uid='46f96aa0780383a7ba1a6aba58cbbea7'",  $db);
	while ($AffResults=mysql_fetch_assoc($RetrieveAffID))
	{
		$UserSessID[$AffResults['gName']] = $AffResults['FormValue'];
	}


//// Result

Array
(
    [fname] => Mary 
    [lname] => Jane
    [states] => FL
)
4 
$result = array(
array(
    'UserSessID' => '46f96aa0780383a7ba1a6aba58cbbea7',
    'FieldName' => 'First Name',
    'FormValue' => 'Mary',
    'gName' => 'fname',
),
array(
    'UserSessID' => '46f96aa0780383a7ba1a6aba58cbbea7',
    'FieldName' => 'Last Name',
    'FormValue' => 'J Blige',
    'gName' => 'lname',
));

$user = array();

foreach($result as $k=>$v){
extract( $v);
$user['User Sess']=$UserSessID;
$fn = str_replace(" ", "_", strtolower($FieldName));
$user[$fn]=$FormValue;
}
var_dump( $user );
//gives

//array
//  'User Sess' => string '46f96aa0780383a7ba1a6aba58cbbea7' (length=32)
//  'first_name' => string 'Mary' (length=4)
//  'last_name' => string 'J Blige' (length=7)

** Edited to lower case the array keys as in the example given by OP. **