Some assistance needed in adding another file.

[confused_aswell]

Hi

I wish to add another file to my module, but I am coming up with some errors. Below is the file, which when submitted is passed to another file which then does all the work. Here are the errors.

A prompt response would be very appreciated.

Thanks,

Phil

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/phcleani/public_html/shopping/admin/view_database.php:2) in /home/phcleani/public_html/shopping/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/phcleani/public_html/shopping/admin/view_database.php:2) in /home/phcleani/public_html/shopping/admin/includes/init_includes/init_templates.php on line 36

<?php 

  
 require('includes/application_top.php');
 
 require(DIR_WS_INCLUDES . 'header.php');
  
// find out how many rows are in the table    
$sql = "SELECT COUNT(*) FROM zen_orders";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);   
$r = mysql_fetch_row($result);   
$numrows = $r[0]; ?>
<div align="center">
<?php   
echo "Here is your database, you have $numrows entries in your database. Please enter the number you would like to start downloading from?<br/><br/>";?>
<form name="form1" method="post" action="quickbooks_download.php">
  <p>
    <input name="limit" type="text" id="limit" size="5">
    <input type="submit" name="Submit" value="Download">
  </p>
</form> 
<?php
// number of rows to show per page   
$rowsperpage = 50;   
// find out total pages   
$totalpages = ceil($numrows / $rowsperpage);   
  
// get the current page or set a default   
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {   
   // cast var as int   
   $currentpage = (int) $_GET['currentpage'];   
} else {   
   // default page num   
   $currentpage = 1;   
} // end if   

// if current page is greater than total pages...   
if ($currentpage > $totalpages) {   
   // set current page to last page   
   $currentpage = $totalpages;   
} // end if   
// if current page is less than first page...   
if ($currentpage < 1) {   
   // set current page to first page   
   $currentpage = 1;   
} // end if   
  
// the offset of the list, based on current page    
$offset = ($currentpage - 1) * $rowsperpage;   
  
// get the info from the db    
$sql = "SELECT zen_orders.orders_id, zen_orders.customers_name, zen_orders.customers_street_address, zen_orders.customers_suburb, zen_orders.customers_city, zen_orders.customers_state, zen_orders.customers_postcode FROM zen_orders LIMIT $offset, $rowsperpage";   
$result = mysql_query($sql, $conn) or trigger_error(mysql_error() . "<br />\n" . $sql, E_USER_ERROR); ?>
</div>

<table align="center">
 <?php 
// while there are rows to be fetched...   
while ($list = mysql_fetch_assoc($result)) {   
   
   // echo data   
   echo $list['orders_id'] . " . " . $list['customers_name'] . " | " . $list['customers_street_address'] . " | " . $list['customers_suburb'] . " | " . $list['customers_city'] . " | " . $list['customers_state'] . " | " . $list['customers_postcode'] ."<br />";   
} // end while ?>
</table> <div align="center"><br>
<?php  
/******  build the pagination links ******/  
// range of num links to show   
$range = 3;   
  
// if not on page 1, don't show back links   
if ($currentpage > 1) {   
   // show << link to go back to page 1   
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'>First</a> ";   
   // get previous page num   
   $prevpage = $currentpage - 1;   
   // show < link to go back to 1 page   
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'>Previous</a> ";   
} // end if    
  
// loop to show links to range of pages around current page   
for ($x = (($currentpage - $range) - 1); $x < (($currentpage + $range) + 1); $x++) {   
   // if it's a valid page number...   
   if (($x > 0) && ($x <= $totalpages)) {   
      // if we're on current page...   
      if ($x == $currentpage) {   
         // 'highlight' it but don't make a link   
         echo " [<b>$x</b>] ";   
      // if not current page...   
      } else {   
         // make it a link   
     echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";   
      } // end else   
   } // end if    
} // end for   
            
// if not on last page, show forward and last page links       
if ($currentpage != $totalpages) {   
   // get next page   
   $nextpage = $currentpage + 1;   
    // echo forward link for next page    
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>Next</a> ";   
   // echo forward link for lastpage   
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>Last</a> ";   
} // end if   
/****** end build pagination links ******/  

require(DIR_WS_INCLUDES . 'footer.php');

require(DIR_WS_INCLUDES . 'application_bottom.php');

?>
</div>

[confused_aswell]

Hi

It's ok now, I have sorted it.

Thanks,

Phil