MySQL_Fetch_Field

[Arc]

I have a recordset that has 2 items in it. An Online ID and a Password. I am trying to use MySQL_Fetch_Field to get those 2 values and put them into 2 variables to be used later... but i ma having trouble figuring out the second parameter tof this function.
The field offset. What should i put there? Here is my code.

//Connection code and  all that up here

$Sql = "SELECT OnlineID,Password FROM tblSignUp WHERE Email Like '$txtEmailAddress'";
$Result = mysql_query($Sql, $Connect);
mysql_Close ($Connect);
If (mysql_num_rows($Result) > 0) {
$OnlineID = mysql_fetch_Field($Result,1);
$Password = mysql_fetch_Field($Result,2);
}

I am sure the $Result is returning 2 values but how do i extract them?

Thanks!😃

[sfhc]

Change your code to this:

$Sql = "SELECT OnlineID,Password FROM tblSignUp WHERE Email Like '$txtEmailAddress'";
$Result = mysql_query($Sql, $Connect);

$resultArray=@mysql_fetch_array($Result);

$onlineID=$resultArray[0];
$password=$resultArray[1];

[Arc]

cool thanks😃