perplexing result of mySql query

[freedmania]

I'm querying a table containing data on a few (6, precisely) fonts. Conicidentally, each font has six characteristics I'm interested in. So the table has six rows and six columns.

function getFont($id){
	global $fRA;
	$qr = 'SELECT * FROM pda_font';
	$re = mysql_query($qr) or die(mysql_error());
	$nrows = mysql_num_rows($re);
	$fRA = array();
	$fRA = array('ffile'=>mysql_result($re,$id,'fontfile'), 'fSize'=>mysql_result($re,$id,'fontsize'), 'fWrap'=>mysql_result($re,$id,'wordwrap'), 'fSplit'=>mysql_result($re,$id,'wordsplit'), 'fname'=>mysql_result($re,$id,'fontname'), 'fw'=>mysql_result($re,$id,'w'));
}

But something's wrong. Instead of the use of the selected font, I get a screen filled with six repetitions of:
Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 11 in /usr/www/xxx/yyy/zzz/sqlFetch3.php on line 53

And then, six more repetitions:
Warning: mysql_result() [function.mysql-result]: Unable to jump to row -1 on MySQL result index 16 in /usr/www/xxx/yyy/zzz/sqlFetch3.php on line 53

It seems to be acting as if the query isn't getting the $id (though it certainly is being generated and seems to reach the form that feeds the query-generator)... But what's got me is the 'index 11' and '16' business. What's that about???

If anyone has any insight on this matter I'd be more than delighted to receive it.

Thanks,
- Paul

[NogDog]

I think maybe what you want is something like this (untested, of course):

<?php
function getFont($id, &$fRA) // pass array by reference instead of using global
{
    $qr = 'SELECT * FROM pda_font where id = '.$id;
    $re = mysql_query($qr);
    if($re == false)
    {
       user_error(__FUNCTION__.": Query failed: ".mysql_error());
       return false;
    }
    if(!mysql_num_rows($re))
    {
       user_error(__FUNCTION__.": no match found");
       return false;
    }
    $row = mysql_fetch_assoc($re);
    $fRA = array(
       'ffile'=>$row['fontfile'],
       'fSize'=>$row['fontsize'], 
       'fWrap'=>$row['wordwrap'], 
       'fSplit'=>$row['wordsplit'], 
       'fname'=>$row['fontname'], 
       'fw'=>$row['w']
    );
    return true;
}
// usage:
getFont(3, $fRA);

[freedmania]

Well, the number and extent of the systemic complaints diminished.

"Notice: getFont: no match found in /usr/www/xxx/yyy/zzz/sqlFetch3.php on line 59"

now appears only twice. And none of those excessive 'index 11' and 'index 16's, which were so unruly.

I'd like to return to this tomorrow. It's almost 2am where I am, and I'm beginning to see things in colors I don't believe exist. Thanks, and adieu.