Hi!
I solved the problem with the non-loaded "PHP_XLS" module.
Now when runing the PHP script the error.log of PHP script
says:
PHP Warning: mysql_fetch_assoc(): supplied argument is not a
valid MySQL result resource in Applic:/HTDocs/test.php on line 13
The script is:
<table border="1">
<tr>
<td>s1</td>
<td>s2</td>
<td>s3</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_test['s1']; ?></td>
<td><?php echo $row_test['s2']; ?></td>
<td><?php echo $row_test['s3']; ?></td>
</tr>
<?php } while ($row_test = mysql_fetch_assoc($test));
?>
</table>
<?php virtual('/Connections/test.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType,
$theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue)
: $theValue;
$theValue = function_exists("mysql_real_escape_string") ?
mysql_real_escape_string($theValue) :
mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" :
"NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) .
"'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" :
"NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue :
$theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_test = 10;
$pageNum_test = 0;
if (isset($_GET['pageNum_test'])) {
$pageNum_test = $_GET['pageNum_test'];
}
$startRow_test = $pageNum_test * $maxRows_test;
mysql_select_db($database_test, $test);
$query_test = "SELECT * FROM test1";
$query_limit_test = sprintf("%s LIMIT %d, %d", $query_test,
$startRow_test, $maxRows_test);
$test = mysql_query($query_limit_test, $test) or
die(mysql_error());
$row_test = mysql_fetch_assoc($test);
if (isset($_GET['totalRows_test'])) {
$totalRows_test = $_GET['totalRows_test'];
} else {
$all_test = mysql_query($query_test);
$totalRows_test = mysql_num_rows($all_test);
}
$totalPages_test = ceil($totalRows_test/$maxRows_test)-1;
mysql_free_result($test);
?>
Did I forget anything?
TIA
Nanu
6
Replies
AdChoices