Querying via php

RGAnthony

New member
Local time
Today, 00:41
Joined
Jul 21, 2006
Messages
5
Hi,
Im trying to do a query using php and access,
Basically, the link to the page will be , index.php?company=COMPANY!

So what i want it to do is go into the table for that company and average out ratings which people have inserted.

I have tried this but no luck.

SELECT Avg([$company].[rating]) AS AvgOfrating FROM $company WHERE [status]=1;

Any ideas please?
 

Users who are viewing this thread

Back
Top Bottom