Array and Mysql help

[godsent]

then i'm printing this code it prints as "ArrayArrayArray..." not the correct information, please help me out

 

 

for ($i = 0; $i < 10; ++$i) {
$name[$i] = array(getResultById("data_set", $i));
print $name[$i];
}

function getResultById($table, $int) 
{
$query = "SELECT * FROM $table WHERE id='$int'";
$res = mysql_query($query);
$arr = mysql_fetch_row($res);

return $arr[1];
}

 

 

anyone knows the problem?

[wildteen88]

This line

$name[$i] = array(getResultById("data_set", $i));

 

Should be

$name[$i] = getResultById("data_set", $i);

[Mad Mick]

Not sure what the return $arr[1] is trying to achieve. What do you want to do?  Print the entire contents of the table?  If so try:

 

for ($i = 0; $i < 10; ++$i) {
  $name = getResultById("data_set", $i);
  foreach ($name as $key=>$value){
    echo $key," ",$value,"<br/>";
    }
  }

function getResultById($table, $int)
{
$query = "SELECT * FROM $table WHERE id='$int'";
$res = mysql_query($query);
$arr = mysql_fetch_row($res);

return $arr;
}

 

The function returns an array related to the record in the table e.g. (id=>1, name=>'bob', country=>'mongolia').  You then loop through that array to print.