i'm having problems updating a calender to my database...
it does what its supposed to but it just won't add the calendar, it will let me write small things like a few words only... so how can i make it able to write the whole calendar in?
the code of the site:
the code of the calender, i have no clue if it should be the size(length, size), i made a program to generate the code..Code:<?php session_start(); if(session_is_registered(myusername)){ if (isset($_POST['kalender'])) { if (empty($_POST['kalender'])) { echo "jeg skriver ikke ingenting ind i databasen ;)"; } else { $connection = mysql_connect("localhost","root",""); mysql_select_db("kalender",$connection); $counter = mysql_query("SELECT * FROM kalender WHERE id = '1' "); /* made id to 1 because i wouldn't need more then 1 in this */ $num = mysql_num_rows($counter); $kalender = $_POST['kalender']; if ($num == 0) { $result = mysql_query("INSERT INTO kalender (kalender) VALUES ('$kalender')"); } else { $result = mysql_query("UPDATE kalender SET kalender = '$kalender' WHERE id = '1'"); } if ($result) { echo "Success! :)"; } else { echo "hmmm... der skete lidt af en fejl :("; } } } ?> <form name="opret2" action="?a=opret2" method="POST"> <table border="0"> <tr> <td>Indsæt Kalender:<br> <textarea cols="30" rows="10" name="kalender"></textarea></td> </tr> <tr> <td> <input type="submit" cols="30" rows="10" name="submit" value="Opret Event"></td> </tr> </table> </form> <?php } else { include("loginform.php"); } ?>
Code:<table width='100%' border='1' style='border-width:1px;background:url(background2.PNG);border-collapse:collapse;'> <tr style='text-align:right;vertical-align:top;height:40px;'> <td colspan='7' ALIGN='center' VALIGN='middle' style='padding:2px;'><h1><b>Januar 2010</b></h1></td> </tr> <tr style='text-align:center;height:40px;'> <td><h3>Mandag</h3></td> <td><h3>Tirsdag</h3></td> <td><h3>Onsdag</h3></td> <td><h3>Torsdag</h3></td> <td><h3>Fredag</h3></td> <td><h3>Lørdag</h3></td> <td><h3>Søndag</h3></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td>1 <br><center><a href='?b=Events'></a></center></td> <td>2 <br><center><a href='?b=Events'></a></center></td> <td>3 <br><center><a href='?b=Events'></a></center></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td>4 <br><center><a href='?b=Events'></a></center></td> <td>5 <br><center><a href='?b=Events'></a></center></td> <td>6 <br><center><a href='?b=Events'></a></center></td> <td>7 <br><center><a href='?b=Events'></a></center></td> <td>8 <br><center><a href='?b=Events'></a></center></td> <td>9 <br><center><a href='?b=Events'></a></center></td> <td>10 <br><center><a href='?b=Events'></a></center></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td>11 <br><center><a href='?b=Events'></a></center></td> <td>12 <br><center><a href='?b=Events'></a></center></td> <td>13 <br><center><a href='?b=Events'></a></center></td> <td>14 <br><center><a href='?b=Events'></a></center></td> <td>15 <br><center><a href='?b=Events'></a></center></td> <td>16 <br><center><a href='?b=Events'></a></center></td> <td>17 <br><center><a href='?b=Events'></a></center></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td>18 <br><center><a href='?b=Events'></a></center></td> <td>19 <br><center><a href='?b=Events'></a></center></td> <td>20 <br><center><a href='?b=Events'></a></center></td> <td>21 <br><center><a href='?b=Events'></a></center></td> <td>22 <br><center><a href='?b=Events'></a></center></td> <td>23 <br><center><a href='?b=Events'></a></center></td> <td>24 <br><center><a href='?b=Events'></a></center></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td>25 <br><center><a href='?b=Events'></a></center></td> <td>26 <br><center><a href='?b=Events'></a></center></td> <td>27 <br><center><a href='?b=Events'></a></center></td> <td>28 <br><center><a href='?b=Events'></a></center></td> <td>29 <br><center><a href='?b=Events'></a></center></td> <td>30 <br><center><a href='?b=Events'></a></center></td> <td>31 <br><center><a href='?b=Events'></a></center></td> </tr> <tr style='text-align:right;vertical-align:top;height:60px;'> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> <td> <br><center><a href='?b=Events'></a></center></td> </tr> </table>




Reply With Quote