HELP - I have tried everything I can think of, taken onboard suggestions and
still cannot understand why my record counter works in the Windows
Environment and not in Linus Environment. Here is the code can anybody see
what is wrong??
<?PHP SESSION_START(); ob_start();
$self = $_SERVER['PHP_SELF'];
$referer = $_SERVER['HTTP_REFERER'];
$access = $_SESSION['access'];
//
@ $cps; //Current Page Starting row number
@ $lps; //Last Page Starting row number
@ $rpp; //Records Per Page
//
include("tp_database.php");
mysql_connect($db_host,$db_user,$db_password);
mysql_select_db($db_database) or die("Unable to select database");
//
if(empty($_GET["cps"]))
{ $cps = "0"; }
else
{ $cps = $_GET["cps"]; }
//
$rpp = "001";
//
$q="SELECT SQL_CALC_FOUND_ROWS *
FROM tr_test_record
WHERE $access = tr_access";
//
$rs=mysql_query($q) or die(mysql_error());
//
$q0="Select FOUND_ROWS()";
//
$rs0=mysql_query($q0) or die(mysql_error());
//
$row0=mysql_fetch_array($rs0);
//
$nr0 = $row0["FOUND_ROWS()"]; //Number of rows found without LIMIT in
action
?>
Thanks - Paul
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
