First thing I thought when I saw that was a database table index.
But, it appears that when you try to reference the field of the row array,
it's saying it is undefined.
First make sure that there were rows returned before continuing to go
through the "returned data set" ... in case there was no data returned.
if ( ( $numrows = mysql_num_rows($result) ) > 0 ) {
while( $row = mysql_fetch_array($result) )
{
## ...
}
}
<snip>
$sql = "SELECT ReqNum, Industry, Other, JobTitle, Description, Location,
Notes FROM $jobtable WHERE id = '$id'";
$result = @mysql_query($sql, $connection) or die("Couldn't execute
query.");
while ($row = mysql_fetch_array($result))
$ReqNum = $row['ReqNum']; <=============== LINE 25
</snip>
Oh, and you're missing the CURLY BRACES that should encase the code for the
WHILE LOOP ...
nicole
www.aeontrek.com
"Todd Williamsen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Warning: Undefined index: ReqNum in
> c:\inetpub\wwwroot\recruiter\show_job.php on line 25
>
>
> What does this error mean?
>
> I get it from this code...
>
> $sql = "SELECT ReqNum, Industry, Other, JobTitle, Description, Location,
> Notes FROM $jobtable WHERE id = '$id'";
> $result = @mysql_query($sql, $connection) or die("Couldn't execute
> query.");
> while ($row = mysql_fetch_array($result))
>
> $ReqNum = $row['ReqNum']; <=============== LINE 25
> $Industry = $row['Industry'];
> $Other = $row['Other'];
> $JobTitle = $row['JobTitle'];
> $Description = $row['Description'];
> $Location = $row['Location'];
> $Notes = $row['Notes'];
> the weird thing is that everything else works, why doesn't it like this
> value?
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
