View Single Post
Old 09-22-2004, 04:18 PM  
lb_vee
Confirmed User
 
Join Date: May 2004
Posts: 886
Quote:
Originally posted by archael
Yep thats exactly what I tried.. It just ended up showing absolutely no results. Not even for the $sth that was already working. I'm gonna try it again see if I had any errors anywhere.

But what was weird is that the query that used to work well ended up showing nothing even if it stayed untouched.

All different variables too.


Jon
Try this:

create subroutine that gets the data you need and takes the one argument you need for your sites data and other sites data.

then do this (assuming you're returning an array):
Code:
my @mySitesData = &mySub('mySite');
my @otherSitesData = &mySub('otherSite');
That should work, because the scope of $sth is now within a subroutine.

Last edited by lb_vee; 09-22-2004 at 04:20 PM..
lb_vee is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote