PHP4 and this function

[Jon]

function query($query, $return = false)
{
$fetch = mysql_query($query, $this->connection) or
die2(mysql_error($this->connection));
if($return)
return $fetch;
}

mysql_error(): supplied argument is not a valid MySQL-Link resource

the line that begins with $fetch is my problem. This was originally a
PHP5 script that I am retrofitting.
The $query is used all over, and it is really gumming things up.
Thanks!
jon

[ming]

I think it the -> problem. php5 class is different with php4 class

Jon wrote:

function query($query, $return = false)
{
$fetch = mysql_query($query, $this->connection) or
die2(mysql_error($this->connection));
if($return)
return $fetch;
}

mysql_error(): supplied argument is not a valid MySQL-Link resource

the line that begins with $fetch is my problem. This was originally a
PHP5 script that I am retrofitting.
The $query is used all over, and it is really gumming things up.
Thanks!
jon

[Tony Marston]

"ming" <my*****@gmail.com> wrote in message
news:vE****************@nnrp.ca.mci.com!nnrp1.uune t.ca...

I think it the -> problem. php5 class is different with php4 class
No, this works in both PHP 4 and 5 as I use it all the time.
Jon wrote:

function query($query, $return = false)
{
$fetch = mysql_query($query, $this->connection) or
die2(mysql_error($this->connection));
if($return)
return $fetch;
}

mysql_error(): supplied argument is not a valid MySQL-Link resource

the line that begins with $fetch is my problem. This was originally a
PHP5 script that I am retrofitting.
The $query is used all over, and it is really gumming things up.
Ths function can only be used in an object as $this->connection refers to a
property called $connection within the current object. Have you checked to
see if $this->connection actually refers to a valid resource? Where did the
previous call to mysql_connect() store its result?

--
Tony Marston
http://www.tonymarston.net
Thanks!
jon

[Jon]

On 2006-01-22 21:50:34 -0600, "Tony Marston" <to**@NOSPAM.demon.co.uk> said:

"ming" <my*****@gmail.com> wrote in message
news:vE****************@nnrp.ca.mci.com!nnrp1.uune t.ca...

I think it the -> problem. php5 class is different with php4 class

No, this works in both PHP 4 and 5 as I use it all the time.

Jon wrote:

function query($query, $return = false)
{
$fetch = mysql_query($query, $this->connection) or
die2(mysql_error($this->connection));
if($return)
return $fetch;
}

mysql_error(): supplied argument is not a valid MySQL-Link resource

the line that begins with $fetch is my problem. This was originally a
PHP5 script that I am retrofitting.
The $query is used all over, and it is really gumming things up.

Ths function can only be used in an object as $this->connection refers
to a property called $connection within the current object. Have you
checked to see if $this->connection actually refers to a valid
resource? Where did the previous call to mysql_connect() store its
result?

function constructor($host, $user, $pass, $database)
{

$this->connection = mysql_connect($host, $user, $pass) or die2

This was modified from a more PHP5 compatible __constructor, and
function cnstructor allowed it to "work" apparently, but not as well as
I need it to.

jon

[NC]

Jon wrote:

"Tony Marston" <to**@NOSPAM.demon.co.uk> said:

Ths function can only be used in an object as $this->connection refers
to a property called $connection within the current object. Have you
checked to see if $this->connection actually refers to a valid
resource? Where did the previous call to mysql_connect() store its
result?

function constructor($host, $user, $pass, $database)
{

$this->connection = mysql_connect($host, $user, $pass) or die2

This was modified from a more PHP5 compatible __constructor, and
function cnstructor allowed it to "work" apparently, but not as well as
I need it to.

In PHP 4, the consturctor has the same name as the class. So your
constructor() function is probably never executed.

Cheers,
NC