Dw8+PHP5+MySQL5 problem

cnanu wrote:
> 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

You've got the cart before the horse. The recordset code should come
before the table that displays it. Dreamweaver did not create the code
in that order (or if it did, there's something seriously wrong with your
installation). Scrap the page and start again.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

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

Thanks!

Nanu

cnanu wrote:
> Now, trying to run simple PHP script with query to a MySQL table, the server
> log the following errors:
>
> PHP Warning: PHP Startup: Unable to load dynamic library
> 'sys:/php5/ext/php_xsl.nlm' - (dlfcn) Load failure including unresolved symbol
> in Unknown on line 0

It looks as though there was a problem with the upgrade. Have you tried
running phpinfo() on the server?

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/