need help with php and database

newguy2010 · 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);
}
?>

Sign In

need help with php and database

Recommended Posts

newguy2010

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information