2 replies to this topic

[SiteReboot]

hello and id like to thank anyone able to help me with resolving this in advance.

I am getting an error msg as follows with a script:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/7/d94330934/htdocs/date/lib/mysql.php on line 3

Line three section in question is as follows:

if (!$mysq_lib_loaded){function c(){global $db_host, $db_login, $db_pswd;$db=mysql_connect($db_host,$db_login,$db_pswd);return $db;}function q($q_str){global $db_name;$r=mysql($db_name,$q_str);return $r;}function qd($q_str){global $db_name;$r=mysql($db_name,"DELETE FROM ".$q_str);return $r;}function qs($q_str){global $db_name;$r=mysql($db_name,"SELECT ".$q_str);return $r;}function qu($q_str){global $db_name;$r=mysql($db_name,"UPDATE ".$q_str);return $r;}function qi($q_str){global $db_name;$r=mysql($db_name,"INSERT INTO ".$q_str);return $r;}function d($db){}function e($r){if(@mysql_numrows($r))return 0;else return 1;}function f($r){return mysql_fetch_array($r);}function nr($r){return mysql_num_rows($r);}$dv=@c();if (!$dv) {echo "<h2>Header Here</h2><h4>This website is temporarily unavailable.<br>MySQL connection is not available. Please try again later.</h4><h5></h5>";exit;}$rv=qs("* from sysvars");while($va=f($rv)) {${$va[name]}=$va[value];};d($dv);function piurl($pid,$thumb=""){$r=qs("picture, image from pictures where id='$pid'");if (e($r)) $ur=$ROOT_HOST."images/na.gif";else


So i would really appreciate any help in getting this resolved.

[Braunson]

Here's the code made a bit more readable

if (!$mysq_lib_loaded){function c(){
global $db_host, $db_login, $db_pswd;
$db=mysql_connect($db_host,$db_login,$db_pswd);
return $db;
}

function q($q_str){
global $db_name;
$r=mysql($db_name,$q_str);
return $r;
}

function qd($q_str){
global $db_name;
$r=mysql($db_name,"DELETE FROM ".$q_str);
return $r;
}

function qs($q_str){
global $db_name;
$r=mysql($db_name,"SELECT ".$q_str);
return $r;
}

function qu($q_str){
global $db_name;
$r=mysql($db_name,"UPDATE ".$q_str);
return $r;
}

function qi($q_str){
global $db_name;
$r=mysql($db_name,"INSERT INTO ".$q_str);
eturn $r;
}

function d($db){
}

function e($r){
if(@mysql_numrows($r))return 0;
else return 1;
}

function f($r){
return mysql_fetch_array($r);
}

function nr($r){
return mysql_num_rows($r);
}

$dv=@c();

if (!$dv) {
echo "<h2>Header Here</h2><h4>This website is temporarily unavailable.<br>MySQL connection is not available. Please try again later.</h4><h5></h5>";
exit;
}

$rv=qs("* from sysvars");
while($va=f($rv)) {
${$va[name]}=$va[value];
};

d($dv);

function piurl($pid,$thumb=""){
$r=qs("picture, image from pictures where id='$pid'");

if (e($r)) $ur=$ROOT_HOST."images/na.gif";else

hehe

Now here's your problem.

function f($r){
return mysql_fetch_array($r);
}

What's $r? Nevermind.

$r=mysql($db_name,"SELECT ".$q_str);

hmmm anybody else?

Edited by Braunson, 28 March 2007 - 11:27 PM.

[SecondV]

Cleaned up

<?php

if (!$mysq_lib_loaded)
{
	function c()
	{
		global $db_host, $db_login, $db_pswd;
		return mysql_connect($db_host, $db_login, $db_pswd);
	}

	function q($q_str)
	{
		global $db_name;
		return mysql($db_name, $q_str);
	}

	function qd($q_str)
	{
		global $db_name;
		return mysql($db_name,"DELETE FROM $q_str");
	}

	function qs($q_str)
	{
		global $db_name;
		return mysql($db_name, "SELECT $q_str");
	}

	function qu($q_str)
	{
		global $db_name;
		return mysql($db_name, "UPDATE $q_str");
	}

	function qi($q_str)
	{
		global $db_name;
		return mysql($db_name, "INSERT INTO $q_str");
	}

	function d($db) {}

	function e($r)
	{
		return (@mysql_num_rows($r) > 0);
	}

	function f($r)
	{
		return mysql_fetch_array($r);
	}

	function nr($r)
	{
		return mysql_num_rows($r);
	}

	$dv = @c();

	if (!$dv)
	{
		echo "<h2>Header Here</h2><h4>This website is temporarily unavailable.<br>MySQL connection is not available. Please try again later.</h4><h5></h5>";
		exit;
	}

	$rv = qs("* FROM sysvars");

	while ($va = f($rv))
	{
		${$va['name']} = $va['value'];
	}

	d($dv);
	
	function piurl($pid, $thumb = '')
	{
		$r = qs("picture, image FROM pictures WHERE id='$pid'");

		if (e($r))
		{
			$ur = $ROOT_HOST . 'images/na.gif';
		}
		else

now, for your problem - could you post your mysql() function?