Is it possible to add those two lines of code into the original com_contact/contact.php?

what file do i need to edit? under what folder? sorry, i'm new to this stuff

excellent info on variables! Thanks Peter.

Do you guys know if its possible to pull data from other tables in mambo - such as profile data from the comprofile tables used by the community builder module in the same manner outlined above?

that's extremely helpful 
 
 
 
Paul

i need this with the data from the mos_comprofiler 

After researching it this evening and eventually not getting far, I sorted out the following code to reference fields from the mos_comprofiler table and pass the values to the facile forms fields. Place this in the value field. In this example, I have a cb_company field. The field name should be the only aspect you need to change. 

Code didn't show in the post below: 
 

< ? php global $database,$my; $query = "SELECT cb_company FROM #__comprofiler WHERE id = ". $my->id; 
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?>

Below is an example of a small segment of code that accesses the mos_comprofiler table to access the custom cb_company field. 
 
To access other fields in mos_comprofiler, just change the name of the field. 
 
To access fields in mos_users that aren't accessible by $my->id, use #__users for the table and which ever field name you need instead of cb_company. 
 
To access fields in other tables that have $my->id able to be used as a key, substitute the relevant table and field names.

When I use the above code in the VALUE of my form field, The field fills out properly with a value! However, I get a popup window with a DNS Error / Can't Find Server. This pops up in Facile Forms design time and live on the site. 
 
What am I doing wrong?

The following code is not functioning as described above: 
 
< ? php global $database,$my; $query = "SELECT cb_company FROM #__comprofiler WHERE id = ". $my->id;  
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
Suggestions? 
 
Joomla 1.0.8 
 
Thanks 
 
JOHN

< ? php global $database,$my; $query = "SELECT cb_company FROM #__comprofiler WHERE id = ". $my->id;  
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
OK, I'm trying to insert in a field called "Firma" the name of the company which was entered before and is now stored in the table "jos_user_extended" in the field "user1". 
 
< ? php global $database,$my; $query = "SELECT user1 FROM #__user_extended WHERE id = ". $my->id;  
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
I just get the following result in the "Firma" text area: 
 
< ? php global $database,$my; $query =  
 
 
I have no clue where to search the error so please help me !!! 
 
Thanks in advance!  
 
 
SirBerberitz

This code works for me (removed the spaces at the begining and change cb_company with company) 
null[Joomla 1.0.11 and CB 1.0.1 stable] 
 
id;  
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
Best regards, 
 
Jorge

This code works for me (removed the spaces at the begining and change cb_company with company) 
[Joomla 1.0.11 and CB 1.0.1 stable] 
 
id;  
$database->setQuery( $query ); $fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
Best regards, 
 
Jorge

I mean write this without spaces: 
 
sts but wrap my text when write the complete code) 
 
Best regards, 
 
Jorge

Your downloadsection is down  
 
I get this error: 
Fatal error: Cannot instantiate non-existent class: dmconfig in /home/formfaci/public_html/administrator/components/com_docman/classes/DOCMAN_config.class.php on line 88

More so I don't have to remember it, but also to share it, here's the code to insert for Firstname and Lastname using Community Builder. 
 
To activate it in the textarea you drop it into, remove the space between setQuery($query); 
$database->query();$fieldvalue = $database->loadResult(); return $fieldvalue;?> 
 
id; $database->setQuery($query); 
$database->query();$fieldvalue = $database->loadResult(); return $fieldvalue;?>

It works excellently. But I always get a debug window with things like  
----------------------------------------------------------- 
** AUSNAHMEBEDINGUNG DURCH FACILEFORMS AUFGEFANGEN *** 
PHP Fehlerstufe : E_NOTICE 
PHP Dateiname : /home/www/web42/web/components/com_facileforms/facileforms.process.php 
PHP Zeilennummer: 686 
Fehlermeldung : Use of undefined constant PREG_OFFSET_CAPTURE - assumed 'PREG_OFFSET_CAPTURE' 
---------------------------------------------------- 
How can I get rid of it? 
Cyrus

Alignment? 
 
Works fine but the text for name and email aligns with x=0 even though the FF value is x=5. 
 
Any idea how to fix this?

Never mind. It helps to align the name and email value fields with the nudger. Interesting how a text element is used to outline the border box while a following text/html element is used for the value.

hello guys, i need to know how to create submit button that automatically send the form to my e-mail. 
thank you for your help.

Cool, but... remove the space between the ; and the php closing tag if the space bothers you in the input area for guest visitors.

Hi folks! 
 
I'm new to ff and have a question regarding this topic ... 
 
i've put this code: 
 
name;  
$database->setQuery($query); $fieldvalue = $database->loadResult(); return $fieldvalue;?>  
 
in the value box of a textaera. the database table adressen exists ( and yes, its in the same database but without the joomla prefix ...) , and the field adressen.num matches the $my->name field so it should return the field adressen.nachname ... but the field is empty. 
 
Another field i've put this code in : 
 
username; ?> 
 
and on entering the form that field is filled .. 
 
whats wrong with the first code? 
 
 
if i get this working i woud like to fill the textarea with some more database fields from that database, like name, adress, city, etc ...