Voila, je ne m'y connait pas trop en php, donc si on pouvait juste me donner une solution simple
Je voudrais intégrer un "top 10" pour mon site, et j'ai donc testé deux scripts différents. Mais voila j'obtiens le même message pour les deux scripts :
Script 1 :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/free.fr/4/5/*****/statclic/admin.php3 on line 24
ligne 24 :
CODE
22 $link = mysql_connect($dbserver, $dbuser, $dbpass);
23 $result = mysql_db_query($dbname, "SELECT * FROM famille");
24 while ($row = mysql_fetch_array($result)) {
25 ?>
23 $result = mysql_db_query($dbname, "SELECT * FROM famille");
24 while ($row = mysql_fetch_array($result)) {
25 ?>
Script 2 :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home.2/****/www/clic/stats.php on line 42
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home.2/****/www/clic/stats.php on line 52
ligne 42 et 52 :
CODE
36 <?
37
38 $connect= mysql_connect($host,$login,$pass);
39 mysql_select_db($base, $connect);
40 $query = "select sum(clic) from mclinkscounter";
41 $res = mysql_query($query, $connect);
42 $total = mysql_fetch_array($res);
43 ?>
49 <?
50 $query = "select cat, sum(clic) from mclinkscounter group by cat order by cat";
51 $res = mysql_query($query, $connect);
52 while ($categ = mysql_fetch_array($res))
53 {
37
38 $connect= mysql_connect($host,$login,$pass);
39 mysql_select_db($base, $connect);
40 $query = "select sum(clic) from mclinkscounter";
41 $res = mysql_query($query, $connect);
42 $total = mysql_fetch_array($res);
43 ?>
49 <?
50 $query = "select cat, sum(clic) from mclinkscounter group by cat order by cat";
51 $res = mysql_query($query, $connect);
52 while ($categ = mysql_fetch_array($res))
53 {
Ca me le fait aussi bien sur Free que sur Ovh. Quand je vais sur DW, la tableau s'affiche correctement...
Bref une idée ?