access element of array

[Anon]

I would like to copy mysql_fetch_array result to an normal array. What I've done first is, (I wonder if there's anyway I can do better than this though.)

$query="SELECT * FROM table";

$res=mysql_query($query, $conn);

while($getrow=mysql_fetch_array($res))
{
$id = $getrow["id"];
$desc = $getrow["desc"];
$line = $id.",".$desc;
$array[] = $line;

}
mysql_close($dblink);

I tried this then,

while($getrow[]=mysql_fetch_array($res))
{
}

while(list($key, $value) = each($getrow))
{
print "$key : $value<br>";
}

This solution seems unreachable. I FAILED to get the data from this way. The results I've got for $value is "Array" but not the data itself. I've also tried to list the subarray since the result I got is "Array" but it shows error that the $value is not an array.

I've came across with one of the message that posted here before and it suggest to use mysql_fetch_field instead of using mysql_fetch_array. By using mysql_fetch_field, I think the solution will be more or like same as what I've done for the first time.

Is there anyway to solve for my second approach ?

Thanks!

[Anon]

Sorry for making multiple post.

Just want to clarify something, my attempt is actually to make the "id" as the key and the "desc" as the value in the array.

However, for my first try, the $key become an index value while the $value is a combination of "id" and "desc". That's why I go for second approach. But, unfortunately, I'm failed to do so as well.

Waiting for help then...... =)

[Anon]

what about...

$query="SELECT * FROM table"; $res=mysql_query($query, $conn);
$numrows = mysql_numrows($res);

for($i = 0; $i < $numrows; $i++) {
$array['id'][] = mysql($result, "id", $i);
$array['desc'][] = mysql($result, "desc", $i);
}

(although you could make this loop body general to cope with any field names by while(list..each)'ing through the fetch_array)

and then go through this new 2d array...

while(list($key1, $array2) = each($array)) {
print $key.":<br>\n";
// Go through the array of results
while(list($key2, $value) = each($array2)) {
print $key." -> ".$value."<br>\n";
}
}

which would give you the results like...

id
0 -> 1
1 -> 4
2 -> 6

desc
0 -> 'cheese'
1 -> 'chuff'
2 -> 'chin'

hope this helps, if i've not understood you properly, post back.

dom
🙂

[Anon]

Do pardon me that I couldn't search for information about mysql() function in both PHP and mySQL site, could you please explain to me what this few lines do ?

for($i = 0; $i < $numrows; $i++)
{
$array['id'][] = mysql($result, "id", $i);
$array['desc'][] = mysql($result, "desc", $i);
}

Is "id" and "desc" field names from table? What value will the $result variable holds ?

p/s: Where can I search for mysql() function's information ?

Thanks!

[Anon]

sorry... i meant to use...

$array['id'][] = mysql_result($res, $i, "id");

(and similarly for desc)

the first argument is the result id from the query
the second is the row number
the third is the field name

sorry about my syntax (and just plain foolishness)

dom
🙂

[Anon]

Hiyee, thanks for your help! It runs correctly now. It's indeed of what I want.

One question though, is it possible to combine the array, like
id -> desc

instead of
id:
0 -> aaa
etc ..

desc:
0 -> fdsfsdf
etc..

Thank you again! =)

[Anon]

ah... ok. since the id's are unique (i assume) you can just make an array with them as the indices...

$query="SELECT * FROM table"; $res=mysql_query($query, $conn);
$numrows = mysql_numrows($res);

for($i = 0; $i < $numrows; $i++) {
$cur_id = mysql_result($res, $i, "id");
$cur_desc = mysql_result($res, $i, "desc");

$array[$cur_id] = $cur_desc;
}

while(each($key, $value) = list($array)) {
print("$key --> $value<br>\n");
}

That should do the job...

dom
🙂

[Anon]

Hey, thanks a million!! You have saved my days. May God bless you richly and u have a nice day, Dom. =)