mysql_fetch_row(): supplied argument is not a valid MySQL

Secţiune dedicată începatorilor.

Moderatori: Moderatori, Start Moderator

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

mysql_fetch_row(): supplied argument is not a valid MySQL

Mesajde bresti » Mar Aug 17, 2010 2:14 pm

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /storage1/home/site/www/aff/common.php on line 55

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /storage1/home/site/www/aff/common.php on line 56



Linia 55:
list($pending_total) = mysql_fetch_row( mysql_query("SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type=2 AND paid=0") );



Linia 56:
list($paid_total) = mysql_fetch_row( mysql_query("SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type=2 AND paid=1") );



tot codu:

http://pastebin.com/uR3pknzs


catalin

narghilea
Junior Member
Mesaje: 43
Membru din: Joi Aug 05, 2010 1:18 pm

Mesajde narghilea » Mar Aug 17, 2010 2:32 pm

E problema la query. Fa pe parti mai intai, adica:
$query = SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type=2 AND paid=0";
$result = mysql_query($query) or die(mysql_error());
$list($pending_total) = mysql_fetch_row($result);

Am pus mysql_error() si o sa-ti arate unde e eroarea

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

Mesajde bresti » Mar Aug 17, 2010 2:49 pm

Parse error: syntax error, unexpected T_STRING in 58

adica in query
catalin

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

Mesajde bresti » Mar Aug 17, 2010 2:55 pm

$query = "SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type=2 AND paid=0";

uitaisei chestia asta "
catalin

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

Mesajde bresti » Mar Aug 17, 2010 3:03 pm

eroarea persista :
Parse error: syntax error, unexpected T_STRING in 58
catalin

narghilea
Junior Member
Mesaje: 43
Membru din: Joi Aug 05, 2010 1:18 pm

Mesajde narghilea » Mar Aug 17, 2010 3:40 pm

Cod: Selectaţi tot


$query = "SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type='2' AND paid='0'";

tanatos
Senior Member
Mesaje: 269
Membru din: Vin Iun 06, 2008 8:01 pm
Localitate: Iasi
Contact:

Mesajde tanatos » Mar Aug 17, 2010 6:47 pm

Cod: Selectaţi tot

$query = "SELECT SUM(`price`) FROM `affstats` WHERE `akey` = '".$affi['akey']."' AND `type` = '2' AND `paid` = '0'";

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

Mesajde bresti » Lun Aug 23, 2010 1:00 am

Fatal error: Can't use function return value in write context in /home/content/72/6545772/html/aff/common.php on line 64

Linia 64 :
$list($pending_total) = mysql_fetch_row($result);


nu vrea muschiul lui
catalin

Avatar utilizator
Sim Master
Average Member
Mesaje: 189
Membru din: Dum Aug 22, 2010 4:31 pm
Localitate: Timisoara
Contact:

Mesajde Sim Master » Lun Aug 23, 2010 1:23 am

nu cred ca poti sa-i atribui functia "mysql_fetch_row" sau orice altceva unei alte functii

bresti
Senior Member
Mesaje: 215
Membru din: Sâm Iun 24, 2006 5:03 am
Localitate: craiova
Contact:

Mesajde bresti » Joi Sep 09, 2010 4:29 pm

cu ce o pot inlocui :D
catalin

nevvermind
Senior Member
Mesaje: 1264
Membru din: Mar Iun 22, 2010 3:17 pm

Mesajde nevvermind » Joi Sep 09, 2010 11:38 pm

MySQL are "loose typing", in acelasi mod ca PHP, de aceea nu-i o idee prea buna sa "invelesti" numere in ghilimele; adica nu `type` = '2', ci `type` = 2.
cu ce o pot inlocui

Cu nimic. E-un mic typo: "$list($pending_total)" e de fapt "list($pending_total)".

Cod: Selectaţi tot

$query = "SELECT SUM(`price`) FROM `affstats` WHERE `akey` =  '{$affi['akey']}' AND `type` = 2 AND `paid` = 0";

$result = mysql_query($query) or die(mysql_error());

list($pending_total) = mysql_fetch_row($result);

// cum e doar o valoare, ai putea foarte bine si fara list()
$pending_total = mysql_fetch_row($result);


Înapoi la “PHP Incepători”

Cine este conectat

Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 80 vizitatori