Står med et strot problem... ved at lave et lille system som tager noget info fra en form og smider i en database. Hvis man udfylder formen i dag og trykker opret laver den en ny linie i databasen men den fylder ikke informationen fra felterne i.
Eneste der bliver udfyldt er id og den står til auto increasment...
Hva er det lige der går galt hvorfor for jeg ikke information ind i min tabel ???
Koden...
HTML
- <?
- // oprettelse af mail i systemet... mulighed for fjernelse af mail.
- if($_POST[send]){
- include ("mysql_connect.php");
- mysql_connect($host,$user,$pass);
- mysql_select_db($db);
- $mailname = mysql_query("SELECT * FROM mail_systen_test WHERE m_email = '" . $_POST[email] . "'");
- $count = (mysql_num_rows($mailname));
- if($count == 0) {
- mysql_query("INSERT INTO mail_systen_test (m_navn, m_postnr, m_butik, m_alder, m_email)" . "VALUES
- ('$navn', '$postnr', '$butik', '$alder', '$email')");
- }
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
- <title>Stof og Stil</title>
- <link href="style.css" rel="stylesheet" type="text/css" />
- <style type="text/css">
- </style>
- </head>
- <body>
- <?
- while($row = mysql_fetch_array($event))
- { ?>
- <table width="527" height="76" border="0" align="center" cellpadding="0" cellspacing="2">
- <form name="post" method="post">
- <tr>
- <td colspan="5" class="Overskrift">Oprettelse af E-mail modtager </td>
- </tr>
- <tr>
- <td width="45"> </td>
- <td width="236"> </td>
- <td width="9"> </td>
- <td width="94"> </td>
- <td width="143"> </td>
- </tr>
- <tr>
- <td class="plain_tekst">Navn</td>
- <td>
- <input name="navn" type="text" class="input_felt"/> </td>
- <td> </td>
- <td class="plain_tekst">Sidst oprettet:</td>
- <td class="plain_tekst"><? print $row['m_email']; ?></td>
- </tr>
- <tr>
- <td class="plain_tekst">Post nr. </td>
- <td><input name="postnr" type="text" class="input_felt"/></td>
- <td> </td>
- <td class="plain_tekst">Antal i alt: </td>
- <td class="plain_tekst"><? print $talt; ?></td>
- </tr>
- <tr>
- <td class="plain_tekst">Butik</td>
- <td><select name="butik" class="drop_down">
- <option value="roskilde">Roskilde</option>
- <option value="herning">Herning</option>
- <option value="aalborg">Aalborg</option>
- <option value="odense">Odense</option>
- <option value="aarhus">Århus</option>
- <option value="drammen">Drammen</option>
- <option value="malmo">Malmö</option>
- </select> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td class="plain_tekst">Alder</td>
- <td><input name="alder" type="text" class="input_felt"/></td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td class="plain_tekst">E-Mail</td>
- <td><input name="email" type="text" class="input_felt"></td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- <tr>
- <td> </td>
- <td><input name="send" type="submit" value="Opret"></td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- </form>
- </table>
- <?
- }
- ?>
- </body>
- </html>