0

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

How can I remove

:db_insert_placeholder_0
and table prefix from database query
__toString()
debug function.

marked as duplicate by Clive Jan 15 '13 at 12:43

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

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