SQL parsing problem

[Anon]

Is it problem to get out average numbbers??

$Query="SELECT ";
$Query.="AVG(SVAR.SV1), ";
$Query.="AVG(SVAR.SV2), ";
$Query.="AVG(SVAR.SV3), ";
$Query.="AVG(SVAR.SV4), ";
$Query.="AVG(SVAR.SV5), ";
$Query.="AVG(SVAR.SV6), ";
$Query.="AVG(SVAR.SV7), ";
$Query.="AVG(SVAR.SV8), ";
$Query.="AVG(SVAR.SV9), ";
$Query.="AVG(SVAR.SV10), ";
$Query.="AVG(SVAR.SV11), ";
$Query.="AVG(SVAR.SV12) ";
$Query.="FROM SVAR, KLASSE, FAGPLAN, ADMINPASS, FAG, FORELESER ";
$Query.="WHERE ADMINPASS.BRUKERNAVN = '$brukernavn' ";
$Query.="AND ADMINPASS.STUDIESTEDKODE = FAGPLAN.STUDIESTEDKODE ";
$Query.="AND SVAR.FAGPLANNR = FAGPLAN.FAGPLANNR ";
$Query.="AND FAGPLAN.FORELESERNR = FORELESER.FORELESERNR ";
$Query.="AND FORELESER.ETTERNAVN = '$etternavn' ";
$Query.="AND FORELESER.FORNAVN = '$fornavn' ";
$Query.="AND FAGPLAN.FAGKODE = FAG.FAGKODE ";
$Query.="AND FAG.FAGNAVN = '$fag' ";
$Query.="AND KLASSE.KLASSE = FAGPLAN.KLASSE ";
$Query.="AND KLASSE.KLASSE = '$klasse' ";

is the $Query.="AVG(SVAR.SV1), "; any problem???

thanks

[Anon]

No, don't think so. Why? What's the error?

Diego

[Anon]

Didn't fetch any... 🙁

[Anon]

Did you get any MySQL errors? Use mysql_error() to check. And if that's not the problem, then the problem is in the WHERE statements...Maybe your WHERE statements are setup wrong so it doesn't return any records.

Diego

[Anon]

It's actually a Oracle commando
Would that be a problem???

else, I've tested the SQL in line-commando.. Everything is going well there...
Getting nothing from error

[Anon]

One test I do in situations like this is to echo the final $Query instead of sending it to the database; then feed the copy&paste it directly into the DBMS. That way I get to see what I'm really sending to the DBMS.

How are you asking for the returned results? How many rows are returned - since this is an aggregate function, there should be exactly one.