[Resolved] Getting Resource id#3

[PHP_apprentice]

Hi all I could use some help on a DB call.

Here is the call

$id = mysql_query("SELECT company_id FROM company WHERE company_name = '$c'",$db);//selects the company_id

When I try to echo $id to the screen I am getting a resource id#3 all the time does anybody have an answer for this one?

Thanks for the help

[HalfaBee]

The mysql_query() does not return the data, just a resource to the data.
Use mysql_fetch_array($id) or similar function to return the data.

HalfaBee

[PHP_apprentice]

Thanks for the help on that one!! I t had me stuck for a bit!!!!

I acutally used mysql_result