|
|
Posted by J.O. Aho on 01/10/06 21:43
bigsamurai wrote:
> now i get this error...
>
> Warning: mysql_result(): supplied argument is not a valid MySQL result
> resource in /home/content/m/i/k/mikey05156/html/ind_pilotins.php on
> line 48
>
> Warning: mysql_result(): supplied argument is not a valid MySQL result
> resource in /home/content/m/i/k/mikey05156/html/ind_pilotins.php on
> line 49
>
> line 48 and 49 are as follows:
>
>
> $miss_tot = mysql_result($result1,$i,"(miss_no)");
> $hours_tot = mysql_result($result1,$i,"(miss_hours)");
>
>
> I put the select statement you provided as a second. using the $query1
> and $result1 variable.
>
$row=mysql_featch_arrya($result1)
$query = "SELECT mission.miss_pilot_assign,
pilot.pilot_no, pilot.pilot_name,
mission.miss_status,
mission.miss_no,
mission.miss_hours
FROM mission, pilot
WHERE
mission.miss_pilot_assign=pilot.pilot_no
AND
mission.miss_status=3
AND
pilot.pilot_name='$_POST[pilot_name]'
GROUP
by mission.miss_status";
$result=@mysql_query($query);
$number = mysql_numrows($result);
if ($number > 0) {
print "<h2> Here are the flight statistics for '$_POST[pilot_name]'as
recorded by Squadron Operations. <br /><br /><br /></h2>";
print "<table>";
print "<tr>";
print "<td bgcolor=000000 width=80 height=25 align=center><font
face=Arial color=#FFFFFF size=2><b>Number of missions</b></font></td>";
print "<td bgcolor=000000 width=120 height=25 align=center><font
face=Arial color=#FFFFFF size=2><b>Number of Hours</b></font></td>";
print "</tr>";
/* Get pilots info */
while($row=mysql_fetch_array($result)) {
print "<tr>";
print "<td bgcolor=000000 width=90 height=20 align=left><font
face=Arial size=2 color=#FFFFFF>".$row[4]."</font></td>";
$tot_miss+=$row[4];
print "<td bgcolor=000000 width=90 height=20 align=left><font
face=Arial size=2 color=#FFFFFF>".row[5]."</font></td>";
print "</tr>";
$tot_hours+=$row[5];
}
print "<tr>";
print "<td bgcolor=000000 width=90 height=20 align=left><font
face=Arial size=2 color=#FFFFFF>$tot_miss</font></td>";
print "<td bgcolor=000000 width=90 height=20 align=left><font
face=Arial size=2 color=#FFFFFF>$tot_hours</font></td>";
print "</tr>";
print "</table>";
}
/* Close the database connection */
mysql_close();
?>
Navigation:
[Reply to this message]
|