Search the Community

Hi, I got a dropdown and a textbox. The dropdown is getting data from the database and showing the names. Now i want to save that names ID and send it to the database. How can i do this? Do i have to make another query something like this? Or can i make it some other (better) way, Maybe this is a question for the SQL-forum? $categoryId = mysql_query("SELECT categoryId FROM `projectCategory` WHERE categoryName = '" . mysql_real_escape_string($_POST['categoryName'])); Here is my code: <?php if (isset($_GET['add_h_success']) && empty($_GET['add_h_success'])) { echo 'Projekt tillagt.'; } else { if (empty($_POST) === false && empty($errors) === true) { add_hproject($_POST['huvudProjectName'], $categoryId); header('Location: add_hproject.php?add_h_success'); } else if (empty($errors) === false) { echo output_errors($errors); } ?> <?php $options = ''; $category=mysql_query("SELECT categoryName, categoryId FROM `projectCategory`"); while($row = mysql_fetch_array($category)) { $options .="<option>" . $row['categoryName'] . "</option>"; } ?> <form action="" method="POST"> <ul> <li> <?php $menu=" <select name='categoryId'> " . $options . " </select> </form>"; echo $menu; ?> </li> <li>Namn: <br> <input type="text" name="huvudProjectName"> </li> <li> <input type="submit" value="Lägg till"></li> </ul> </form>