PHP, table continually repeats information!

viajero5

Alright, what I am trying to do is dynamically load some information from a database into a flash file, but it's just not working. I am pretty sure the major problem is with my PHP but I just cannot figure it out, I have been troubleshooting for the past hour with this.

As of right now the script only shows the newest entry, when I view the script online it comes up with this:
&Name0=Test8000&TextData0=ZUBBLE CUBBLE MUBBLE SHUBBLE&Author0=Toby&TheDate0=June 5th, 3030&NumItems=1&Go=Yes&

Now, that is what should come up, but there are two other entries that were made earlier that are not showing up.... Here is the script:

if ($result) {
	while ($tablefield = mysql_fetch_array($result, MYSQL_ASSOC)) {
		$id = $tablefield['id'];
		$title = $tablefield['title'];
		$author = $tablefield['author'];
		$thedate = $tablefield['date'];
		$text = $tablefield['story'];
}


	$numReturn = count($tablefield);
		$i = 0;

while ($i < $numReturn) {
    $Name         = $title;
    $TextData     = $text;
	$Author 	  = $author;
	$TheDate      = $thedate;

	print "&";
    print "Name$i=$Name&TextData$i=$TextData&Author$i=$Author&TheDate$i=$TheDate";

    $i++;
}print "&NumItems=$numReturn&Go=Yes&"; 
}

gah! What in the world is wrong with it?!?

Thanks a lot in advance! Help appreciated!

NogDog

You need to get the output inside of the "fetch" while loop, something like:

if ($result) {
    $i = 0;
    while ($tablefield = mysql_fetch_array($result, MYSQL_ASSOC)) {
        $id = $tablefield['id'];
        $Name = $tablefield['title'];
        $Author = $tablefield['author'];
        $TheDate = $tablefield['date'];
        $TextData = $tablefield['story'];
        print "&";
        print "Name$i=$Name&TextData$i=$TextData&Author$i=$Author&TheDate$i=$TheDate";
        $i++;
    } 
    $numItems = mysql_num_rows($result);
    print "&NumItems=$numReturn&Go=Yes&";
}

viajero5

I am confused on the placement of that script? Where should I put that? Do I need to delete everything I posted before and replace it with yours, or do I leave some of my old stuff?

NogDog

It would replace what you provided. WARNING: It's just my best guess as to what you want, not having a thorough understanding of what you are ultimately trying to do -- so no warranties or guarantees, expressed or implied. 😉

viajero5

Hmmm, that worked, but it dosent quite export the variables to flash the way i wanted it to. Any other ideas?

Thank you for replying!

Weedpacket

This comes with the same disclaimers as NogDog's suggestion.

Another thing that might cause grief is that, while it appears that that is supposed to be a URL-encoded query string, you aren't using [man]urlencode[/man] to encode your text strings.