silverglade Posted February 26, 2010 Share Posted February 26, 2010 hi, i have a huge amount of code on one page, and i cant find the error, here is what the browser error is telling me You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as character, avg(training_ability) as training_ability, avg(gives_recognition' at line 33 it is in the lower part of my page possibly, but i checked all the lines that i used "avg" and it looks perfect. so im at a loss. any help GREATLY appreciated. thanks. derek. here is the code <?php //include("connect1.php"); $server = 'brendansite1.startlogicmysql.com'; $user = 'silverglade'; $password = 'brendandm'; $database = 'dolrich_clients'; $link = mysql_connect($server, $user, $password); mysql_select_db($database,$link); error_reporting(E_ALL); //error reporting php function //////////////////////////////////////// //////////////////////////////////////// // escape username and password for use in SQL//person said on board "looks fine" like this //to prevent sql injections // This function will prevent errors from other servers that will throw // error when you acces variables that are not yet set. // We first check if the variable exist, in case it exist return the variable // else return empty space function post($fieldname = '', $default = '') { return (isset($_POST[$fieldname])) ? $_POST[$fieldname] : $default; } // I created a function to return a letter to a specific grade // You just pass a number and it will return the letter for that number function grade($final_grade = 1) { if($final_grade <= .5) $value = 'F-'; elseif($final_grade <= 1) $value = 'F'; elseif($final_grade < 1.5) $value = 'D-'; elseif($final_grade <= 2) $value = 'D'; elseif($final_grade <= 2.5) $value = 'C-'; elseif($final_grade <= 3) $value = 'C'; elseif($final_grade <= 3.5) $value = 'B-'; elseif($final_grade <= 4) $value = 'B'; elseif($final_grade <= 4.5) $value = 'A-'; elseif($final_grade <= 5) $value = 'A'; else $value = 'Undefined'; return $value; } if($_POST) { //If you want to disable multiple voting of a user to the same company, set to true $check_user = FALSE; $employer = post('employer'); $zip = post('zip'); // We are typecasting int variable, this will make sure that this fields are int type // This also prevent sql injection. Use this only if you are expecting int variables $courtesy = (int) post('courtesy',1); $loyalty = (int) post('loyalty',1); $stability = (int) post('stability',1); $attitude = (int) post('attitude',1); $turnover_rate = (int) post('turnover_rate',1);//quit rate $work_stress = (int) post('work_stress',1); $work_safety = (int) post('work_safety',1); $employee_treatment = (int) post('employee_treatment',1);//does not invalidate employee $competence = (int) post('competence',1); $reliability = (int) post('reliability',1); $pay_compensation = (int) post('pay_compensation',1); $work_environment = (int) post('work_environment',1); $medical_benefits = (int) post('medical_benefits',1); $experience = (int) post('experience',1); $respectfulness = (int) post('respectfulness',1); $fairness = (int) post('fairness',1); $positive_motivator = (int) post('positive_motivator',1); $foresight = (int) post('foresight',1); $insight = (int) post('insight',1); $negotiator = (int) post('negotiator',1); $stamina = (int) post('stamina',1); $perseverance = (int) post('perseverance',1); $assertive = (int) post('assertive',1); $planner = (int) post('planner',1); $level_headed = (int) post('level_headed',1); $even_tempered = (int) post('even_tempered',1); $constructive_criticism = (int) post('constructive_criticism',1);//gives constructive criticism $anger_management = (int) post('anger_management',1);//does not take out frustrations on employee $trouble_shooter = (int) post('trouble_shooter',1); $business_knowledge = (int) post('business_knowledge',1);//knowledgeable of the business $honesty = (int) post('honesty',1); $integrity = (int) post('integrity',1); $courage = (int) post('courage',1); $character = (int) post('character',1); $training_ability = (int) post('training_ability',1); $gives_recognition = (int) post('gives_recognition',1);//gives recognition to employees $instills_trust = (int) post('instills_trust',1); $supportive = (int) post('supportive',1); $empathy = (int) post('empathy',1); $consistency = (int) post('consistency',1); $employer = strtolower(mysql_real_escape_string($employer)); $zip = mysql_real_escape_string($zip); $find = post('find'); $find = mysql_real_escape_string($find); $total = 40; $sum = $courtesy + $loyalty + $stability + $attitude + $turnover_rate + $work_stress + $work_safety + $employee_treatment + $competence + $reliability + $pay_compensation + $work_environment + $medical_benefits + $experience + $respectfulness + $fairness + $positive_motivator + $foresight + $insight + $negotiator + $stamina + $perseverance + $assertive + $planner + $level_headed + $even_tempered + $constructive_criticism + $anger_management + $trouble_shooter + $business_knowledge + $honesty + $integrity + $courage + $character + $training_ability + $gives_recognition + $instills_trust + $supportive + $empathy + $consistency; $average = $sum/$total; } /* * Process the user votes */ if(isset($_POST['Vote'])) { echo "You have given ".$employer ." a grade of <strong>".grade($average).".</strong> "; echo '<br /><br />courtesy: '.grade($courtesy).'<br />'; echo 'stability: '.grade($stability).'<br />'; echo 'loyalty: '.grade($loyalty).'<br />'; echo 'attitude: '.grade($attitude).'<br />'; echo 'turnover rate (quit rate):' .grade($turnover_rate).'<br />'; echo 'work stress:'.grade($work_stress).'<br />'; echo 'work safety:'.grade($work_safety).'<br />'; echo 'employee treatment:'.grade($employee_treatment).'<br />';//does not invalidate employee echo 'competence:'.grade($competence).'<br />'; echo 'reliability:'.grade($reliability).'<br />'; echo 'pay/compensation:'.grade($pay_compensation).'<br />'; echo 'work environment:'.grade($work_environment).'<br />'; echo 'medical benefits:'.grade($medical_benefits).'<br />'; echo 'experience:'.grade($experience).'<br />'; echo 'respectfulness:'.grade($respectfulness).'<br />'; echo 'courtesy:'.grade($courtesy).'<br />'; echo 'fairness:'.grade($fairness).'<br />'; echo 'positive motivator:'.grade($positive_motivator).'<br />'; echo 'foresight:'.grade($foresight).'<br />'; echo 'insight:'.grade($insight).'<br />'; echo 'negotiator:'.grade($negotiator).'<br />'; echo 'stamina:'.grade($stamina).'<br />'; echo 'perseverance:'.grade($perseverance).'<br />'; echo 'assertive:'.grade($assertive).'<br />'; echo 'planner:'.grade($planner).'<br />'; echo 'level headed:'.grade($level_headed).'<br />'; echo 'even tempered:'.grade($even_tempered).'<br />'; echo 'constructive criticism:'.grade($constructive_criticism).'<br />';//gives constructive criticism echo 'anger management'.grade($anger_management).'<br />';//does not take out frustrations on employee echo 'trouble shooter:'.grade($trouble_shooter).'<br />'; echo 'business knowledge:'.grade($business_knowledge).'<br />';//knowledgeable of the business echo 'honesty:'.grade($honesty).'<br />'; echo 'integrity:'.grade($integrity).'<br />'; echo 'courage:'.grade($courage).'<br />'; echo 'character:'.grade($character).'<br />'; echo 'training ability:'.grade($training_ability).'<br />';// trainer echo 'gives recognition:'.grade($gives_recognition).'<br />';//gives recognition to employees echo 'instills trust:'.grade($instills_trust).'<br />'; echo 'supportive:'.grade($supportive).'<br />'; echo 'empathy:'.grade($empathy).'<br />'; echo 'consistency:'.grade($consistency).'<br />'; $process_vote = TRUE; //This is the simplest method for getting a users ip $ip = $_SERVER['REMOTE_ADDR']; if($check_user) { //Check wether the user has already voted for the same company $sql = "SELECT * FROM voters WHERE ip='{$ip}' AND zip='{$zip}' AND employer='{$employer}'"; $query = mysql_query($sql); //If the user has already voted for the same employer, set $process_vote to false if(mysql_num_rows($query)>0) { $process_vote = FALSE; } } //Check whether we need to process the user votes if($process_vote) { //Determine first if the employer is already in the database $sql = "SELECT votes, id FROM friendgrade WHERE employer='{$employer}' AND zip='{$zip}'"; $query = mysql_query($sql); //If there is already the same employer in the database //We are not going to add it anymore, we just need to update the votes if(mysql_num_rows($query) > 0) { $result = mysql_fetch_array($query); $employer_id = $result['id']; $votes = $result['votes'] + 1; // Add additional vote //Where going to update the number of votes for the employer $sql = "UPDATE friendgrade SET votes='{$votes}' WHERE id='{$employer_id}'"; mysql_query($sql); // Where going to add the votes details(courtesy, loyalty ..) on the votes table $sql = "INSERT INTO votes (grade_id,loyalty,courtesy,stability,attitude,turnover_rate, work_stress, work_safety, employee_treatment , competence, reliability, pay_compensation, work_environment, medical_benefits, experience, respectfulness, fairness, positive_motivator, foresight, insight, negotiator, stamina, perseverance, assertive, planner, level_headed, even_tempered, constructive_criticism , anger_management , trouble_shooter, business_knowledge , honesty, integrity, courage, character , training_ability, gives_recognition , instills_trust, supportive, empathy, consistency) VALUES('$employer_id','{$loyalty}','{$courtesy}','{$stability}','{$attitude}', '{$turnover_rate}', '{$work_stress}', '{$work_safety}', '{$employee_treatment} ', '{$competence}', '{$reliability}', '{$pay_compensation}', '{$work_environment}', '{$medical_benefits}', '{$experience}', '{$respectfulness}', '{$fairness}', '{$positive_motivator}', '{$foresight}', '{$insight}', '{$negotiator}', '{$stamina}', '{$perseverance}', '{assertive}', '{planner}', '{$level_headed}', '{$even_tempered}', '{$constructive_criticism}', '{$anger_management}', '{$trouble_shooter}', '{$business_knowledge}', '{$honesty}', '{$integrity}', '{$courage}', '{$character}', '{$training_ability}', '{$gives_recognition}', '{$instills_trust}', '{$supportive}', '{$empathy}', '{$consistency}')"; mysql_query($sql); } else { //If the employer is not yet in the database //then we need to add employer data on the friendgrade table $sql = "INSERT INTO friendgrade (employer,zip,votes) VALUES('{$employer}','{$zip}','1')"; mysql_query($sql); //We get the insert id from the query above $employer_id = mysql_insert_id(); //We now insert the votes on the votes table $sql = "INSERT INTO votes (grade_id,loyalty,courtesy,stability,attitude,turnover_rate, work_stress, work_safety, employee_treatment , competence, reliability, pay_compensation, work_environment, medical_benefits, experience, respectfulness, fairness, positive_motivator, foresight, insight, negotiator, stamina, perseverance, assertive, planner, level_headed, even_tempered, constructive_criticism , anger_management , trouble_shooter, business_knowledge , honesty, integrity, courage, character , training_ability, gives_recognition , instills_trust, supportive, empathy, consistency) VALUES('$employer_id','{$loyalty}','{$courtesy}','{$stability}','{$attitude}', '{$turnover_rate}', '{$work_stress}', '{$work_safety}', '{$employee_treatment} ', '{$competence}', '{$reliability}', '{$pay_compensation}', '{$work_environment}', '{$medical_benefits}', '{$experience}', '{$respectfulness}', '{$fairness}', '{$positive_motivator}', '{$foresight}', '{$insight}', '{$negotiator}', '{$stamina}', '{$perseverance}', '{assertive}', '{planner}', '{$level_headed}', '{$even_tempered}', '{$constructive_criticism}', '{$anger_management}', '{$trouble_shooter}', '{$business_knowledge}', '{$honesty}', '{$integrity}', '{$courage}', '{$character}', '{$training_ability}', '{$gives_recognition}', '{$instills_trust}', '{$supportive}', '{$empathy}', '{$consistency}')"; mysql_query($sql); } } else { echo '<br />You have already voted for this employer!<br />'; } } // End of processing of user votes //output the friend's row into an array and average all rows of his attributes. if(isset($_POST['submit'])) { $query="SELECT id, employer, votes FROM friendgrade WHERE employer = '$find'"; $result=mysql_query($query); if(mysql_num_rows($result) > 0) { //put friends row into an array $userinfo $userinfo = mysql_fetch_array($result); $employer_id = $userinfo['id']; $votes = $userinfo['votes']; //Get the average votes in the votes table for a specific employer $sql = "SELECT avg(courtesy) as courtesy, avg(stability) as stability, avg(loyalty) as loyalty, avg(attitude) as attitude, avg(turnover_rate) as turnover_rate, avg(work_stress) as work_stress, avg(work_safety) as work_safety, avg(employee_treatment) as employee_treatment , avg(competence) as competence, avg(reliability) as reliability, avg(pay_compensation) as pay_compensation, avg(work_environment) as work_environment, avg(medical_benefits) as medical_benefits, avg(experience) as experience, avg(respectfulness) as respectfulness, avg(fairness) as fairness, avg(positive_motivator) as positive_motivator, avg(foresight) as foresight, avg(insight) as insight, avg(negotiator) as negotiator, avg(stamina) as stamina, avg(perseverance) as perseverance, avg(assertive) as assertive, avg(planner) as planner, avg(level_headed) as level_headed, avg(even_tempered) as even_tempered, avg(constructive_criticism) as constructive_criticism , avg(anger_management) as anger_management, avg(trouble_shooter) as trouble_shooter, avg(business_knowledge) as business_knowledge, avg(honesty) as honesty, avg(integrity) as integrity, avg(courage) as courage, avg(character) as character, avg(training_ability) as training_ability, avg(gives_recognition) as gives_recognition, avg(instills_trust) as instills_trust, avg(supportive) as supportive, avg(empathy) as empathy, avg(consistency) as consistency FROM votes WHERE grade_id='{$employer_id}'"; $result = mysql_query($sql) or die(mysql_error()); //put votes info in $votesinfo $voteinfo = mysql_fetch_array($result); //compute final grade $final_grade= ($voteinfo['courtesy']+$voteinfo['stability']+$voteinfo['loyalty']+$voteinfo['attitude'] +$voteinfo['turnover_rate']+$voteinfo['work_stress']+$voteinfo['work_safety']+$voteinfo['employee_treatment']+$voteinfo['competence']+$voteinfo['reliability']+$voteinfo['pay_compensation']+$voteinfo['work_environment']+$voteinfo['medical_benefits']+$voteinfo['experience']+$voteinfo['respectfulness']+$voteinfo['fairness']+$voteinfo['positive_motivator']+$voteinfo['foresight']+$voteinfo['insight']+$voteinfo['negotiator']+$voteinfo['stamina']+$voteinfo['perseverance']+$voteinfo['assertive']+$voteinfo['planner']+$voteinfo['level_headed']+$voteinfo['even_tempered']+$voteinfo['constructive_criticism']+$voteinfo['anger_management']+$voteinfo['trouble_shooter']+$voteinfo['business_knowledge']+$voteinfo['honesty']+$voteinfo['integrity']+$voteinfo['courage']+$voteinfo['character']+$voteinfo['training_ability']+$voteinfo['gives_recognition']+$voteinfo['instills_trust']+$voteinfo['supportive']+$voteinfo['empathy']+$voteinfo['consistency'] )/40; if($final_grade > 5)//this is error message if over 5 dont complete { echo "Odd results ".$userinfo['employer']." $final_grade ".$voteinfo['courtesy']." ".$voteinfo['stability']." ".$voteinfo['loyalty']." ".$voteinfo['attitude']."<br />"; } else { echo ucfirst($userinfo['employer'])." has an overall average grade of <strong>".grade($final_grade).".</strong> ". $userinfo['votes'] . " people voted."; } echo '<br /><br />Average Courtesy: '.grade($voteinfo['courtesy']).'<br />'; echo 'Average Stability: '.grade($voteinfo['stability']).'<br />'; echo 'Average Loyalty: '.grade($voteinfo['loyalty']).'<br />'; echo 'Average Attitude: '.grade($voteinfo['attitude']).'<br />'; echo 'Average Turnover Rate (quit rate): '.grade($voteinfo['turnover_rate']).'<br />'; echo 'Average Work Stress: '.grade($voteinfo['work_stress']).'<br />'; echo 'Average Work Safety: '.grade($voteinfo['work_safety']).'<br />'; echo 'Average Employee Treatment: '.grade($voteinfo['employee_treatment']).'<br />'; echo 'Average Competence: '.grade($voteinfo['competence']).'<br />'; echo 'Average Reliability: '.grade($voteinfo['reliability']).'<br />'; echo 'Average Pay/Compensation: '.grade($voteinfo['pay_compensation']).'<br />'; echo 'Average Work Environment: '.grade($voteinfo['work_environment']).'<br />'; echo 'Average Medical Benefits: '.grade($voteinfo['medical_benefits']).'<br />'; echo 'Average Experience: '.grade($voteinfo['experience']).'<br />'; echo 'Average Respectfulness: '.grade($voteinfo['respectfulness']).'<br />'; echo 'Average Fairness: '.grade($voteinfo['fairness']).'<br />'; echo 'Average Positive motivator: '.grade($voteinfo['positive_motivator']).'<br />'; echo 'Average Foresight: '.grade($voteinfo['foresight']).'<br />'; echo 'Average Insight: '.grade($voteinfo['insight']).'<br />'; echo 'Average Negotiator: '.grade($voteinfo['negotiator']).'<br />'; echo 'Average Stamina: '.grade($voteinfo['stamina']).'<br />'; echo 'Average Perseverance: '.grade($voteinfo['perseverance']).'<br />'; echo 'Average Assertive: '.grade($voteinfo['assertive']).'<br />'; echo 'Average Planner: '.grade($voteinfo['planner']).'<br />'; echo 'Average Level Headed: '.grade($voteinfo['level_headed']).'<br />'; echo 'Average Even Tempered: '.grade($voteinfo['even_tempered']).'<br />'; echo 'Average Constructive Criticism: '.grade($voteinfo['constructive_criticism']).'<br />'; echo 'Average Anger Management: '.grade($voteinfo['anger_management']).'<br />'; echo 'Average Trouble Shooter: '.grade($voteinfo['trouble_shooter']).'<br />'; echo 'Average Business Knowledge: '.grade($voteinfo['business_knowledge']).'<br />'; echo 'Average Honesty: '.grade($voteinfo['honesty']).'<br />'; echo 'Average Integrity: '.grade($voteinfo['integrity']).'<br />'; echo 'Average Courage: '.grade($voteinfo['courage']).'<br />'; echo 'Average Character: '.grade($voteinfo['character']).'<br />'; echo 'Average Training Ability: '.grade($voteinfo['training_ability']).'<br />'; echo 'Average Gives Recognition: '.grade($voteinfo['gives_recognition']).'<br />'; echo 'Average Instills Trust: '.grade($voteinfo['instills_trust']).'<br />'; echo 'Average Supportive: '.grade($voteinfo['supportive']).'<br />'; echo 'Average Empathy: '.grade($voteinfo['empathy']).'<br />'; echo 'Average Consistency: '.grade($voteinfo['consistency']).'<br />'; } else { echo '<br >The employer you searched for is not yet in the database<br />'; } }//end isset ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Update Statement</title> <style type="text/css"> <!-- .style1 {color: #990000} .style2 {color: #0066FF} .style3 {color: #0000CC} .style4 {color: #993399} --> </style> </head> <body> <div align="center">WELCOME TO THE BOSS GRADER</div> <p>Please enter an employer and their zip code, then rate them with the following criteria.<span class="style4"></span><br /></p> <form id="form1" name="form1" method="post" action=""> <table border="0"> <tr> <td>Employer</td> <td> <input name="employer" type="text" id="employer" /></td> </tr> <tr> <td>zip code</td> <td> <input name="zip" type="text" id="zip" /> </td> </tr> <tr> <td>courtesy</td> <td><table> <tr> <td> <input type="radio" name="courtesy" value="1" id="RadioGroup1_0" /> very poor <input type="radio" name="courtesy" value="2" id="RadioGroup1_1" /> poor <input type="radio" name="courtesy" value="3" id="RadioGroup1_2" /> ok <input type="radio" name="courtesy" value="4" id="RadioGroup1_3" /> good <input type="radio" name="courtesy" value="5" id="RadioGroup1_4" /> excellent </td> </tr> </table></td> </tr> <tr> <td>stability</td> <td> <input type="radio" name="stability" id="very_poor3" value="1" /> very poor <input type="radio" name="stability" id="poor3" value="2" /> poor <input type="radio" name="stability" id="ok3" value="3" /> ok <input type="radio" name="stability" id="good3" value="4" /> good <input type="radio" name="stability" id="excellent3" value="5" /> excellent </td> </tr> <tr> <td>loyalty</td> <td><input type="radio" name="loyalty" id="very_poor4" value="1" /> very poor <input type="radio" name="loyalty" id="poor4" value="2" /> poor <input type="radio" name="loyalty" id="ok4" value="3" /> ok <input type="radio" name="loyalty" id="good4" value="4" /> good <input type="radio" name="loyalty" id="excellent4" value="5" /> excellent </td> </tr> <tr> <td>attitude</td> <td><input type="radio" name="attitude" id="very_poor5" value="1" /> very poor <input type="radio" name="attitude" id="poor5" value="2" /> poor <input type="radio" name="attitude" id="ok5" value="3" /> ok <input type="radio" name="attitude" id="good5" value="4" /> good <input type="radio" name="attitude" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>turnover rate (quit rate)</td> <td><input type="radio" name="turnover_rate" id="very_poor5" value="1" /> very poor <input type="radio" name="turnover_rate" id="poor5" value="2" /> poor <input type="radio" name="turnover_rate" id="ok5" value="3" /> ok <input type="radio" name="turnover_rate" id="good5" value="4" /> good <input type="radio" name="turnover_rate" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>work_stress</td> <td><input type="radio" name="work_stress" id="very_poor5" value="1" /> very poor <input type="radio" name="work_stress" id="poor5" value="2" /> poor <input type="radio" name="work_stress" id="ok5" value="3" /> ok <input type="radio" name="work_stress" id="good5" value="4" /> good <input type="radio" name="work_stress" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>work safety</td> <td><input type="radio" name="work_safety" id="very_poor5" value="1" /> very poor <input type="radio" name="work_safety" id="poor5" value="2" /> poor <input type="radio" name="work_safety" id="ok5" value="3" /> ok <input type="radio" name="work_safety" id="good5" value="4" /> good <input type="radio" name="work_safety" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>employee treatment</td> <td><input type="radio" name="employee_treatment" id="very_poor5" value="1" /> very poor <input type="radio" name="employee_treatment" id="poor5" value="2" /> poor <input type="radio" name="employee_treatment" id="ok5" value="3" /> ok <input type="radio" name="employee_treatment" id="good5" value="4" /> good <input type="radio" name="employee_treatment" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>competence</td> <td><input type="radio" name="competence" id="very_poor5" value="1" /> very poor <input type="radio" name="competence" id="poor5" value="2" /> poor <input type="radio" name="competence" id="ok5" value="3" /> ok <input type="radio" name="competence" id="good5" value="4" /> good <input type="radio" name="competence" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>reliability</td> <td><input type="radio" name="reliability" id="very_poor5" value="1" /> very poor <input type="radio" name="reliability" id="poor5" value="2" /> poor <input type="radio" name="reliability" id="ok5" value="3" /> ok <input type="radio" name="reliability" id="good5" value="4" /> good <input type="radio" name="reliability" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>pay/compensation</td> <td><input type="radio" name="pay_compensation" id="very_poor5" value="1" /> very poor <input type="radio" name="pay_compensation" id="poor5" value="2" /> poor <input type="radio" name="pay_compensation" id="ok5" value="3" /> ok <input type="radio" name="pay_compensation" id="good5" value="4" /> good <input type="radio" name="pay_compensation" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>work environment</td> <td><input type="radio" name="work_environment" id="very_poor5" value="1" /> very poor <input type="radio" name="work_environment" id="poor5" value="2" /> poor <input type="radio" name="work_environment" id="ok5" value="3" /> ok <input type="radio" name="work_environment" id="good5" value="4" /> good <input type="radio" name="work_environment" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>medical benefits</td> <td><input type="radio" name="medical_benefits" id="very_poor5" value="1" /> very poor <input type="radio" name="medical_benefits" id="poor5" value="2" /> poor <input type="radio" name="medical_benefits" id="ok5" value="3" /> ok <input type="radio" name="medical_benefits" id="good5" value="4" /> good <input type="radio" name="medical_benefits" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>experience</td> <td><input type="radio" name="experience" id="very_poor5" value="1" /> very poor <input type="radio" name="experience" id="poor5" value="2" /> poor <input type="radio" name="experience" id="ok5" value="3" /> ok <input type="radio" name="experience" id="good5" value="4" /> good <input type="radio" name="experience" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>respectfulness</td> <td><input type="radio" name="respectfulness" id="very_poor5" value="1" /> very poor <input type="radio" name="respectfulness" id="poor5" value="2" /> poor <input type="radio" name="respectfulness" id="ok5" value="3" /> ok <input type="radio" name="respectfulness" id="good5" value="4" /> good <input type="radio" name="respectfulness" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>fairness</td> <td><input type="radio" name="fairness" id="very_poor5" value="1" /> very poor <input type="radio" name="fairness" id="poor5" value="2" /> poor <input type="radio" name="fairness" id="ok5" value="3" /> ok <input type="radio" name="fairness" id="good5" value="4" /> good <input type="radio" name="fairness" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>positive motivator</td> <td><input type="radio" name="positive_motivator" id="very_poor5" value="1" /> very poor <input type="radio" name="positive_motivator" id="poor5" value="2" /> poor <input type="radio" name="positive_motivator" id="ok5" value="3" /> ok <input type="radio" name="positive_motivator" id="good5" value="4" /> good <input type="radio" name="positive_motivator" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>foresight</td> <td><input type="radio" name="foresight" id="very_poor5" value="1" /> very poor <input type="radio" name="foresight" id="poor5" value="2" /> poor <input type="radio" name="foresight" id="ok5" value="3" /> ok <input type="radio" name="foresight" id="good5" value="4" /> good <input type="radio" name="foresight" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>insight</td> <td><input type="radio" name="insight" id="very_poor5" value="1" /> very poor <input type="radio" name="insight" id="poor5" value="2" /> poor <input type="radio" name="insight" id="ok5" value="3" /> ok <input type="radio" name="insight" id="good5" value="4" /> good <input type="radio" name="insight" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>negotiator</td> <td><input type="radio" name="negotiator" id="very_poor5" value="1" /> very poor <input type="radio" name="negotiator" id="poor5" value="2" /> poor <input type="radio" name="negotiator" id="ok5" value="3" /> ok <input type="radio" name="negotiator" id="good5" value="4" /> good <input type="radio" name="negotiator" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>stamina</td> <td><input type="radio" name="stamina" id="very_poor5" value="1" /> very poor <input type="radio" name="stamina" id="poor5" value="2" /> poor <input type="radio" name="stamina" id="ok5" value="3" /> ok <input type="radio" name="stamina" id="good5" value="4" /> good <input type="radio" name="stamina" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>perseverance</td> <td><input type="radio" name="perseverance" id="very_poor5" value="1" /> very poor <input type="radio" name="perseverance" id="poor5" value="2" /> poor <input type="radio" name="perseverance" id="ok5" value="3" /> ok <input type="radio" name="perseverance" id="good5" value="4" /> good <input type="radio" name="perseverance" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>assertive</td> <td><input type="radio" name="assertive" id="very_poor5" value="1" /> very poor <input type="radio" name="assertive" id="poor5" value="2" /> poor <input type="radio" name="assertive" id="ok5" value="3" /> ok <input type="radio" name="assertive" id="good5" value="4" /> good <input type="radio" name="assertive" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>planner</td> <td><input type="radio" name="planner" id="very_poor5" value="1" /> very poor <input type="radio" name="planner" id="poor5" value="2" /> poor <input type="radio" name="planner" id="ok5" value="3" /> ok <input type="radio" name="planner" id="good5" value="4" /> good <input type="radio" name="planner" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>level headed</td> <td><input type="radio" name="level_headed" id="very_poor5" value="1" /> very poor <input type="radio" name="level_headed" id="poor5" value="2" /> poor <input type="radio" name="level_headed" id="ok5" value="3" /> ok <input type="radio" name="level_headed" id="good5" value="4" /> good <input type="radio" name="level_headed" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>even tempered</td> <td><input type="radio" name="even_tempered" id="very_poor5" value="1" /> very poor <input type="radio" name="even_tempered" id="poor5" value="2" /> poor <input type="radio" name="even_tempered" id="ok5" value="3" /> ok <input type="radio" name="even_tempered" id="good5" value="4" /> good <input type="radio" name="even_tempered" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>constructive criticism</td> <td><input type="radio" name="constructive_criticism" id="very_poor5" value="1" /> very poor <input type="radio" name="constructive_criticism" id="poor5" value="2" /> poor <input type="radio" name="constructive_criticism" id="ok5" value="3" /> ok <input type="radio" name="constructive_criticism" id="good5" value="4" /> good <input type="radio" name="constructive_criticism" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>anger management</td> <td><input type="radio" name="anger_management" id="very_poor5" value="1" /> very poor <input type="radio" name="anger_management" id="poor5" value="2" /> poor <input type="radio" name="anger_management" id="ok5" value="3" /> ok <input type="radio" name="anger_management" id="good5" value="4" /> good <input type="radio" name="anger_management" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>trouble shooter</td> <td><input type="radio" name="trouble_shooter" id="very_poor5" value="1" /> very poor <input type="radio" name="trouble_shooter" id="poor5" value="2" /> poor <input type="radio" name="trouble_shooter" id="ok5" value="3" /> ok <input type="radio" name="trouble_shooter" id="good5" value="4" /> good <input type="radio" name="trouble_shooter" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>business knowledge</td> <td><input type="radio" name="business_knowledge" id="very_poor5" value="1" /> very poor <input type="radio" name="business_knowledge" id="poor5" value="2" /> poor <input type="radio" name="business_knowledge" id="ok5" value="3" /> ok <input type="radio" name="business_knowledge" id="good5" value="4" /> good <input type="radio" name="business_knowledge" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>honesty</td> <td><input type="radio" name="honesty" id="very_poor5" value="1" /> very poor <input type="radio" name="honesty" id="poor5" value="2" /> poor <input type="radio" name="honesty" id="ok5" value="3" /> ok <input type="radio" name="honesty" id="good5" value="4" /> good <input type="radio" name="honesty" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>integrity</td> <td><input type="radio" name="integrity" id="very_poor5" value="1" /> very poor <input type="radio" name="integrity" id="poor5" value="2" /> poor <input type="radio" name="integrity" id="ok5" value="3" /> ok <input type="radio" name="integrity" id="good5" value="4" /> good <input type="radio" name="integrity" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>courage</td> <td><input type="radio" name="courage" id="very_poor5" value="1" /> very poor <input type="radio" name="courage" id="poor5" value="2" /> poor <input type="radio" name="courage" id="ok5" value="3" /> ok <input type="radio" name="courage" id="good5" value="4" /> good <input type="radio" name="courage" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>character</td> <td><input type="radio" name="character" id="very_poor5" value="1" /> very poor <input type="radio" name="character" id="poor5" value="2" /> poor <input type="radio" name="character" id="ok5" value="3" /> ok <input type="radio" name="character" id="good5" value="4" /> good <input type="radio" name="character" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>training ability</td> <td><input type="radio" name="training_ability" id="very_poor5" value="1" /> very poor <input type="radio" name="training_ability" id="poor5" value="2" /> poor <input type="radio" name="training_ability" id="ok5" value="3" /> ok <input type="radio" name="training_ability" id="good5" value="4" /> good <input type="radio" name="training_ability" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>gives recognition</td> <td><input type="radio" name="gives_recognition" id="very_poor5" value="1" /> very poor <input type="radio" name="gives_recognition" id="poor5" value="2" /> poor <input type="radio" name="gives_recognition" id="ok5" value="3" /> ok <input type="radio" name="gives_recognition" id="good5" value="4" /> good <input type="radio" name="gives_recognition" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>instills trust</td> <td><input type="radio" name="instills_trust" id="very_poor5" value="1" /> very poor <input type="radio" name="instills_trust" id="poor5" value="2" /> poor <input type="radio" name="instills_trust" id="ok5" value="3" /> ok <input type="radio" name="instills_trust" id="good5" value="4" /> good <input type="radio" name="instills_trust" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>supportive</td> <td><input type="radio" name="supportive" id="very_poor5" value="1" /> very poor <input type="radio" name="supportive" id="poor5" value="2" /> poor <input type="radio" name="supportive" id="ok5" value="3" /> ok <input type="radio" name="supportive" id="good5" value="4" /> good <input type="radio" name="supportive" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>empathy</td> <td><input type="radio" name="empathy" id="very_poor5" value="1" /> very poor <input type="radio" name="empathy" id="poor5" value="2" /> poor <input type="radio" name="empathy" id="ok5" value="3" /> ok <input type="radio" name="empathy" id="good5" value="4" /> good <input type="radio" name="empathy" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td>consistency</td> <td><input type="radio" name="consistency" id="very_poor5" value="1" /> very poor <input type="radio" name="consistency" id="poor5" value="2" /> poor <input type="radio" name="consistency" id="ok5" value="3" /> ok <input type="radio" name="consistency" id="good5" value="4" /> good <input type="radio" name="consistency" id="excellent5" value="5" /> excellent </td> </tr> <tr> <td><p> </p> <p> </p></td> <td> <input type="submit" name="Vote" value="Submit" /> </td> </tr> </table> </form> <form id="form2" name="form2" method="post" action=""> <table width="430" border="1"> <tr> <td>Enter your Employer's zip code <input type="text" name="zipcode" id="zipcode" /></td> </tr> <tr> <td width="420"> Search for an employer/boss <input type="text" name="find" id="find" /> </td> </tr> <tr> <td><input type="submit" name="submit" id="submit" value="submit" /></td> </tr> </table> </form> </body> </html> Quote Link to comment Share on other sites More sharing options...
schilly Posted February 26, 2010 Share Posted February 26, 2010 it is a mysql error and the only place "avg(training_ability) as training_ability" occurs is in your select statement. //Get the average votes in the votes table for a specific employer $sql = "SELECT avg(courtesy) as courtesy, avg(stability) as stability, avg(loyalty) as loyalty, avg(attitude) as attitude, avg(turnover_rate) as turnover_rate, avg(work_stress) as work_stress, avg(work_safety) as work_safety, avg(employee_treatment) as employee_treatment , avg(competence) as competence, avg(reliability) as reliability, avg(pay_compensation) as pay_compensation, avg(work_environment) as work_environment, avg(medical_benefits) as medical_benefits, avg(experience) as experience, avg(respectfulness) as respectfulness, avg(fairness) as fairness, avg(positive_motivator) as positive_motivator, avg(foresight) as foresight, avg(insight) as insight, avg(negotiator) as negotiator, avg(stamina) as stamina, avg(perseverance) as perseverance, avg(assertive) as assertive, avg(planner) as planner, avg(level_headed) as level_headed, avg(even_tempered) as even_tempered, avg(constructive_criticism) as constructive_criticism , avg(anger_management) as anger_management, avg(trouble_shooter) as trouble_shooter, avg(business_knowledge) as business_knowledge, avg(honesty) as honesty, avg(integrity) as integrity, avg(courage) as courage, avg(character) as character, avg(training_ability) as training_ability, avg(gives_recognition) as gives_recognition, avg(instills_trust) as instills_trust, avg(supportive) as supportive, avg(empathy) as empathy, avg(consistency) as consistency FROM votes WHERE grade_id='{$employer_id}'"; Quote Link to comment Share on other sites More sharing options...
silverglade Posted February 26, 2010 Author Share Posted February 26, 2010 thank you very much. i dont understand? i have training_ability all over the code, am i missing it somewhere? please any more help greatly appreciated. thanks. derek Quote Link to comment Share on other sites More sharing options...
schilly Posted February 26, 2010 Share Posted February 26, 2010 ok did some tests. had a feeling about using 'character' as a declaration. it is reserved by mysql. you can't use it. change character to something else and it should work. Quote Link to comment Share on other sites More sharing options...
silverglade Posted February 26, 2010 Author Share Posted February 26, 2010 HAHA! schilly you are an eagle eyed genius!! IT WORKS!!@ HAHAHAHAHHA. :D :D ive been wanting this thing to become a reality for over a month and thanks to you it is now. have a great day schilly. derek Quote Link to comment Share on other sites More sharing options...
schilly Posted February 26, 2010 Share Posted February 26, 2010 np. always helps to have a second set of eyes. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.