[ag2ieric]

Hi,
i'm facing a problem that i couldnt succeed in solving by myself nor with google help and i hope someone could help me here.

I want to make a simple mysql insert from a custom php block
i use
- a form
- with an input text
- at submit, i try to store the text in a table


Seems simple, but I face a double problem :

In dev env (WAMP+Win XP) :
when i use a db_query(...) function, it says no db select --> can't find how to select the db
when i use a direct sql insert function (mysql_query), it works

Now In final prod env (server)  :
direct sql saying "database error in code block' .
when i use a db_query(...) function, i got the same "database error in code block'.
--> it won't validate the new block.

I would really appreciate to have clues to solve the problem, a sample code or some tip to make this simple insert working ! thank in advance

EDIT:
I use this code in the php block that seems to work fine:

Code Select Expand


    global $boarddir;
    require_once($boarddir . '/../my_funcs.php');
    mycustomfunc();


My FIRST TRY : not working: (error = no database selected)
[code]
mycustomfunc()
{
   global $ID_MEMBER, $user_info, $db_connection,$db_prefix,$context;
   if (isset($_POST['question']) && !empty($_POST['question']))
   {
      $question = strip_tags($_POST['question']);

        $request = db_query("
            INSERT INTO {$db_prefix}faq
            VALUES (NULL, '".$question."', $ID_MEMBER),", __FILE__, __LINE__);
        if ($request) {
            echo "votre question

[ag2ieric]

ok guys, seems i solved my problem

simply check "disable php validation" into the admin panel > SimplePortal > general settings