php - Populate dropdown box won't show up database -

-

i'm trying populate dropdown box retrieve database mysql. here form , php files below. looks alright me, don't why doesn't show thing when click on submit button. there can fix error? correction , suggestion appreciated.

cs_jobs table consists of: job_title, category_code (17, 27, 37....), ...etc.

connect.php works fine in case.

my form

<!doctype html> <html>     <head></head>     <body>         <form action = "csjob.php" method = "post" name = "jobsearch">             <select name = "category_code[]">                 <option value = "17">architecture , engineering</option>                 <option value = "27">arts, design, entertainment, sports, , media</option>                 <option value = "37">building , grounds cleaning , maintenance</option>                 <option value = "13">business , financial operations</option>                 <option value = "21">community , social services</option>                 <option value = "15">computer , mathematical</option>                 <option value = "47">construction , extraction</option>                 <option value = "25">education, training, , library</option>                 <option value = "45">farming, fishing, , forestry</option>                 <option value = "35">food preparation , serving related</option>                 <option value = "29">healthcare practitioner , technical</option>                 <option value = "31">healthcare support</option>                 <option value = "49">installation, maintenance, , repair</option>                 <option value = "23">legal</option>                 <option value = "19">life, physical, , social science</option>                 <option value = "11">management</option>                 <option value = "43">office , administrative support</option>                 <option value = "39">personal care , service</option>                 <option value = "51">production</option>                 <option value = "33">protective service</option>                 <option value = "41">sales , related</option>                 <option value = "53">transportation , material moving</option>             </select>             <input type="submit" value="submit">          </form>     </body> </html>

csjob.php

<?php      require("connect.php");     if(isset($_post['submit'])){         $sql = "select * cs_jobs category_code=".$_post['category_code'];         $result = mysql_query($sql);          echo "<select name='category_code'>";         while ($row = mysql_fetch_array($result)) {             echo "<option value='".$row['job_title']"'>".$row['job_title']"</option>";         }         echo "</select>";     } ?>

so many typos in question, here actual code upload: a link!

you have 3 small problems. first 1 in form:

<select name = "category_code[]">

should be

<select name="category_code">

so without brackets [] in name , no need spaces...
brackets needed if have option has multiple select, , return array (hence brackets). isn't happening in case.

and second problem said before: in php:

$row['job_title'}

should be

$row['job_title']

so change } ]

your third problem has checking submit:

if(isset($_post['submit'])){

should be

if(isset($_post['category_code'])){

because don't have field name 'submit'. have field id submit , value submit. no name submit. can add name='submit' submit button. or go proposed change above...


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more