<?php
$id=$_GET['id'];
$username="username";
$password="password";
$database="outage";
mysql_connect("server",$username,$password);
$result= mysql_query("SELECT * FROM `outage` WHERE ID='$id'");
$num=mysql_num_rows($result);
$i=0;
while ($i<num) {
$outagedate=mysql_result($result,$i,"date");
$outagetime=mysql_result($result,$i,"time");
$status=mysql_result($result,$i,"status");
$outagetype=mysql_result($result,$i,"outagetype");
$mtcplant=mysql_result($result,$i,"mtcplant");
$outagecity=mysql_result($result,$i,"city");
$outagenode=mysql_result($result,$i,"node");
$services=mysql_result($result, $i,"services");
$custcount=mysql_result($result,$i,"custcount");
$cbs=mysql_result($result,$i,"cbs");
$impact=mysql_result($result,$i,"impact");
$desc=mysql_result($result,$i,"desc");
}
?>
This is supposed to pull variables from a table and autopopulate an update form. When I call the script, I get the error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in....
ID is in all caps in the table, therefore caps in the code as well. Anyone have any idea why I'm getting that error?
