ho fatto questo script per la query deviazione standard dei dati nel db.
ho usato la stessa struttura utilizzata per la media:
$query="SELECT
STD (test_arousal_photo1) as a1,
STD (test_valence_photo1) as v1,
STD (test_arousal_photo2) as a2,
STD (test_valence_photo2) as v2,
STD (test_arousal_photo3) as a3,
STD (test_valence_photo3) as v3,
STD(test_arousal_photo4) as a4,
STD(test_valence_photo4) as v4,
STD(test_arousal_photo5) as a5,
STD(test_valence_photo5) as v5,
STD(test_arousal_photo6) as a6,
STD(test_valence_photo6) as v6,
STD(test_arousal_photo7) as a7,
STD(test_valence_photo7) as v7,
STD(test_arousal_photo8) as a8,
STD(test_valence_photo8) as v8,
STD(test_arousal_photo9) as a9,
STD(test_valence_photo9) as v9,
STD(test_arousal_photo10) as a10,
STD(test_valence_photo10) as v10 FROM messaggi ";
$ris = mysql_query($query);
$rs = mysql_fetch_row($ris);
echo $rs["a1"];
echo "
" . $rs["v1"];
echo"
" . $rs["a2"];
echo "
" .$rs["v2"];
echo "
" .$rs["a3"];
echo "
" .$rs["v3"];
echo"
" . $rs["a4"];
echo "
" .$rs["v4"];
echo "
" .$rs["a5"];
echo"
" . $rs["v5"];
echo"
" . $rs["a6"];
echo"
" . $rs["v6"];
echo "
" .$rs["a7"];
echo"
" . $rs["v7"];
echo"
" . $rs["a8"];
echo"
" . $rs["v8"];
echo "
" .$rs["a9"];
echo"
" . $rs["v9"];
echo "
" .$rs["a10"];
echo"
" . $rs["v10"];
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\programmi\easyphp1-8\www\finalstat.php on line 79
Rispondi quotando
