Sigue el mismo error:
Código:
$sql = "SELECT SUM(zeny) AS z FROM char";
$zRes = mysql_query($sql);
if(mysql_num_rows($zRes)>0){
$row = mysql_fetch_assoc($zRes);
echo $row['z'];
}
He quitado el WHERE que daba problemas, y me sale:
[quote]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/skyteam/www/regacc/server/info.php on line 16
Aldebaran(Neuschwanstein): | Prontera(Fadhgridh): | Payon(Sacred Altar):
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'char' at line 1
[quote]
Línea 16 es "$row = mysql_fetch_assoc($zRes);".