Illegal Offset Type?

[gordon7]

I am getting the following warning:

Warning: Illegal offset type in C:\path on line 17

there is nothing on line 17, so I started looking back... everything lools fine. What am I missing?

Here's the code:

<?php
// setup variables for db access
$db_name = "rvr";
$db_table = "rvr_service_employee";
$dbconnect = @mysql_connect("localhost") or die(mysql_error());
//connect to the db
$db = @mysql_select_db($db_name, $dbconnect) or die(mysql_error());
// select db criteria
$sql = "SELECT * FROM $db_table ORDER BY lname";
$results = @($sql, $dbconnect) or die (mysql_error());
// create variables for db items
while ($row = mysql_fetch_array($results)) {
$first_name = $row["fname"];
$middle_name = $row["mname"];
$last_name = $row["lname"];
$worker_class = $row["worker_class"];
(This is line 17)

$full_name = "$first_name $middle_name $last_name";

I checked around and found there myght be a bug with a foreach, but no foreach here????

Thanks in advance for anyone who can help,
Gordon

[robert_w_ark]

while ($row = mysql_fetch_array($results)) {
$first_name = $row["fname"];
$middle_name = $row["mname"];
$last_name = $row["lname"];
$worker_class = $row["worker_class"];

Wheres the } for the while() statement? Also, make sure your $row fields exist in MySQL.

[gordon7]

The closing } is down in the code a bit further. When I read Debuging101 in this forum, I got the impression that when php hiccups, the code it is choking on has been parsed and is likely above the line given. Is this correct?

I had set up $row to be a variable to hold:

mysql_fetch_array($results)

then the rest of the query refers back to that variable as a pointer. Therefore it didn't seem necessary to be in the database. But, I am just a newbie.

Everything seems to work except for the warning message!?

Gordon

[LoganK]

Can array keys have underscores?