Ayuda con codigo php

willykamp

Lanero Novato
2 Jun 2008
9
Cordial Saludo,

Hemos tenido problemas con este codigo que anteriormente nos funcionaba a la perfeccion pero no se si alguien lo alla modificado porque ahora nos genera una serie de errores, como estos:


Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 12

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 13

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 14

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 15

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 16

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 17

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in C:\Inetpub\vhosts\ivao.org\httpdocs\members\person\update_time_pilot.php on line 18
Not Pilot


http://www.ivao.org/members/person/update_time_pilot.php

Los archivos en la db funcionan perfectamente este codigo que adjunto es el que genera el problema al actualizar la informacion

<?php
include("config/conf.php");
$requestvid = $_GET['Id'];
// CONNEXION MYSQL
$db_link = @mysql_connect($sql_serveur,$sql_user,$sql_passwd);
if(!$db_link) {echo "No connected to <b>$sql_bdd</b> on the server <b>$sql_server</b>"; exit;}
$details=mysql_db_query($sql_bdd,"select * from user_data where Pers_Id=\"$requestvid\"",$db_link) or die(mysql_error());
$Pers_Last_Name=mysql_result($details,0,"Pers_Last_Name");
$Pers_First_Name=mysql_result($details,0,"Pers_First_Name");
$Pers_Id=mysql_result($details,0,"Pers_Id");
$Pers_Time_Pilot=mysql_result($details,0,"Pers_Time_Pilot");
$Pers_isPilot=mysql_result($details,0,"Pers_isPilot");
$Pers_Time_Total=mysql_result($details,0,"Pers_Time_Total");
$Pers_Time_All=mysql_result($details,0,"Pers_Time_All");
$cumulold = '0';
if($Pers_isPilot=="0")print 'Not Pilot '.$requestvid.'<br>';
else
{
$cumulreq=mysql_db_query($sql_bdd,"select CUMUL from ivan_time where VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error());
{
// SI L'ID N'EXISTE PAS
if(mysql_num_rows($cumulreq)==0)
{
print 'No Pilot time '.$requestvid.'<br>';
}
else
{
while ($data = mysql_fetch_array($cumulreq)) {
{
$cumul = $cumulold + $data['CUMUL'];
$cumulold = $cumul;
}
}
$new_cumul = $cumulold;
$cumul_minutes = floor($new_cumul / 60);
$total_cumul = $Pers_Time_Pilot + $cumul_minutes;
$total_total = $Pers_Time_Total + $cumul_minutes;
$total_all = $Pers_Time_All + $cumul_minutes;
$Pers_Updated_Set = date("Y-m-d H:i:s");
$hourupdate=mysql_db_query($sql_bdd,"UPDATE user_data SET Pers_Time_Pilot='$total_cumul',Pers_Time_Total='$total_total',Pers_Time_All='$total_all',Pers_Updated='$Pers_Updated_Set' WHERE Pers_Id='$requestvid'",$db_link) or die(mysql_error());
{
if($hourupdate)
{
print ''.$requestvid.' updated<br>';
}
}
$requete=mysql_db_query($sql_bdd,"select max(DATE_FIN) from ivan_time where VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error());
$datemax=mysql_result($requete,0,"max(DATE_FIN)");
$datemax=$datemax-3600;
$lastonlineupdate=mysql_db_query($sql_bdd,"UPDATE user_data SET lo_pilot='$datemax' WHERE Pers_Id='$requestvid'",$db_link) or die(mysql_error());
$delall=mysql_db_query($sql_bdd,"DELETE FROM ivan_time WHERE VID=\"$requestvid\" and TYPE=\"PILOT\"",$db_link) or die(mysql_error());
}
}
}
?>
<?
mysql_close($db_link);
?>

Gracias por su ayuda,

IVAO-AWM
 
la variable $requestvid no está llegándole al query, por eso el resultado mysql no devuelve nada... y por eso la fila 0 no existe

Eso se puede ver pq debería imprimir "Not Pilot XXXXX"
 

Los últimos temas