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?
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?