Re^2: Looping and counting

Thanks. grabbing only the first 50 is how I normally do it, but I didn't write this script so I'm a bit lost. Here's more code to see if it makes it clearer. This is the skeleton as I've ripped out a bunch of variable setting.

$filebase = "news";
$num_records = 10;
$SQL = "SELECT * FROM $content_table WHERE contenttype = 'video' ORDER
+ BY dateadded DESC, ID DESC";

for ($n=1; $n<=$num_records; $n++) {

            $pointer = $sth->fetchrow_hashref;
            $title = $pointer->{'title'};

      $main_list2 = $main_list2 . "$title";
      print outfile1 "$main_list2";
}
 
 
 
$filebase = "morenews";   
$num_records = 40;
for ($n=1; $n<=$num_records; $n++) {

            $pointer = $sth->fetchrow_hashref;
            $title = $pointer->{'title'};


     $main_list2 = $main_list2 . "$title";
print outfile2 "$main_list2";
}
[download]

As you can see, it loops through and adds another $title to $main_list2. No matter what if statement I put before $main)list2, it doesn't work. I had it like you suggested but no dice. What I'm ending up with is the first 10 titles on page 1, then the first 10 titles, plus the first 40 titles on page 2. Thanks.

Comment on Re^2: Looping and counting Download Code

Replies are listed 'Best First'.
Re^3: Looping and counting by Riales (Hermit) on Apr 04, 2012 at 01:44 UTC
Put this between your two `for` loops: `$main_list2 = '';` [download] But seeing as you have have a `$main_list2`, why don't you use `$main_list1` in the first `for` loop instead? Also, probably want to have a `"\n"` between your titles: `$main_list2 .= "$title\n";` [download]	[reply] [d/l] [select]