php code has problem after moving from 4.3.3 to 5.0.3

scorpioy

I developed php code in WinXP and moved the website to Linux. I'm getting errors like this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../main.php on line 122

the code is like this:

$result = mysql_query("SELECT name, telephone, email FROM person WHERE id='$member' " ) || die(mysql_error());


if ($myrow = mysql_fetch_array($result, MYSQL_BOTH))   // line 122
{  

	....
}

if I insert:
$c =count($result);
echo ">$c<";

it will print 1, because it does get a matching row and in the $result.
but I couldn't get value out by using mysql_fetch_array(); I also got warning when I use mysql_num_rows()

The php version is 5.0.3 now in Linux. But I code was written in WinXP with PHP 4.3.3. Can someone help me to solve this? Thanks.

dalecosp

What you really want to do to test, is print_r($result) ...

LoganK

Or try "mysql_query("YOUR QUERY") or die(mysql_error())" to see if anything's wrong with the query itself.

scorpioy

I tried print_r($result)
it just prints '1' out

I used die(mysql_error(), but no output from that line.

I also use the sql
SELECT name, telephone, email FROM person WHERE id='some_value'

it works in mysql control center, but I just have no idea why I still get warning from mysql_num_rows(), saying $result is not a valid MySQL result resource

Please help

drew010

did you check what mysql version is running on the server like posted at devshed?

scorpioy

Yes, I did.

MySQL version Im using is 4.1.7. For a simpler table with 2 columns, it works by using mysql_fetch_array(), but for this one person table, I just can't make it work. :queasy:

Doug_G

id is probably numeric, remove the ' around the value in your sql.

SELECT name, telephone, email FROM person WHERE id=some_value

scorpioy

Thanks guys, after I change from mysql_query(...) || die(...) to
mysql_query(...) or die(...), it works.

I found $member did not get set in the previous page,
I used this in the previous page

session_register('member');

but this code in the current page only print BBB

if(isset($_SESSION['member']))
    echo "AAA";
else
    echo "BBB";

How can I set variable using session? Do I have to turn register_globals ON ?

thorpe

no... dont turn register_globals on. you assign things to sessions using...

$_SESSION['name'] = 'bob';

session_register() relies on register_globals being on, so you will need to change your code accordingly. register_globals() should however remain off, as it is a security issue.

scorpioy

Thank you all, it works now.