[SOLVED] $result query to pluggable variable?

[ag3nt42]

hello again all,

 

I'm trying to pull data from my database and plug the result into a variable but it doesn't seem to want me to do it..

 

here my snatching code:

 

$AdminSql = "SELECT [username] FROM [".$tblpre."users]  WHERE Ident='1'";

$result = mssql_query($AdminSql)or die(mssql_error());
while($row = mssql_fetch_row($result))
{
$row[0]=$Zadmin;
}

 

here my plugging code:

echo("
<input type='text' value='".$Zadmin."' />
");

 

keep in mind that I'm echoing out ALL of my HTML in one huge echo.

 

I can not figure out why it won't let me plug that variable in. results in blank nothing..

no errors

[wildteen88]

Your variables are the wrong way around

$row[0]=$Zadmin;

It should be

$Zadmin = $row[0];

[ag3nt42]

omfg lol *palm*face*

 

thanks man lol

 

ps. its been a loong day

 

i'ma chalk that one up to the heat