Hi,
Michael Tam wrote:
Hi All,
I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I
used m.mmysql.2.0.8 JDBC driver with the following config segment in my
resin.conf:
resource-ref
res-ref-namejdbc/test/res-ref-name
Hi All,
I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I
used m.mmysql.2.0.8 JDBC driver with the following config segment in my
resin.conf:
resource-ref
res-ref-namejdbc/test/res-ref-name
res-typejavax.sql.XADataSource/res-type
init-param
I'm using MySQL with PHP (just learned MySQL so bear with me).
Here's a two part program:
Test.php:
html
body
?php
require(common.php);
CalculateScore(1);
?
/body
/html
Common.php:
?php
//Global variables
$Sitename=Toplist;
$Siteurl=;
$Links_per_page=50;
$Base_site_url=localhost;
//MySQL
I thought using the result identifier returned by mysql_query in
mysql_fetch_array was perfectly legal.
mysql_query() doesn't always return a valid result identifier if an error
occurs (echo mysql_error()) or if no rows are returned.
When I run test.php I get this:
Warning: Supplied argument is not a valid MySQL result resource in common.php on
line 27
0
Here are lines 25-27:
25: $sql = select urate, arate, inhits from sitestats where id = $id;
26: $r = mysql_query($sql);
27: $row = mysql_fetch_array($r);
I