Resource id #s

[Ross]

Building a simple PHP/MySQL database interface. All SELECT queries return:
"Resource id #2"

What is this Resource id? Is there a list of them described somewhere?
Looked all over php.net

Many thanks!
-Ross

[Andy Hassall]

Re: Resource id #s

On Tue, 12 Aug 2003 20:13:55 GMT, "Ross" <info@dakindesi gn.com> wrote:
[color=blue]
>Building a simple PHP/MySQL database interface. All SELECT queries return:
>"Resource id #2"
>
>What is this Resource id? Is there a list of them described somewhere?
>Looked all over php.net[/color]

Look harder. Particularly at:

http://php.net/mysql_query

http://php.net/mysql_fetch_array

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Jeffrey Silverman]

Re: Resource id #s

On Tue, 12 Aug 2003 20:13:55 +0000, Ross wrote:
[color=blue]
> Building a simple PHP/MySQL database interface. All SELECT queries
> return: "Resource id #2"
>
> What is this Resource id? Is there a list of them described somewhere?
> Looked all over php.net
>
> Many thanks!
> -Ross[/color]

This ought to be in a FAQ or something...!

Simple answer: Read the Manual!

More detailed answer:
Anyways, "Resource id #2" is the text-description of the valid mysql
resource. Looks to me like you need to do some reading on this one. Try
reading this:

http://us2.php.net/manual/en/ref.mysql.php

Scroll down the page to "Example 1. MySQL extension overview example".
Copy and paste code. Change names as necessary.

later...

--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Johns Hopkins University | Baltimore, MD
Website | http://www.wse.jhu.edu/newtnotes/

[Ross]

Re: Resource id #s

Sorry for the ignorance! I had the concept backwards, I thought the
Reference # was in reference to an error (an assuption that should speak for
itself).

Got it all strait and working now, thanks again.
-Ross

[color=blue]
> This ought to be in a FAQ or something...!
>
> Simple answer: Read the Manual!
>
> More detailed answer:
> Anyways, "Resource id #2" is the text-description of the valid mysql
> resource. Looks to me like you need to do some reading on this one. Try
> reading this:
>
> http://us2.php.net/manual/en/ref.mysql.php
>
> Scroll down the page to "Example 1. MySQL extension overview example".
> Copy and paste code. Change names as necessary.
>
> later...
>
> --
> Jeffrey D. Silverman | jeffrey AT jhu DOT edu
> Johns Hopkins University | Baltimore, MD
> Website | http://www.wse.jhu.edu/newtnotes/
>[/color]