html - Edit User page in PHP and PHPMYSQL using Array Drop Down Selection -


i ask why every time try call programme doesn't show results? i'm trying create edit user page means call database mine doesn't show up.

here's edit user code have problem row4

// retrieve user's information: $q = "select first_name, last_name, phone, email , programme users user_id=$id";      $r = @mysql_query ($q);  if (mysql_num_rows($r) == 1) { // valid user id, show form.      // user's information:     $row = mysql_fetch_array ($r, mysql_num);      // create form:     echo '<div align="center"/div><form action="edit_user.php" method="post"> <p>first name: <input type="text" name="first_name" size="15" maxlength="15" value="' . $row[0] . '" /></p> <p>last name: <input type="text" name="last_name" size="15" maxlength="30" value="' . $row[1] . '" /></p> <p>phone no: <input type="text" name="phone" size="20" maxlength="60" value="' . $row[2] . '"  /> </p> <p>email address: <input type="text" name="email" size="20" maxlength="60" value="' . $row[3] . '"  /> </p> <p>programme: <name="programme" size="20" maxlength="60" value="' . $row[4] . '"  /> </p> <p><input type="submit" name="submit" value="submit" /></p> <input type="hidden" name="id" value="' . $id . '" /> </form>'; 

here's registration code because used drop down can't call drop down in edit user page include database programme registered

<?php # script 3.5 - registration form $page_title = 'registration form'; include ('./includes_css/header.html'); ?>   <div align="center"><h2>registration form</h2> <form action="register.php" method="post">  <legend>enter information in form below:</legend><br/>  <p><b>first name:</b> <input type="text" size="21" name="first_name" value="<?php if (isset($_post['first_name'])) echo $_post['first_name']; ?>"/></p> <p><b>last name:</b> <input type="text" size="21"name="last_name" value="<?php if (isset($_post['last_name'])) echo $_post['last_name']; ?>"/></p> <p><b>phone no:</b> <input type="text" size="22"name="phone" value="<?php if (isset($_post['phone'])) echo $_post['phone']; ?>"/></p> <p><b>email address:</b> <input type="text" size="18"name="email" /value="<?php if (isset($_post['email'])) echo $_post['email']; ?>"/></p> <p><b>programme:</b> <name="programme" value="<?php if (isset($_post['programme'])) echo $_post['programme']; ?>"/> <?php  $programme = array ('null' => 'select','bimd', 'bse', 'bcem', 'bca', 'dim', 'dcnet', 'dit', 'dia'); // make programme pull-down menu. echo '<select name="programme">'; foreach ($programme $key => $value) { echo "<option value=\"$value\">$value</option>\n"; } echo '</select>'; ?> <div align="center"><input type="submit" name="submit" value="register" /></div> <input type="hidden" name="submitted" value="true" /> </form> 

i have problem edit user page (program doesn't show up).

you can see here edit user page

this 1 registration page


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -