[SOLVED] Resource id #335--What is it?

[elentz]

I keep getting this instead of a result of the following code:

$sql3 = "SELECT
          vtiger_invoicecf.cf_546,
          vtiger_invoice.invoiceid
         FROM
          vtiger_invoice
         Inner Join vtiger_invoicecf ON vtiger_invoice.invoiceid = vtiger_invoicecf.invoiceid
         WHERE
        vtiger_invoice.invoiceid = '$myvar'";

$refno=mysql_query($sql3);

// ************* Begin Top-Right Header ***************
// title
$titleBlock=array("147","7");
$pdf->title( "Invoice","", $titleBlock );

//$soBubble=array("168","17","12");
//$pdf->addBubbleBlock($so_name, "Albar�n", $soBubble);

//$poBubble=array("130","17","12");
//$pdf->addBubbleBlock($po_name, " Cust. P.O.", $poBubble);

$wobubble=array("130","17","12");
$pdf->addBubbleBlock($refno,"Work/Quote #",$wobubble);

 

I should get a number for the $refno variable an I keep getting a "Resource id #335" instead.

 

Can someone give me a clue?

 

Thanks alot

[kenrbnsn]

After you do a mysql_query(), you need to use one of the mysql_fetch functions to get the retrieved data. The mysql_query() returns a pointer to the returned data, that's what the resource # is.

 

Ken

[elentz]

DOH!

 

Musta been too tired.

 

Thanks for the help!