newguy2010 Posted March 24, 2011 Share Posted March 24, 2011 i have got this code and i can get everything to work on this except the part to get the drop down menu for the sections, i can get the 4 sections to show but every time i try to add something to any section it is added to the last section no matter what plz help <?php require("connection/connection.php"); include("connection/functions.php"); ?> <HTML> <head> <link href="css/style.css" rel="stylesheet" media="screen" type="text/css" /> <script src="javascript/functions.js" type="text/javascript"></script> <title>.: Bookmarks :.</title> </head> <body class="musiclist"> <div id="content" style="top: 36px"> <form method="post" action="AddBookmark.php"> <span class="graytitle">Add Bookmark</span> <ul class="pageitem"> <li class="bigfield"><input type="text" name="BookmarkName" placeholder="Bookmark Name" /></li> <li class="bigfield"><input type="text" name="KindofBookmark" placeholder="Kind of Bookmark" /></li> <li class="bigfield"><input type="text" name="BookmarkLink" placeholder="Bookmark Link" /></li> <li class="select"><select name="d"> <?php $getbookmarksections = mysql_query("SELECT * FROM bookmarksections"); confirm_query($getbookmarksections); while($getbm = mysql_fetch_array($getbookmarksections)){ $bmid = $getbm["ID"]; $sn = $getbm["SectionName"]; echo "<option value=\"$bmid\">$sn</option>"; } ?> </select><span class="arrow"></span></li> <li class="button"> <input name="AddBookmark" type="submit" value="Add Bookmark" /> </li> </ul> </form> <?php if(isset($_POST["AddBookmark"])){ $Bookmark = $_POST["BookmarkName"]; $KindofBookmark = $_POST["KindofBookmark"]; $BookmarkLink = $_POST["BookmarkLink"]; $add = mysql_query("INSERT INTO `bookmarks` (`ID`,`SectionID`,`KindofBookmark`,`Bookmark`,`BookmarkLink`) VALUES ('NULL','$bmid','$KindofBookmark','$Bookmark','$BookmarkLink')"); confirm_query($add); if($add == TRUE){ echo "<span class=\"graytitle\">Bookmark '$Bookmark' in '$sn' Added.</span>"; } } ?> </div> <div id="footer"> </div> </body> </HTML> <?php //Close Connection if(isset($connection)){ mysql_close($connection); } ?> Quote Link to comment https://forums.phpfreaks.com/topic/231556-need-help-with-php-and-database/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.