Buenas a todos, quisiera hacerles una consulta por el siguiente codigo :
Código PHP:
//$sql = "SELECT speed, hum, temp, press FROM mov_em";
$sql = "SELECT speed, hum, temp, press FROM mov_em WHERE hum = '$hum' AND speed = '$speed' AND temp = '$temp' AND press = '$press'";
$result = mysql_db_query ($sql, $connection);
while ($row = mysql_fetch_array ($result))
{
print ("<TR>");
print ("<TD>$row[speed]</TD>\n");
print ("<TD>$row[hum]</TD>\n");
print ("<TD>$row[temp]</TD>\n");
print ("<TD>$row[press]</TD>\n");
print ("</TR>");
}
mysql_free_result($result);
/*echo $hum;
echo $speed;
echo $temp;
echo $press;
$hum;
$speed;
$temp;
$press;
$result = mysql_query($sql);
$v = ($speed*0.16);
echo $twc= (13.12+(0.6215*$temp)-(11.37*$V)+(0.3965*$temp*$V));
//echo $high;*/
En el mismo trato de usar la ecuacion twc donde las variables las quiero obtener desde una base de datos, pero al correr el codigo me arroja lo siguiente:
Notice: Undefined variable: hum in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 4
Notice: Undefined variable: speed in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 4
Notice: Undefined variable: temp in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 4
Notice: Undefined variable: press in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 4
Deprecated: Function mysql_db_query() is deprecated in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 5
Warning: mysql_db_query() expects parameter 2 to be string, resource given in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 5
Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 6
Warning: mysql_free_result() expects parameter 1 to be resource, null given in C:\Program Files\EasyPHP-5.3.8.0\www\aprs6.1P\ecuacion.php on line 15
Espero sus comentarios.
Saludos.