Dragonfly CMS - German Community

$sql=" Select id, username, username, user_email, subject, body_begin, date
		FROM " . groupmail . " 
        ORDER BY $id";
		if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query id', '', __LINE__, __FILE__, $sql);
}

On /index.php?name=Groupmail
While executing query " Select id, username, username, user_email, subject, body_begin, date
		FROM groupmail 
        ORDER BY "

the following error occured: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

$sql=" Select id, username, username, user_email, subject, body_begin, date
		FROM (".$prefix."_groupmail) 
        ORDER BY id";
		if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query id', '', __LINE__, __FILE__, $sql);
}

."<td>$body_begin</td>"

$sql=" Select id, username, user_email, subject, body_begin, date, body
		FROM (".$prefix."_groupmail) 
        ORDER BY id";
		if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query id', '', __LINE__, __FILE__, $sql);
}				while(list($id ,$username ,$user_email, $subject, $body_begin, $date )=mysql_fetch_row($result)){
	echo "<tr>"
	//."<td>$id</td>"
	."<td>$username</td>"
	."<td><a href=\"mailto:$user_email\"> <img src=\"../../images/icon_email.gif\" border=\"0\"></a></td>"
	."<td>$subject</td>"
	."<td>$body_begin</td>"
	."<td>$date</td>"
	."</tr>";
	
}

 ."<td>$body_begin</td>"