[Resolved] Refering to a variable

[digitalflash]

Is it possible to refer to a variable whose value is retrieved from a database in the following fashion? Let's say I make the following query:

"SELECT d_id, u" . $GET['user_id'] . " FROM directories WHERE d_id=$someid"

Now I need to find out the value of the field I've referred to in the query as -- "u" . $GET['user_id'] -- so that I can place it in an if statement:

if ($u_##==1) { do thus-and-such }

The "##" here is the value of $_GET['user_id']. There must be a way of getting the value of that field, but I don't know how.

Any ideas?

[bpat1434]

$uid = 'u_'.$_GET['uid'];

$query = "SELECT d_id, ".$uid." FROM directories WHERE d_id = $someid";

$rslt = mysql_query($query);
while($row = mysql_fetch_array($rslt))
{
    if($row["'".$uid."'"] == 1)
    {
        // do thus and such
    }
}

Is that what you're going after?

~Brett

[digitalflash]

I think so, though, I can't get that syntax to work for me. Here is my fuller script, based on your example. I've replaced your $uid with $p:

echo "<table width=\"100%\" border=\"0\" bordercolor=\"#BED0D6\" style=\"border-collapse: collapse\" cellspacing=\"0\" cellpadding=\"2\">";
	$p = 'd_u'.$_GET['id'];
	$query="SELECT d_id, d_u_id, ".$p.", u_id, u_lname, u_fname, u_mname, u_o_id, o_id, o_name FROM fs_directories, fs_users, fs_organization WHERE fs_directories.d_u_id = fs_users.u_id AND fs_users.u_o_id = fs_organization.o_id ORDER BY o_name, u_lname";
	$result=mysql_query($query);
	while ($row=mysql_fetch_array($result)) {
		foreach($row as $thisvar => $thisval) { $$thisvar=$thisval; }
		echo "<tr>
			<td align=\"right\" class=\"resultsText\" width=\"200\">";
			// ONLY DISPLAY ORGANIZATION NAME ONCE
			if ($o_name!=$o_name_old) { echo "<b>" . $o_name . "</b>"; }
			echo "</td>
			<td width=\"25\" align=\"center\"><input type=\"checkbox\" name=\"permit[]\" value=\"" . $d_id . "_1\"";
			if ($row["'".$p."'"] == 1) { echo " checked";}
			echo "></td>
			<td class=\"resultsText\">" . $u_lname . ", " . $u_fname . " " . $u_mname . "</td>
			</tr>";
				$o_name_old = $o_name;
			}
	echo "</table>";

I need the checkbox to be checked when the value of the field represented by -- 'd_u'.$_GET['id'] -- is equal to 1.

[digitalflash]

Thanks for the help. I just solved it another way when I remembered (duh!) that the $query variable is storing an array as each table row is read:

if ($row[2] == 1) { echo " checked";}