How do you print the results of tep_db_query()

[dhobson]

If I make this call:
$categories_query = tep_db_query(...)
When I try to print
print "<BR><BR>categories_query = ".$categories_query;
I get "categories_query = Resource id #79"

How do I print the contents of $categories_query?

[Arpit]

just fetch the result from the tep_db_query() wher-ever you may choose to do so,

mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
mysql_fetch_assoc -- Fetch a result row as an associative array
mysql_fetch_field -- Get column information from a result and return as an object
mysql_fetch_lengths -- Get the length of each output in a result
mysql_fetch_object -- Fetch a result row as an object
mysql_fetch_row -- Get a result row as an enumerated array

[dhobson]

I only want to see the syntax stored in the variable. I don't actually want to see the result of the query at this time. I want to do it for debugging purposes. Like when the query fails and I can't figure out why.

[Arpit]

use the mysql error functions,
http://dev.mysql.com/doc/mysql/en/mysql-error.html