$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" <dale_news@hershonline.com>
To: <php-general@lists.php.net>
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