Assign Fields

[EchoFool]

Is there a quick method to assigning fields to an Array ?

 

Say i have SELECT * FROM table

 

Now say theres 30 field, i don't want to be doing:

 

$UserID = $row['UserID'];$Username = $row['Username'];  for all 30 fields.

 

Is there a way to loop them into an array? Would save so much time.

[PFMaBiSmAd]

What's wrong with $row['UserID']? It is a perfectly valid variable.

 

By assigning it to another variable $UserID = $row['UserID'], you are just wasting processing time and memory.

[EchoFool]

What's wrong with $row['UserID']? It is a perfectly valid variable.

 

By assigning it to another variable $UserID = $row['UserID'], you are just wasting processing time and memory.

 

Okay good point on that front - Judging from your answer that means the loop option is not possible ?

[PFMaBiSmAd]

Anything involving the creation, manipulation, or outputting of data is possible. That's what computers were created for.

 

What exactly do you want to put into an array and in what form or order?

[EchoFool]

Okay ill do a small example

 

Table:

UserID | Username | Password | Email

---------------------------

 

Query:

 

SELECT * FROM table

 

Now in php currently i do:

 

$array = array($row['UserID'],$row['Username']  etc etc

 

But if theres some 30 + fields in the table, it gets a bit annoying having to write it all out, so i wanted to see if i can create the array from while looping some how - so that i don't have to type out giant arrays all the time. The reason i put them in an array is because this occurs in a function.

 

Which i then place the array in return().

[teynon]

I'm not sure I agree with what you're trying to do, but this will do it:

$array=array();

foreach ($row as $key=>$value) {

$array[$key]=$value;

}

[EchoFool]

I'm not sure I agree with what you're trying to do, but this will do it:

$array=array();

foreach ($row as $key=>$value) {

$array[$key]=$value;

}

 

I will give it a try - may i ask why you don't agree?

[trq]

I'm not sure I agree with what you're trying to do, but this will do it:

$array=array();

foreach ($row as $key=>$value) {

$array[$key]=$value;

}

 

I will give it a try - may i ask why you don't agree?

 

Because you likely don't need it.

[PFMaBiSmAd]

Umm. $row, that you fetched from the result set (using mysql_fetch_assoc or mysql_fetch_array) is already an array. Iterating over it to put each piece of it into another array is extremely pointless.

[EchoFool]

Oh - did not know that, so then i just need to do return($row) in the function ?

[Buddski]

Presuming I understand what you are trying to accomplish, then yes.. You want to return the $row..

[EchoFool]

Thanks

[PFMaBiSmAd]

What function? You haven't shown enough information about what you are doing or how you are using the result of the query.

[EchoFool]

This would be my function:

 

<?php
function getall ($UserID){
$SELECT = mysql_query("SELECT * 
FROM users where UserID='$UserID'")
Or die(mysql_error());
$row = mysql_Fetch_array($SELECT);
return ($row)
}
?>