I don't get it... I have PHP 4.1.0 because 4.1.1 pukes all over the
lace( I am assuming this is the case as well...) on Win2k Server with Apache
1.3.xx.
And I get this from this query:
Warning: Undefined index: Sec_phone in c:\apache
group\apache\htdocs\recruiter\show_can.php on line 40
QUERY:
===================================================
$sql = "SELECT FirstName, LastName, Industry, Address1, Address2, Zip, City,
State, LocationPref, Phone, Sec_phone, Email, ResumeUp, Resume, Notes
FROM $canidatetable
WHERE id = '$id'";
$result = @mysql_query($sql, $connection) or die("Couldn't execute
query.");
while ($row = mysql_fetch_array($result))
$FirstName = $row['FirstName'];
$LastName = $row['LastName'];
$Industry = $row['Industry'];
$Address1 = $row['Address1'];
$Address2 = $row['Address2'];
$City = $row['City'];
$State = $row['State'];
$Zip = $row['Zip'];
$LocationPref = $row['LocationPref'];
$Phone = $row['Phone'];
$Sec_phone = $row['Sec_phone'];
$Email = $row['Email'];
$ResumeUp = $row['ResumeUp'];
$Resume = $row['Resume'];
$Notes = $row['Notes'];
}
}
?>
=====================================
Now when I run the query directly at the mysql> prompt, its fine
when I run this query:
SELECT FirstName, LastName, Sec_phone from canidate;
I get this:
+-----------+------------+------------------+
| FirstName | LastName | Sec_phone |
+-----------+------------+------------------+
| Todd | Williamsen | NULL |
| Joe | Blow | 112-345-7760 |
| John | Doe | 123-555-1212 |
| Nancy | DeFelice | |
| Julie | Web | 720-123-456-7890 |
+-----------+------------+------------------+
5 rows in set (0.00 sec)
Is it PHP crapping out?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
