Fatal Error!

Paris_Holley

i get

Fatal error: Call to a member function on a non-object in /home/hotboyd/public_html/convert/conv_users.php on line 93

this is part of what i have

function query($sql, $errormsg) 
		{ 

		if( !($result = $db->sql_query($sql)) )
			{ 
				print "<br><font color=\"red\">\n"; 
				print "$errormsg<br>"; 
				$sql_error = $db->sql_error(); 
				print $sql_error['code'] .": ". $sql_error['message']. "<br>\n"; 
				print "<pre>$sql</pre>"; 
				print "</font>\n"; 
				return FALSE; 
			} 
		else 
			{ 
				return $result; 
			} 
	}

the line if( !($result = $db->sql_query($sql)) ) is where the error occurs

kevinsequeira

if( !($result = $db->sql_query($sql)) ) try changing it to if( !($result = $db->query($sql)) ) cause thats what u have named the function

reg
kevin

Paris_Holley

nope that doesn't work either

kevinsequeira

ah, the second argument is missing in the function call

f( !($result = $db->query($sql,$error_msg)) )

reg

kevin

jayant

function query($sql, $errormsg)
{

global $db;

now know what u missed?

Paris_Holley

ok...now that i have that i get this error a few lines down

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

unction query($sql, $errormsg) 
		{ 
			$dbhost = 'mysql.datacities.com';
			$dbuser = 'hotboyd_paris';
			$dbpasswd = '123456789';
			$db = mysql_connect($dbhost, $dbuser, $dbpasswd);
			global $db; 
			if( !($result = $db->query) )
				{ 
					return $result; 
				} 
		} 


function result($query, $row) { 
		$query = mysql_result($query, $row); 
		return $query; 
	}

$query = mysql_result($query, $row); is the line its talkign about

trooper

Use mysql_error to return the actual error

function result($query, $row) { 
		$query = mysql_result($query, $row)or die (mysql_error()); 
		return $query; 
	}

The error message you are receiving indicates that the connection to the db did not work 100% so also put mysql_error() on the connection line

HTH
GM

jayant

$db = mysql_connect($dbhost, $dbuser, $dbpasswd);
global $db;

these 2 r conflicting.

if u r already connected to the db then use
global $db;

if not use
$db = mysql_connect($dbhost, $dbuser, $dbpasswd);
and after this you must also select the database
using
mysql_select_db()

got it?