mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 3

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 3

am 03.09.2006 19:26:37 von powertech

Voici la ligne 3 de mysql.php :

if (!$mysq_lib_loaded){function c(){global $db_host, $db_login,
$db_pswd;$db=3Dmysql_connect($db_host,$db_login,$db_pswd);re turn
$db;}function q($q_str){global
$db_name;$r=3Dmysql($db_name,$q_str);return $r;}function
qd($q_str){global $db_name;$r=3Dmysql($db_name,"DELETE FROM
"$q_str);return $r;}function qs($q_str){global
$db_name;$r=3Dmysql($db_name,"SELECT ".$q_str);return $r;}function
qu($q_str){global $db_name;$r=3Dmysql($db_name,"UPDATE ".$q_str);return
$r;}function qi($q_str){global $db_name;$r=3Dmysql($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=3D@c();if (!$dv) {echo
"

Blablablabla

This website is temporarily
unavailable.
MySQL connection is not available. Please try again
later.

href=3Dhttp://www.enattendant.c0m
";exit;}$rv=3Dqs("* from
sysvars");while($va=3Df($rv)) {${$va[name]}=3D$va[value];};d($dv);function
piurl($pid,$thumb=3D""){$r=3Dqs("picture, image from pictures where
id=3D'$pid'");if (e($r)) $ur=3D$ROOT_HOST."images/na.gif";else


Le probl=E8me viendrait de l=E0... {return mysql_fetch_array($r) Mais
comme je d=E9bute en php, ce type d'erreur me donne de joyeux maux de
t=EAte! Si quelqu'un =E0 une solution ou un suggestion.... Ca serait
grandement appr=E9ci=E9! Aussi si quelqu'un pouvait me montrer comment
tester une requ=EAte (Un exemple de code) pour mon Fetch_array, ca me
permettrais de mieux saisir cette proc=E8dure! Merci!

Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 3

am 03.09.2006 21:09:24 von Anthony Frost

In message <1157304397.688216.310260@e3g2000cwe.googlegroups.com>
"powertech" wrote:

> Voici la ligne 3 de mysql.php :

[Crap code snipped]

> Le problème viendrait de là... {return mysql_fetch_array($r) Mais
> comme je débute en php, ce type d'erreur me donne de joyeux maux de
> tête! Si quelqu'un à une solution ou un suggestion....

For a start, format your code so it's legible! There is absolutely no
need to produce such bad layout. Secondly, check *all* your functions
for errors being returned. You've made a mistake in there somewhere that
will be easily spotted once you've done both those things.

Anthony

Re: mysql_fetch_array(): supplied argument is not a valid MySQL resultresource in line 3

am 03.09.2006 21:39:17 von IchBin

powertech wrote:
> Voici la ligne 3 de mysql.php :
>
> if (!$mysq_lib_loaded){function c(){global $db_host, $db_login,
> $db_pswd;$db=mysql_connect($db_host,$db_login,$db_pswd);retu rn
> $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
> "

Blablablabla

This website is temporarily
> unavailable.
MySQL connection is not available. Please try again
> later.

> href=http://www.enattendant.c0m
";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
>
>
> Le problème viendrait de là... {return mysql_fetch_array($r) Mais
> comme je débute en php, ce type d'erreur me donne de joyeux maux de
> tête! Si quelqu'un à une solution ou un suggestion.... Ca serait
> grandement apprécié! Aussi si quelqu'un pouvait me montrer comment
> tester une requête (Un exemple de code) pour mon Fetch_array, ca me
> permettrais de mieux saisir cette procèdure! Merci!
>

Désolé... C'est un newsgroup d'expression anglaise. Je ne parle pas
français. Votre code est inachevé. Il n'est pas bon de forcer d'autres à
composer votre code. Vous devez expliquer plus ou soumettre le code qui
peut être examiné. Quel est le message d'erreur qui vous obtenez ?


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 "

Blablablabla

This website is temporarily
unavailable.
MySQL connection is not available. Please try again
later.

";
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

--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)