SQL query in registration.php

mommi84 · 14.04.2006, 10:47

Hi,
I'd like to call a SQL query in the registration.php file, like this one.

PHP Code:

          $database->setQuery( "SELECT name, email FROM #__users"

        ."\n WHERE usertype='superadministrator'" );

        $rows = $database->loadObjectList();

        $row2 = $rows[0];

        $adminName2 = $row2->name;

        $adminEmail2 = $row2->email;

but the following code doesn't work.

PHP Code:

  $database->setQuery( "INSERT INTO mos_letterman_subscribers (subscriber_id, user_id, subscriber_name, subscriber_email, confirmed, subscribe_date) VALUES (null,".$row->id.",'".$row->name."','".$row->email."',1,'".$row->registerDate."')" );

It seems Mambo doesn't support the INSERT query!
How do I?
Thank you!

mommi84 · 14.04.2006, 12:05

Haha solved! I missed this statement

PHP Code:

  $database->query();