1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
<script type="text/javascript">
/*la Fonction*/
<?
function mark_unread($user_id) {
mysql_connect("", "", "");
mysql_select_db("");
$user = $user_id;
$sql_3 = mysql_query('SELECT id_news,titre
FROM news_wow
WHERE id_news NOT IN
(SELECT id_news FROM suivi_news WHERE user_id = '.$user_id.')
ORDER BY date DESC ');
while(($data2= mysql_fetch_assoc($sql_3))) {
$id_news=$data2['id_news'];
$sql_mark = mysql_query('INSERT INTO `suivi_news` (
`user_id` ,
`id_news`
)
VALUES (
'.$user_id.', '.$id_news.'
)');
}
}
?>
</script>
/* L'appel de la fonction */
echo"<tr><td align='center'><a class='mark'href='#'onClick='".mark_unread($user_id)."'>Marquer tous les messages comme lus</a></td></tr>"; |
Partager