I am a drupal beginner (read and completed the first two tutorials on module development), and would like to know more about DB access.
Let's say, for sake of example, that I want to create a module that sorts recipes according to page and recipe number; to this extent I create, inside the drupal DB, a table called "recipes".
Can I query this table directly with drupal functions? And if yes, how? Does it has to follow the table naming conventions of the other tables (prefix, ecc.)?
I would greatly appreciate if someone could write a sample meta-code on how to get, say, recipe_text and recipe_difficulty fields from a fictional "recipes" table.