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
mysql_fetch_row(): supplied argument is not a valid MySQL
Moderatori: Moderatori, Start Moderator
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
$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
Cod: Selectaţi tot
$query = "SELECT SUM(price) FROM affstats WHERE akey= '{$affi['akey']}' AND type='2' AND paid='0'";
Cod: Selectaţi tot
$query = "SELECT SUM(`price`) FROM `affstats` WHERE `akey` = '".$affi['akey']."' AND `type` = '2' AND `paid` = '0'";
- Sim Master
- Average Member
- Mesaje: 189
- Membru din: Dum Aug 22, 2010 4:31 pm
- Localitate: Timisoara
- Contact:
-
- Senior Member
- Mesaje: 1264
- Membru din: Mar Iun 22, 2010 3:17 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 nimic. E-un mic typo: "$list($pending_total)" e de fapt "list($pending_total)".
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);
Cine este conectat
Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 80 vizitatori