Hi

I have got a foolowing script that I found here which should grab relevant data and insert in into a hidden field that I have created. Unfortunatelly I cannot get it working. Can somebody help? Thanks a mill. Dan

//<code>
global $database, $my;//global declaration
$mydata = $my->id;//fetching the user id who has logged in

if($mydata!=0)
{
$data = mysql_query("SELECT * FROM jos_table WHERE id = '".$my->id."'")or die(mysql_error())
;//this query will fetch you the record of that particular user
while($info = mysql_fetch_array( $data ))
{
return $info;//return the name of the user which will be populated in the text filed
}
}
else
{
return 'no record';
}
//</code>

It gives me that no record found

Did you find the answer? I too am looking to populate a hidden field from the database. My problem might be slightly different as I am trying to populate a hidden field with the "SubmissionId" from the _rsform_submission_values table when it matches a name from a form.

You should go here (docs.joomla.org/How_to_use_the_database_classes_in_your_script) and read about joomla! database classes. It will make your life a little easier.

To get the user id try this

$user = &JFactory::getUser();
$uid = $user->get('id');

I use the following to connect to the database.
$db =& JFactory::getDBO();
$db->setQuery("QUERY");

What kind of information are you trying to retreive? Is it user account related or something else?

Found solution to prefill hidden field (or text field) from DB.

Place this in Default Value:

here is how to correct/customize it for your need:

column_label = column (sometimes called field) of the record in your DB table.
dbtextlabel = This is the table in your DB...!keep the #__! add this to the end of it with no spaces.
$variablename1 = you make up a variable name here...!has to have "$" in the front like above!

I hope this really helps the non-programmers!