[RESOLVED] query variable as a database value

shockingv

I have a php4 page that displays the results of a mysql query from table 1: echo ($row1[1]); displays "Smith". What I want is to have "$row1[1]" as a value in a different table, call it table 2. Then when I query table 2 I want: echo ($row2[1]); to also display "Smith". Right now it only displays "$row1[1]".

I've attempted using the "&" reference tag. Either I was doing it incorrectly or it's not applicable.

Houdini

It would help others to help you if you posted you code, please try to use the tools like # for code or <> for HTML or ~ for PHP in the posting area.

shockingv

Here's a boiled down version of what I'm trying to accomplish. The first database query contains the actual data. The second database query will contain a list of variables that point to the data in the first database.

~$SQLgetName = "SELECT first_name, last_name FROM accounts WHERE account_number like ".$passedID;
~$rsObjQuery=mssql_query($SQLgetName,$connectID);
~$rowSM=mssql_fetch_array($rsObjQuery);
~
~$query="SELECT LastName FROM Questions";
~$resultMY=mysql_query($query);
~$rowMY=mysql_fetch_array($resultMY);
~
~echo ($rowSM['last_name']);
~echo ($rowMY['LastName']);

$rowSM['last_name'] == "Smith"
$rowMY['LastName'] == "$rowSM['last_name]"

How do I get to the value "Smith" from $rowMY['LastName']? Should $rowMY['LastName'] contain something else? Am I taking the completely wrong approach?

tomhath

If I understand what you want, you are trying way too hard.

There's no need to store a variable, just store the column name so you can use it as a key:

$rowSM['last_name'] == "Smith"
$rowMY['LastName'] == "last_name"

$rowSM[$rowMY['LastName']] =="Smith"

shockingv

Of course! You're right, I was making it far too difficult. Thank you.