[RESOLVED] Server updates -

[AlGale]

Ladies and gents...

Easy question I hope. My host has kindly updated their servers to php 4.4.2 and
mysql 4.1.20.

NOW, code that used to work is throwing up errors:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

AND

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Is this to be expected? Are there new standard MySQL queries that replace these? I have a feeling this is going to be the tip of a large iceberg....

Thanks in advance for any help.

Al

[Houdini]

Are you sure that you are connecting without errors? May if you showed the code.

[AlGale]

Yes, I am connected, as I can log in - it is a CMS.

The code is:

$totalrows = mysql_num_rows($strSQL);

[Houdini]

Maybe if you showed a little more code the resource provided with mysql_num_rows() and mysql_fetch_array()is false, possibly a typo.

[AlGale]

Er, well I can show you the entire page... but why? The error message is for that line... Unless I`m missing something??

[tsinka]

Hi,

please post the complete code block that assembles the query string, executes the query string and executes the functions that throw that error message.

I wonder if $strSQL contains the sql query string or the result of a mysql query. The name of the variable ($strSQL) looks suspicious to me.

So the warning comes from the line you posted but the problem is somewhere else (like in most cases).

Thomas

[AlGale]

OK, the code, short as it is, goes:

<?php

// Database connection, using db_fns.php
// db_fns.php must be included in the page which include this script
$conn = db_connect();
if (!$conn)
echo "Could not connect to database server - please try later.";

// set number of results to display per page
$pagelimit = "1";

// run query

$Search == 0; //only needed if this is the result of a search
//$Corrected = strtoupper($Search); //only needed if this is the result of a search
$strSQL = mysql_query("select * from Books WHERE cata = '$cata'");

// count number of matches
$totalrows = mysql_num_rows($strSQL);

The LAST line, is the one that is being reported as failing... Thanks

Note that this has ONLY just stopped working.... it worked for 2 years, until they upgraded their servers!!

[tsinka]

Ok,

modify the script a little bit and add some error handling to catch query problems:

$strSQL = mysql_query("select * from Books WHERE cata = '$cata'");

if ($strSQL === false) {
    echo "A SQL error occurred: ".mysql_error()."<br>\n";
}

Thomas

[AlGale]

Brilliant - thanks.... looks like my friendly (and cheap) host has managed to completely TRASH my table "Books"....

Many thanks for your help!

Al