I hve doing a poll script in PHP and all is working perfectly, but only it has this error when I sent my vote, and do not know how to solve: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/u7/web/html/index/encuesta.php on line 9 PHPCode is: include('db.php'); $opciones = array ('DJ-ERR0R-','DJ-Ray','DJ-AdituS','DJ-Lydi','DJ-L3y'); if(isset($_GET["voto"])){ $ip = $REMOTE_ADDR; $sql ="INSERT INTO encuesta (ip,voto) VALUES ('$ip',".$_GET["voto"].")"; LINE OF ERROR-> $votos = mysql_result(mysql_query($sql),0); } $i = 0; $sql ="SELECT count(ip) FROM encuesta"; $total = mysql_result(mysql_query($sql),0); echo "<form><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n"; while ($opciones[$i]){ $sql ="SELECT count(ip) FROM encuesta WHERE voto = $i"; $votos = mysql_result(mysql_query($sql),0); @$porcentaje = round($votos/$total*100,2); echo " <tr>\n"; echo " <td colspan=\"3\"><b>$opciones[$i]</b></td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td><input type=\"radio\" value=\"$i\" name=\"voto\"></td>\n"; echo " <td><hr color=\"blue\" size=\"10\" width=\"$porcentaje\" align=\"left\">\n"; echo " </td>\n"; echo " <td align=\"right\">$porcentaje% ($votos)</td>\n"; echo " </tr>\n"; $i++; } echo " <tr>\n"; echo " <td colspan=\"3\"><br><input type=\"submit\" value=\"Votar\"></td>\n"; echo " </tr>\n"; echo "</table></form>"; PHP:
That error message means that you aren't properly connected to MySQL. Your real issue is with mysql_connect in db.php.
I did that script and is working correctly, but when somebody send vote, it get mysql error on line 9. Get up and read my first post of this thread.