Novodk
-
Posts
3 -
Joined
-
Last visited
Posts posted by Novodk
-
-
You sure can; where are you stuck? If you're unsure how to get the date information once the link is clicked, perhaps the following will help:
That link was all i needed, thanks alot.
Now i got another problem, i want to be able to add data from my database to a dropdown menu, lets call the table "Table1" row "Name"
echo "<select name='username'>"; while ($row = mysql_fetch_array($result)) { echo "<option value='" . $row['username'] ."'>" . $row['username'] ."</option>"; } echo "</select>";
That works fine, but if i want to add more data from another table called "Table2" row "Age" how do i do that, i think my problem is how to setup my Recordset
-
I got this calendar on my site and i made the dates clickable, but is it possible to make it so that when i click on the dates it opens a new site where it shows somthing like:
<?php $monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); ?> <?php if (!isset($_REQUEST["month"])) $_REQUEST["month"] = date("n"); if (!isset($_REQUEST["year"])) $_REQUEST["year"] = date("Y"); ?> <?php $cMonth = $_REQUEST["month"]; $cYear = $_REQUEST["year"]; $prev_year = $cYear; $next_year = $cYear; $prev_month = $cMonth-1; $next_month = $cMonth+1; if ($prev_month == 0 ) { $prev_month = 12; $prev_year = $cYear - 1; } if ($next_month == 13 ) { $next_month = 1; $next_year = $cYear + 1; } ?>
<tr> <td align="center"> <table cellpadding="2" cellspacing="2"> <tr align="center"> <td colspan="7"><?php echo $monthNames[$cMonth-1].' '.$cYear; ?></td> </tr> <tr> <td align="center">M</td> <td align="center">T</td> <td align="center">O</td> <td align="center">T</td> <td align="center">F</td> <td align="center">L</td> <td align="center">S</td> </tr> <?php $timestamp = mktime(0,0,0,$cMonth,1,$cYear); $maxday = date("t",$timestamp); $thismonth = getdate ($timestamp); $startday = $thismonth['wday']; $newdate = date('Y-m-j',$timestamp); $newdate = strtotime ( '-1 day' , strtotime ( $newdate ) ) ; $newdate = date('Y-m-j',$newdate); $today = date('j'); for ($i=0; $i<($maxday+$startday); $i++) { if(($i % 7) == 0 ){ echo "<tr>"; } if($i < $startday){ echo ("<td class='cell_txt'> </td>"); } else { if (($i - $startday + 1) == $today){ echo ("<td class='cell_today'><a href='#'>".($i - $startday + 1)."</a></td>"); } else { echo ("<td class='cell_txt'><a href='tftimer.php?day=". ($i - $startday + 1) . "&month=$cMonth&year=$cYear'>".($i - $startday + 1)."</a></td>"); } } if(($i % 7) == 6 ) { echo "</tr>\n"; } } ?> </table> </td> </tr>
I hope someone can help
adding data to a calender
in MySQL Help
Posted · Edited by Novodk
Im using Dreamweaver and there is an automatic thing that adds that piece of code, it works okay, but it shows each entry from the database twice in the dropdown menu, anyone that can figure out why?