PHP/SQL Array Problem....HELP

[viajero5]

I have a problem with my array, it is not assigning the values from the database to the variables.....and I do not know why.

here is my script:

$i=0;
while ($tablefield = mysql_fetch_assoc($result) && $numm = mysql_num_rows($result)) {
        $id[$i] = $row['id'];
        $title[$i] = $row['title'];
        $author[$i] = $row['author'];
        $thedate[$i] = $row['date'];
        $text[$i] = $row['story'];


$numReturn = $numm;

    while ($i < $numReturn) {

    $Name         = $title[$i];
    $TextData     = $text[$i];
    $Author       = $author[$i];
    $TheDate      = $thedate[$i];
    print "&";
    print "Name$i=$Name&TextData$i=$TextData&Author$i=$Author&TheDate$i=$TheDate";
    $i++;
}}  

and it prints this:

&Name0=&TextData0=&Author0=&TheDate0=&Name1=&TextD ata1=&Author1=&TheDate1=&Name2=&TextData2=&Author2 =&TheDate2=&NumItems=3&Go=Yes&

no values....HELP PLEASE. Thank you a lot in advance.

[Weedpacket]

Well, it's a pretty messy approach to begin with. Does the following code describe what you're trying to achieve a little more clearly?

$record_count = mysql_num_rows($result);
$records = array();
for($i=0; $i<$record_count; $i++)
{
	$row = mysql_fetch_assoc($result);
	print "&Name$i=".$row['title'];
	print "&TextData$i=".$row['story'];
	print "&Author$i=".$row['author'];
	print "&TheDate$i=".$row['date'];
}

[viajero5]

thanks a lot! That worked. Can you please explain the for statement to me?

[viajero5]

haha, sorry, nevermind. I got it. Just a misread!

Thanks again!

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).