Valid SQL, bad return result

[ikarus]

I have a perfectly valid sql statement that runs fine from the command line, but when i run it through mysql_query() it gives an invalid resource return.<br>
<br>
most calls to mysql_query() with valid sql will return something similar to "Resource id #2", however, this particular query returns "1". this means that the query succeeded, (gives no error number or message) but for some reason didn't return a resource id. if the query was invalid it would return "0", otherwise a resource id number, but all i can get is "1", which makes it impossible to do anything with the results of the query.<br>
<br>
any insight into this problem would be MUCH appreciated.

[[deleted]]

And the query is?

[djg_uk]

Justin,

Have you selected the database for the query?

Cheers,

David

[ikarus]

this is the query (it searches for stuff in the db) everything is valid, it executes from the command line. i've got everything else setup correctly too (selected a db etc).

create temporary table tmp_737160d8ecf19267993ca3d16f0be14c type=heap select cache_abstract.Abstract_ID, boxes.Name, cache_abstract.Title, cache_abstract.Description, cache_abstract.URL, cache_abstract.Date from cache_abstract, boxes where (cache_abstract.Title REGEXP "wordone" OR cache_abstract.Description REGEXP "wordone") and (cache_abstract.Title REGEXP "wordtwo" OR cache_abstract.Description REGEXP "wordtwo") and (cache_abstract.Title REGEXP "wordthree" OR cache_abstract.Description REGEXP "wordthree") and cache_abstract.Box_ID = boxes.Box_ID order by Date

[[deleted]]

and what did mysql_error() tell you?

[ikarus]

mysql_error() returns nothing, as does mysql_errno(). by all accounts, the query succeeds, but the return result is useless.

[[deleted]]

Having another look at the query I'd say that it doesn't surprise me a lot :-)
Your query is for creating a table and filling that with data from a select statement. What did you expect to get back? there's no 'normal' select in there, so nothing to return.

[ikarus]

ah yes, you're right. i missed the obvious problem of never selecting anything. once you stare at something for too long, you miss the little things. goes to show a fresh pair of eyes can help. thanks.

[[deleted]]

I know the feeling :-)