manipulating my array (sounds obscene)

dgnorton

I queried my database and arrayed the results:

$line=mysql_fetch_row($result)

Now, I can certainly list all of the content of the array:

echo("$line<br>");

but, how would I go about calling only specific elements (or range of elements) from the array? 😕

Hope someone can help me here.
Thanks,
DavidN

Delcypher

what you could do is get it to reorder the data before php requests the data

SELECT thing1, thing2 FROM stuff WHERE thing1='funnt'

dgnorton

I think I found a workable answere:

I queried my database as ususal with $result=mysql_query(...)

Then arrayed $result with mysql_result:

for($i = 0; $i < 10; ++$i)
{
$item[$i]=mysql_result($result, $i);
}

This arrays the first colomn of fields in my table to $item, each with a unique key.

echo($item[1]);
echo($item[2]);....

echo's each individual value in the array by its key. This way I can refere to table data later in my script; each specific cell waranting its own array key.

MarkE

if you want your results in an associative array use this:

$fields = mysql_fetch_array($result);

so you can refer like this: $fields['fieldname'] to get at any result you need

dgnorton

Your right Mark, but the problem I had with an associative array was that each element in the array was assigned the key [0]! Now, I don't know why this was the case, but in the end the only element that was in the array was the last element assigned, because all the other elements (with the key [0]) were replaced. I worked for hours trying to figure out how to increment the key for each element using an associative array with both mysql_fetch_array and mysql_fetch_row, but didn't have any luck. So, "I used a hammer" to fix it. LMAO