problem in sql statement

[Anon]

select * from gulf_options where option_id in (1,2)

Warning: Supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\php\gulfstream\viewcart.php on line 47

I am trying to find some data based on values from another query. The first query provides the \"(1,2)\" as a set of options to be found, where each number is an option_id.

What am i doing wrong?

TIA

Bastien

[jc94062]

Looks like a standard error you get when your not connected to the mysql server.

Make sure you've connected with mysql_connect (or better yet mysql_pconnect) before running any queries.

[bastien]

using mysql_pconnect for the connection.

I am wondering if the problem is that the data that make the "in" part of the statement, which comes from another query is casuing a problem because the data is stored as text and the query field in the statement is a number

Bastien