Array Problem

[Anon]

I am trying to add values from a database
to a empty array so i can print the values form a array.

session_start();
session_register(\"item\");

$query = mysql_query($id,$conn) or die(show($item));
$result = implode (\":\", mysql_fetch_row($query));
$item = explode(\":\",$result)
$array=array();

for(a:=0; $a<=count($array); $a++){
$array[]=$item;
}

I can only seem to add one item at a time
from the database, but i require to add
more than one item.

[Anon]

Okay. let's look at your code (that's always a good place to start when your code doesn't work :>)

You fetch the row as an array, implode it into $result, then explode it into $item. Why?

Then you create an empty array as $array and loop through every element of it. That shouldn't take long since $array is empty...

Anyway, you get an array from the call to mysql_fetch_row, just use in instead of the useless implode/explode/for loop:

$result = mysql_fetch_row($query);
print_r($result);

[Anon]

while($data = mysql_fetch_array($result))
{
$item1 = $data['cost'];
$item2 = $data['name'];
}