Trouble looping through array

[ryland22]

I am trying to loop through an array, but keep getting the following error:

Notice: Undefined index: topic in threads.php on line 49

I am trying to put my result set in an array and then I want to loop through the array later in the code, showing only values from one particular column of the array. Below is my code:

<?php
$host = "";
$uname="root";
$pass="";
$database="discuss";
$tablename="threads";
$connection = mysql_connect($host, $uname, $pass);
$result =mysql_select_db("discuss");
$query ="SELECT topic, thread_num, sub_num, new_thread, date_time, name from threads order by thread_num desc, sub_num asc";
$result = mysql_query($query);
$t_array[] = mysql_fetch_assoc($result);
?>

<input type="hidden" name="thread_num" value="
<?php $max_thread = array_slice ($t_array,2,1);
foreach ($max_thread as $th)
{
echo $th+1;
}
?>
">
<input type="hidden" name="sub_thread" value="0">
to start a new topic.

<?php

for ($i = 0; $i < mysql_num_rows($result); $i++) {
print "<th>".$t_array["topic"][$i]."</th>\n";
}
?>

[nemonoman]

INSTEAD OF
print "<th>".$t_array["topic"][$i]

TRY

print "<th>".$t_array[$i]["topic"]

[ryland22]

No- it still gives me the same error:

Notice: Undefined index: topic in threads5.php on line 49

[nemonoman]

post the output of
print_r ($t_array);

[Weedpacket]

One thing I have to point out is that mysql_fetch_assoc() only returns one row from the result at a time - not an array of all the rows.

$query ="SELECT topic, thread_num, sub_num, new_thread, date_time, name from threads order by thread_num desc, sub_num asc";
$result = mysql_query($query);
//...
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$t_array = mysql_fetch_assoc($result):
print "<th>".$t_array["topic"]."</th>\n";
} 

I left out the bit in between, because I couldn't see what it was for; but the point is that you'll need to loop over the $result resouce and pull out each row. Another way of course would be

[code=php]
$query ="SELECT topic, thread_num, sub_num, new_thread, date_time, name from threads order by thread_num desc, sub_num asc";
$result = mysql_query($query);
$result_count = mysql_num_rows($result);
for($i=0; $i<$result_count; $i++)
{  $t_array[] = mysql_fetch_assoc($result);
}

and then you'll have the array you're expecting: array elements would be arranged like $t_array[$i]['topic'].