Hi Dan,
On Tuesday 26 November 2002 14:13, Costantino, Dan Dan.Costantino-x-gs.com
|html::template| scribed:
<snip>
> Finally, I suspect that you are only receiving Halloween and not
> Halloween and Xmas because you reuse the $sth variable in the inner
> loop. You're blowing away the initial results. You need a new
> variable. I don't work with mySQL (only Sybase which has a fantastic
> nsql() method), so I'm not positive.
well thanks for taking the time to look at the mySQL :-)
>I probably should have noticed
> that earlier. Try:
>
> #2nd query
> $sth2 = $dbh->prepare("select image_name, category from
> card_images where category = '$name' order by image_name");
> $sth2->execute;
<snip>
> $sth2->finish; # Close both
> $sth->finish;
> Again, I'm not positive that that's the problem. But it's a good
> place to start.
Well that worked($sth2).....yes.. thanks for the good catch Dan.....doe!
Looks like I got what I wanted for an output on my template page
...so I'm happy to be making progress again.
- thanks for your time, much appreciated -
--
michael
-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T
handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users
