$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>"
Alle Zeitangaben sind in GMT + 1 Stunden