Possible Duplicate:
Print the query which is built using db_select()

How can I remove

and table prefix from database query
debug function.

  • Put the actual data into the placeholder. When I printed the queries, it gave me the table name in brackets: {table}. What is the prefix for you? Plz, provide the query, you are debugging. – user4035 Jan 15 '13 at 12:45
  • it's ok, but what I should do to replace the tables prefix with {} dynamically. so can I print it directly to Navicat or PHPMyadmin for example directly. – Omar Alahmed Jan 16 '13 at 6:27
  • did you try dpq function from devel module: api.drupal.org/api/devel/devel.module/function/dpq/7? Seems pretty good. – user4035 Jan 16 '13 at 12:39
  • yes I did, but unfortunately, it doesn't remove it. In drupal 6 there is a function called db_prefix_tables() but I can't find it in drupal 7! – Omar Alahmed Mar 11 '13 at 11:31

Browse other questions tagged or ask your own question.