Tengo un codigo php que arme para extraer valores de una base de datos.
Es esta parte del codigo que esta fallando pero no logro identificar que en concreto.
Agradeceria que me den una mano para encontrar el error.
Codigo:
Código PHP:
//1
$1query = "select count(telef) from diario where movil=1;";
$1result = mysql_query($1query);
$1count = mysql_fetch_array($1result);
$mov1=$1count[0];
//2
$2query = "select count(telef) from diario where movil=2;";
$2result = mysql_query($2query);
$2count = mysql_fetch_array($2result);
$mov2=$2count[0];
//3
$3query = "select count(telef) from diario where movil=3;";
$3result = mysql_query($3query);
$3count = mysql_fetch_array($3result);
$mov3=$3count[0];
//4
$4query = "select count(telef) from diario where movil=4;";
$4result = mysql_query($4query);
$4count = mysql_fetch_array($4result);
$mov4=$4count[0];
//5
$5query = "select count(telef) from diario where movil=5;";
$5result = mysql_query($5query);
$5count = mysql_fetch_array($5result);
$mov5=$5count[0];
//6
$6query = "select count(telef) from diario where movil=6;";
$6result = mysql_query($6query);
$6count = mysql_fetch_array($6result);
$mov6=$6count[0];
//7
$7query = "select count(telef) from diario where movil=7;";
$7result = mysql_query($7query);
$7count = mysql_fetch_array($7result);
$mov7=$7count[0];
//8
$8query = "select count(telef) from diario where movil=8;";
$8result = mysql_query($8query);
$8count = mysql_fetch_array($8result);
$mov8=$8count[0];
//9
$9query = "select count(telef) from diario where movil=9;";
$9result = mysql_query($9query);
$9count = mysql_fetch_array($9result);
$mov9=$9count[0];
//10
$10query = "select count(telef) from diario where movil=10;";
$10result = mysql_query($10query);
$10count = mysql_fetch_array($10result);
$mov10=$10count[0];
//11
$11query = "select count(telef) from diario where movil=11;";
$11result = mysql_query($11query);
$11count = mysql_fetch_array($11result);
$mov11=$11count[0];
echo "<h4>Moviles :<br>movil1: " .$mov1. " <br>movil2: " .$mov2. " <br>movil3: " .$mov3. " <br>movil4: " .$mov4. " <br>movil5: " .$mov5. " <br>movil6: " .$mov6. " <br>movil7: " .$mov7. " <br>movil8: " .$mov8. " <br>movil9: " .$mov9. " <br>movil10: " .$mov10. " <br>movil11: " .$mov11. " </h4> ";