Re: [PHP] problem with array

[Minuk Choi]

    $selectedCol=$row["selectedCol"];
     echo $selectedCol;
    $selectedColName=$row[$selectCol];   //<--- PLEASE NOTE THIS SPECIFIC
ROW
Please give me the output, what do you get from "echo $selectedCol;"?  If I 
had to guess, it looks like you're confusing key and value of an 
associatative array.

if
$row["selectedCol"] = 12;
$row["12"] does NOT equal "SelectedCol".
In fact, even if you used mysql_fetch_array, you will not be able to do a 
reverse lookup like that.

Suppose you have the following :
$row['a'] = 1;
$row['b'] = 2;
$row['c'] = 1;
You can see that your approach is incorrect because what would $row[1] 
return?

If this is NOT your question, please post your output(errors and all).
----- Original Message ----- 
From: "Dale Hersowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 9:58 PM
Subject: [PHP] problem with array


Hi guys,
Recently, I had to reformat one of the web servers and now I have
encountered an unusual problem. I am not sure whether this is an issue 
which
can be fixed in the .ini file or whether its specific to the version of 
php
I am using.

Here is the problem:
  $query="SELECT * FROM customizeViewClients WHERE employeeNum =
$employeeNum";
  $results=mssql_query($query, $connection) or die("Couldn't execute
query");
  $numRows=mssql_num_rows($results);
   if($numRows>0)
  {
        $row=mssql_fetch_array($results);
   }
    $selectedCol=$row["selectedCol"];
     echo $selectedCol;
    $selectedColName=$row[$selectCol];   //<--- PLEASE NOTE THIS SPECIFIC
ROW
For some reason, on the last row, I am not unable to reference a 
particular
index in the array using a php variable. This has been working for almost 
12
months and now the coding is breaking all over the place. I don't have an
answer. Any feedback would be greatly appreciated.

Thx.
Dale
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php