The forums have permanently moved to This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.

Results 1 to 3 of 3

Thread: MySQL database and HTML?

  1. #1

    MySQL database and HTML?

    I have a problem with data adding form..
    Ok, so when I added fields into MySQL database through phpmyadmin, I made there many fields which are 'ENUM' or 'SET' and I wrote few options under those fields.
    Now when I have this Html form which can edit old items or add new items into database.
    I would like to get scrollbars for those 'ENUM' or 'SET' fields, but how?
    I have here a simple html code:

    <SELECT NAME="xxx">
    <OPTION> 1
    <OPTION> 2
    <OPTION> 3
    <OPTION> 4
    <OPTION> 5

    The problem is that I don't know how to get the options from database into <OPTION> 1, <OPTION> 2 and so on...

    I hope that somebody understood what I ment here...

  2. #2

  3. #3
    PHP Code:

    function getOptions($field,$table) {
    $result=mysql_query("SHOW COLUMNS FROM `$table` LIKE '$field'");
       } else {
    $options as $val) {
    $optionList.="<option value='$val'>$val</option>";

    // example
    $options getOptions('fieldnamehere','tablenamehere');
    "<select name='blah'>";

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Home About Meet the Moderators Advertise

 Link to Us


Copyright 1999 - 2012