View Issue Details

IDProjectCategoryView StatusLast Update
0006778phpList 3 applicationInterface - Frontendpublic12-07-19 13:06
Reportersiggi Assigned To 
Status closedResolutionno change required 
Product Version2.10.2 
Target VersionFuture developments 
Summary0006778: ordering subscribe pages
Descriptionorder by id ASC invented in line 217 lists/index.php

The sorted order of different subscription-pages is first in first out from database. To get it sorted I invented an order-statement. Now I can get last in is first out.

See where it happens:

if ($id) $data = PageData($id);
print '<title>'.$GLOBALS["strSubscribeTitle"].'</title>';
print $data["header"];
//order by id ASC added by SG for sorted Output of sbscription_pages
$req = Sql_Query(sprintf('select * from %s where active order by id ASC ',$tables["subscribepage"]));
if (Sql_Affected_Rows()) {
while ($row = Sql_Fetch_Array($req)) {
$intro = Sql_Fetch_Row_Query(sprintf('select data from %s where id = %d and name = "intro"',$tables["subscribepage_data"],$row["id"]));
print $intro[0];


TagsNo tags attached.


related to 0002705 closed PHPList v2.11 release 



30-06-06 14:08

administrator   ~0014966

yes, but that would require allowing to change the order of subscribe pages in the backend, in case you want it in a different order.