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.
<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.