Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 42
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 43
Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 46
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 47
Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 50
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 51
Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 54
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/sites/1/iespana.es/h/p/hpotterhispano/site/index.php on line 55
Y el code es:
Cita:
Les agradeceria =) Código PHP:
41.$query="SELECT SUM( `puntos_propios` ) as totalg FROM `usuarios` WHERE `casa`= ' Gryffindor' ";
42.$result=mysql_db_query($database,$query,$link);
43.$valores = mysql_fetch_array($result);
44.echo $valores["totalg"];
45.$query="SELECT SUM( `puntos_propios` ) as totalh FROM `usuarios` WHERE `casa`= ' Hufflepuff ' ";
46.$result=mysql_db_query($database,$query,$link);
47.$valores = mysql_fetch_array($result);
48.echo $valores["totalh"];
49.$query="SELECT SUM( `puntos_propios` ) as totals FROM `usuarios` WHERE `casa`= ' Slytherin ' ";
50.$result=mysql_db_query($database,$query,$link);
51.$valores = mysql_fetch_array($result);
52.echo $valores["totals"];
53.$query="SELECT SUM( `puntos_propios` ) as totalr FROM `usuarios` WHERE `casa`= ' Ravenclaw ' ";
54.$result=mysql_db_query($database,$query,$link);
55.$valores = mysql_fetch_array($result);
56.echo $valores["totalr"];