By franck_media on

Hello,

Is there a solution to put a query and php code in a body page ? Is there a module for that ?

Thank you ...

⋅ Categories: Drupal 6.x

Comments

VM’s picture

VM commented

enable the php filter.module in administer -> modules

this will give you a php input format to use.

franck_media’s picture

franck_media commented

Thank you ...

I know that, but I don't know the information for the query, the connection etc.

VM’s picture

VM commented

could you elaborate on what you are trying to accomplish, with the query?

if creating a list, you may want to investigate the views.module otherwise, you will have to look into api.drupal.org or other modules for how db querries are called. There is a drupal function for it ie:db_query() or something to that effect.

franck_media’s picture

franck_media commented

Yes, thank you,

I need to have more than group by for a view ? I try to have this description, and I can't:

Country1
Supplier1

Product1
Product2
Product3

Supplier2

Product4

Pays2
Supplier3
Produict5

etc.

So, I need to build this page by implementing custom sql query and php code in a body of page ...

franck_media’s picture

franck_media commented

Hello,

is there a simple module, just to put our query in a body page ?

Thank you

VM’s picture

VM commented

As far as I know, the only query builder is the views.module

if views aren't laid out like you would like them to be you can theme them.

Otherwise, you have to take a look at api.drupal.org

franck_media’s picture

franck_media commented

Thank you ...