TalkPHP - View Single Post - Returning pointer to 1st element in associative array

Wildhoney · 08-27-2009, 01:32 AM

You could use mysql_data_seek like below. Although it seems peculiar to me how you're using this.

php Code:

$c_pettype = 'horse' ; // From user.
$q = "SELECT *
        FROM t_petdata
       WHERE pettype = '$c_pettype' " ;
$q_result = mysql_query($q) or die('no data selected') ;
$q_rowarray = mysql_fetch_assoc($q_result) ;

echo "ELEMENT 1";
echo "<pre>";
print_r($q_rowarray);
echo "</pre>";

echo "using MYSQL_DATA_SEEK() here..." ;
mysql_data_seek($q_result, 0) ;

$q_rowarray = mysql_fetch_assoc($q_result)
            or die('query failed') ;
echo "SHOULD BE ELEMENT 1 AGAIN";
echo "<pre>";
print_r($q_rowarray);
echo "</pre>";