output of the codings

[karthikanov24]

hi

 

EVEN THOUGH I MADE mysql_free_result($result);,I AM GETTING OUT PUT FOR echo $row['id'];

echo $row['email']; CAN U EXPLAIN ME HOW.?ACTUALLY WHAT IS THE OUTPUT.............

///////////////////////////////////////////////////////////////

 

<?php

$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");

if (!$result) {

    echo 'Could not run query: ' . mysql_error();

    exit;

}

/* Use the result, assuming we're done with it afterwords */

$row = mysql_fetch_assoc($result);

 

/* Now we free up the result and continue on with our script */

mysql_free_result($result);

 

echo $row['id'];

echo $row['email'];

?>

 

[Mark Baker]

You fetch the first row of the result from your query into $row, then free $result. $row is unchanged because it is a copy of the values that had been in $result before you freed up $result.