$query = 'SELECT IDMessage, MsgState, MsgSubject FROM UserMessage WHERE IDUser=\''.$_SESSION['ID'].'\';'; $result = mysql_query($query); while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { printf ("%s ", $row["IDMessage"], $row["MsgSubject"]); }
$Query = 'SELECT IDMessage, MsgState, MsgSubject FROM UserMessage WHERE IDUser=\''.$_SESSION['ID'].'\' and MsgState=\'NotReaded\';'; $Rq = mysql_query($Query); $Cnt = mysql_num_rows(Rq);
[.\GetMessage.php?idMessage=351 Sujet du message] [.\GetMessage.php?idMessage=358 Sujet du message]
$selectQuery = 'SELECT * FROM UserMessage WHERE IDUser=\''.$_SESSION['ID'].'\' and IDMessage=\''.$_GET["idMessage"].'\';' $updateQuery = UPDATE UserMessage SET MsgState=\'Readed\' WHERE IDUser=\''.$_SESSION['ID'].'\' and IDMessage=\''.$_GET["idMessage"].'\';' $result = mysql_query($selectQuery);
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question