visualizzare media

[giorgiodp]

ho questa query:

$query="SELECT
AVG('test_arousal_photo1'),
AVG('test_valence_photo1'),
AVG('test_arousal_photo2'),
AVG('test_valence_photo2'),
AVG('test_arousal_photo3'),
AVG(test_valence_photo3),
AVG(test_arousal_photo4),
AVG(test_valence_photo4),
AVG(test_arousal_photo5),
AVG(test_valence_photo5),
AVG(test_arousal_photo6),
AVG(test_valence_photo6),
AVG(test_arousal_photo7),
AVG(test_valence_photo7),
AVG(test_arousal_photo8),
AVG(test_valence_photo8),
AVG(test_arousal_photo9),
AVG(test_valence_photo9),
AVG(test_arousal_photo10),
AVG(test_valence_photo10) FROM messaggi ";

come visualizzo il rislutato?

[sonounostrinato]

$query="SELECT 
AVG('test_arousal_photo1') as a1,
AVG('test_valence_photo1') as v1,
AVG('test_arousal_photo2') as a2,
AVG('test_valence_photo2') as v2,
AVG('test_arousal_photo3') as a3 ................. FROM messaggi ";
$ris = mysql_query($sql);
$rs = mysql_fetch_array($ris);
echo $rs["a1"];
echo $rs["v1"];
echo $rs["a2"];
echo $rs["v2"];
....... 

Prova cosi!

[giorgiodp]

ho fatto cosi':
$query="SELECT
AVG('test_arousal_photo1') as a1,
AVG('test_valence_photo1') as v1,
AVG('test_arousal_photo2') as a2,
AVG('test_valence_photo2') as v2,
AVG('test_arousal_photo3') as a3,
AVG(test_valence_photo3) as v3,
AVG(test_arousal_photo4) as a4,
AVG(test_valence_photo4) as v4,
AVG(test_arousal_photo5) as a5,
AVG(test_valence_photo5) as v5,
AVG(test_arousal_photo6) as a6,
AVG(test_valence_photo6) as v6,
AVG(test_arousal_photo7) as a7,
AVG(test_valence_photo7) as v7,
AVG(test_arousal_photo8) as a8,
AVG(test_valence_photo8) as v8,
AVG(test_arousal_photo9) as a9,
AVG(test_valence_photo9) as v9,
AVG(test_arousal_photo10) as a10,
AVG(test_valence_photo10) as v10 FROM messaggi ";

$ris = mysql_query($sql);
$rs = mysql_fetch_array($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"];

mi dice questo:

Notice: Undefined variable: mysql in c:\programmi\easyphp1-8\www\finalstat.php on line 28

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\programmi\easyphp1-8\www\finalstat.php on line 29

[sonounostrinato]

Dimmi le righe vicino alla 28

il supporto da php x mysql è installato vero?

[giorgiodp]

riga 28,28:


$ris = mysql_query($sql);
$rs = mysql_fetch_array($ris);

il supporto da php x mysql ...
come controllo se è installato?

[sonounostrinato]

La connessione al server con mysql_connect la esegue senza restituire errori?

questa riga

$ris = mysql_query($sql);

falla diventare cosi


$ris = mysql_query($query);

e riprova

[giorgiodp]

00000-0.4000-0.4000-0.8000-0.40000.0000-0.40000.00000.0000-0.8000-0.8000-0.4000

mi appare un risultato cosi'...mi sembra un po' strano...

[sonounostrinato]

hai provato a cambiare la variabile come ti ho detto?

[giorgiodp]

si si..
adesso le variabili sono cosi':

$ris = mysql_query($query);
$rs = mysql_fetch_array($ris);

[sonounostrinato]

e l'errore? funziona lo script?