Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: PHP AVG Query
01-22-2014, 11:52 AM #1
- Join Date
- Jan 2013
- Thanked 0 Times in 0 Posts
PHP AVG Query
First of all, thanks to everyone who advised me and pointed me in the direction of a MySQL tut on my last post, it has helped enormously.
Just wondering if anyone could help me out on the below:
I have a MySQL table that has data from surveys and is identified by an ID per review.
I'm trying to get the PHP script to calculate the average of 10 columns across th row - is this possibe? The code I'm trying to use is:
$avgtocalc = mysql_real_escape_string($_GET['ad1']); $average = mysql_query("SELECT * FROM reviewdata WHERE address='$avgtocalc' AND published LIKE 'Live' AVG ('livedthere' + 'parking' + 'crime' + 'noiseneighbours' + 'noisetraffic' + 'distanceshops' + 'distanceschools' + 'conditionpavements' + 'conditionroads' + 'nightlighting')/(10) ") or die(mysql_error());
Does anyone have any ideas? I've Googled this to death but can't find what I need.
Thanks in advance
01-22-2014, 01:38 PM #2
- Join Date
- Sep 2002
- Saskatoon, Saskatchewan
- Thanked 2,668 Times in 2,637 Posts
Using quotations are literal in SQL. That will try to add the strings, use either the accent grave (`) or preferably nothing if you don't use reserved words or spaces.
The location itself is probably wrong. If you want to select that, you need to place it within the columns to select of the query. This is sitting somewhere in the WHERE clause. On the other hand, if you want to use it for a where clause, you would then need to use a group and a HAVING in order to do it.
I would suggest aliasing it as well, otherwise you'll need to use a fetch_row command in order to offset it numerically, iterate the resultset with a foreach, or use the associative value of what that expression is.
Also this has nothing to do with PHP, moving to MySQL forum.PHP Code:
header('HTTP/1.1 420 Enhance Your Calm');