kod php:
if($_POST[pomoc] == 'wyslij') { $user_id = $user[id]; $tytul = $_POST[tytul]; $tresc = $_POST[tresc]; $pomoc = "INSERT INTO pomoc VALUES (NULL, '$user_id', '$tytul', '$tresc', NOW(), '0')"; $user = "SELECT * FROM users WHERE login='$_SESSION[logowanie]'"; $nowe = "SELECT * FROM pomoc WHERE temat='$tytul' AND tresc='$tresc' AND id_user='$user_id'"; echo'<center style="font-size: medium;">Wiadomośc Wysłana</center> <meta http-equiv="Refresh" content="2;url=index.php?s=pomoc">'; } else { echo'<form action="" method="post"><table align="center"> <tr> <td>Tytuł :</td> <td align="center"><input type="text" name="tytul"></td> </tr> <tr> <td style="height: 116px">Treśc</td> <td style="height: 116px"><textarea name="tresc" style="width: 332px; height: 112px"></textarea></td> </tr> <tr> <td colspan="3" height="1"></td> </tr> <tr> <td colspan="3" align="center"><center><input type="hidden" name="pomoc" value="wyslij"><input type="submit" value="Wyślij"></center></td> </tr> </table> </form>'; }
kod mysql:
CREATE TABLE IF NOT EXISTS `pomoc` ( `id` int(10) NOT NULL, `id_user` varchar(255) NOT NULL, `temat` varchar(255) NOT NULL, `tresc` text NOT NULL, `data` datetime NOT NULL, `status` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
proszę o pomoc. z gury dzięki