The code is here

PHP Code:

// this function views logs
   function viewLogs($page) {

      echo("<p align=left><b><i>Logs</i></b><hr></p><center><table border=0 width=100% cellspacing=1 cellpadding=2>");

      $result = mysql_query("SELECT COUNT(*) FROM log");
      $count = mysql_fetch_array($result);
      $count = $count[0];

      $logsperpage = 50;

      $num_pages = ($count / $logsperpage) + 1;
      $limit = $logsperpage * ($page - 1);

      $result = mysql_query("SELECT * FROM log ORDER BY id DESC LIMIT $limit, $logsperpage");
      while( ($row = mysql_fetch_array($result) ) ) {
         extract($row);

         echo("<tr><td bgcolor=#000000>");

         $longlog = "$date1 $action";
         $reason = bbc2html($longlog);
         $thelog = "<a href=console.php?p=OneLog&log1=$id> $reason </a>";

         echo"<font size='1' color='white'> $thelog</td>";
      }
      echo"<tr><td><font size='1' color='white'>Page:";
      for($i = 1; $i <= $num_pages; $i++) {
         echo("<a href=console.php?p=ViewLogs&page=$i>$i</a>");
      }
      echo("<br><font size='1' color='white'> Current Page: <font color='green'>$page </font>
   <br><font size='1' color='white'> Number of Logs Per Page: <font color='green'>$logsperpage</font></table></center>");
   } // end viewLogs 


Where are the variables so i can rename them to these? My View Logs page isn't working so obviously there are tables wrong. If someone could I would want the code pointed out where you change them. My view logs page isn't working so i'm obviously doing it wrong:

id
action
reason
date1

The variables are the things starting with a $ sign. If you rename these then there won't really be any effect, since it is the values they contain and not their name that control what the script does (by and large). If the page displays a list and you want to rename things in the list, you will need to change the code that displays the list.

If you could tell us a little more about what id, action, reason and date1 are meant to be, then perhaps we can help you out more effectively.

id
action
reason
date1

are the table structure for "log"

CREATE TABLE `log` (
`id` smallint(255) NOT NULL auto_increment,
`action` varchar(255) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
`date1` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

My View Logs function does not work since the variable names are wrong. I need help replacing them with id, action, reason and date1.

WHY WHY

You need to alter your table field 'id':

ALTER TABLE `log` CHANGE `id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT