Sif Eddine Sarhane

{source} load(JRequest::getInt('id')); $cdd_authorid = $cdd_article->created_by; //Grab the contact associated with the above user ID $db =& JFactory::getDBO(); //Establish DB Link $query = "SELECT * FROM rnyq2_users WHERE id = " . $cdd_authorid ; $db->setQuery($query); //Execute query. Should return 1 row $cdd_contact = $db->loadAssoc(); //Load results as associative array $cdd_email = $cdd_contact['email']; echo $cdd_email; ?> {/source}