Setting default values

I am having a problem setting the default values of a form to the values in a table. I want to recall the current user’s values and allow the user to edit them. Can someone please help?

My code is as follows:

<?php session_start(); if (!isset($_SESSION['user'])) { header("Location: login.php"); } include ('dbc.php'); if ($_POST['Submit']=='Change') { $rsPwd = mysql_query("select user_pwd from users where user_email='$_SESSION[user]'") or die(mysql_error()); mysql_query("Update users SET full_name = '$full_name' WHERE user_email = '$_SESSION[user]' ") or die(mysql_error()); header("Location: settings.php?msg=Settings updated..."); } ?> <?php $result = mysql_query ("SELECT * FROM users WHERE user_email LIKE '$_SESSION[user]' "); if ($row = mysql_fetch_array($result)) { do { PRINT "Username: "; print $row["full_name"]; print (" "); print ("
"); PRINT "Name: "; print $row["user_name"]; print ("
"); PRINT "Email: "; print $row["user_email"]; print ("
"); PRINT "Class: "; print $row["l_class"]; print ("
"); PRINT "Call Sign: "; print $row["call_sign"]; print ("
"); PRINT "Country: "; print $row["country"]; print ("
"); } while($row = mysql_fetch_array($result)); } else {print "Sorry, no records were found!";} ?> <?php if (isset($_GET['msg'])) { echo "
$_GET[msg]
"; } ?>
Edit Account for <?php print $_SESSION[user] ?>


Name: " id="full_name">

      Ex. John Wilson</p>
      User Name: 
      <input name="user_name" type="text" id="user_name">Ex. John </p>
      <p>Email: 
      <input name="email" type="text" id="email">
      Ex. [email protected]</p>

    </p>
      <p>Class: 
      <select name="l_class" id="select8">
        <option value="Novice">Novice</option>
        <option value="Tech">Tech</option>
        <option value="HF Tech">HF Tech</option>
        <option value="General">General</option>
        <option value="Advanced">Advanced</option>
        <option value="Extra">Extra</option>
      </select>
    </p>
	  <p>Call Sign: 
      <input name="call_sign" type="text" id="call_sign">          
    <p>Country: 
      <select name="country" id="select8">
        <option value="USA">USA</option>
        <option value="Afghanistan">Afghanistan</option>
        <option value="Albania">Albania</option>
        <option value="Algeria">Algeria</option>
        <option value="Andorra">Andorra</option>
        <option value="Anguila">Anguila</option>
        <option value="Antarctica">Antarctica</option>
        <option value="Antigua and Barbuda">Antigua and Barbuda</option>
        <option value="Argentina">Argentina</option>
        <option value="Armenia ">Armenia </option>
        <option value="Aruba">Aruba</option>
        <option value="Australia">Australia</option>
        <option value="Austria">Austria</option>
        <option value="Azerbaidjan">Azerbaidjan</option>
        <option value="Bahamas">Bahamas</option>
        <option value="Bahrain">Bahrain</option>
        <option value="Bangladesh">Bangladesh</option>
        <option value="Barbados">Barbados</option>
        <option value="Belarus">Belarus</option>
        <option value="Belgium">Belgium</option>
        <option value="Belize">Belize</option>
        <option value="Bermuda">Bermuda</option>
        <option value="Bhutan">Bhutan</option>
        <option value="Bolivia">Bolivia</option>
        <option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
        <option value="Brazil">Brazil</option>
        <option value="Brunei">Brunei</option>
        <option value="Bulgaria">Bulgaria</option>
        <option value="Cambodia">Cambodia</option>
        <option value="Canada">Canada</option>
        <option value="Cape Verde">Cape Verde</option>
        <option value="Cayman Islands">Cayman Islands</option>
        <option value="Chile">Chile</option>
        <option value="China">China</option>
        <option value="Christmans Islands">Christmans Islands</option>
        <option value="Cocos Island">Cocos Island</option>
        <option value="Colombia">Colombia</option>
        <option value="Cook Islands">Cook Islands</option>
        <option value="Costa Rica">Costa Rica</option>
        <option value="Croatia">Croatia</option>
        <option value="Cuba">Cuba</option>
        <option value="Cyprus">Cyprus</option>
        <option value="Czech Republic">Czech Republic</option>
        <option value="Denmark">Denmark</option>
        <option value="Dominica">Dominica</option>
        <option value="Dominican Republic">Dominican Republic</option>
        <option value="Ecuador">Ecuador</option>
        <option value="Egypt">Egypt</option>
        <option value="El Salvador">El Salvador</option>
        <option value="Estonia">Estonia</option>
        <option value="Falkland Islands">Falkland Islands</option>
        <option value="Faroe Islands">Faroe Islands</option>
        <option value="Fiji">Fiji</option>
        <option value="Finland">Finland</option>
        <option value="France">France</option>
        <option value="French Guyana">French Guyana</option>
        <option value="French Polynesia">French Polynesia</option>
        <option value="Gabon">Gabon</option>
        <option value="Germany">Germany</option>
        <option value="Gibraltar">Gibraltar</option>
        <option value="Georgia">Georgia</option>
        <option value="Greece">Greece</option>
        <option value="Greenland">Greenland</option>
        <option value="Grenada">Grenada</option>
        <option value="Guadeloupe">Guadeloupe</option>
        <option value="Guatemala">Guatemala</option>
        <option value="Guinea-Bissau">Guinea-Bissau</option>
        <option value="Guinea">Guinea</option>
        <option value="Haiti">Haiti</option>
        <option value="Honduras">Honduras</option>
        <option value="Hong Kong">Hong Kong</option>
        <option value="Hungary">Hungary</option>
        <option value="Iceland">Iceland</option>
        <option value="India">India</option>
        <option value="Indonesia">Indonesia</option>
        <option value="Ireland">Ireland</option>
        <option value="Israel">Israel</option>
        <option value="Italy">Italy</option>
        <option value="Jamaica">Jamaica</option>
        <option value="Japan">Japan</option>
        <option value="Jordan">Jordan</option>
        <option value="Kazakhstan">Kazakhstan</option>
        <option value="Kenya">Kenya</option>
        <option value="Kiribati ">Kiribati </option>
        <option value="Kuwait">Kuwait</option>
        <option value="Kyrgyzstan">Kyrgyzstan</option>
        <option value="Lao People's Democratic Republic">Lao People's Democratic 
        Republic</option>
        <option value="Latvia">Latvia</option>
        <option value="Lebanon">Lebanon</option>
        <option value="Liechtenstein">Liechtenstein</option>
        <option value="Lithuania">Lithuania</option>
        <option value="Luxembourg">Luxembourg</option>
        <option value="Macedonia">Macedonia</option>
        <option value="Madagascar">Madagascar</option>
        <option value="Malawi">Malawi</option>
        <option value="Malaysia ">Malaysia </option>
        <option value="Maldives">Maldives</option>
        <option value="Mali">Mali</option>
        <option value="Malta">Malta</option>
        <option value="Marocco">Marocco</option>
        <option value="Marshall Islands">Marshall Islands</option>
        <option value="Mauritania">Mauritania</option>
        <option value="Mauritius">Mauritius</option>
        <option value="Mexico">Mexico</option>
        <option value="Micronesia">Micronesia</option>
        <option value="Moldavia">Moldavia</option>
        <option value="Monaco">Monaco</option>
        <option value="Mongolia">Mongolia</option>
        <option value="Myanmar">Myanmar</option>
        <option value="Nauru">Nauru</option>
        <option value="Nepal">Nepal</option>
        <option value="Netherlands Antilles">Netherlands Antilles</option>
        <option value="Netherlands">Netherlands</option>
        <option value="New Zealand">New Zealand</option>
        <option value="Niue">Niue</option>
        <option value="North Korea">North Korea</option>
        <option value="Norway">Norway</option>
        <option value="Oman">Oman</option>
        <option value="Pakistan">Pakistan</option>
        <option value="Palau">Palau</option>
	</select></p>
      <input name="user_code" type="text" size="10">
      <img src="pngimg.php" align="middle">&nbsp; </p>
    <p align="center"> 
      <input type="submit" name="Submit" value="Update">
    </p>
  </form></td>

First let me say, you need to use PDO or Mysqli and not the old Mysql calls. Second, the example posted is OLD code and shouldnt be used by anyone in real life, but it should get you on your way to understanding what you are doing wrong. The following is OLD Mysql working code that does what you are wanting to do. Ignore the query function, it is custom.

I could just “fix” or re-write your code but I think you will get much more satisfaction learning from a working example of what you want to do. If you are still stuck I will be happy to go into it in more detail with you. (* When I say working, that doesnt mean you can just drop it into YOUR code and it will work.)

[php] $sql = “SELECT student_id, student_username, student_password, student_firstname, student_middlename, student_lastname, student_email, enrollment_date FROM students WHERE student_id = ‘{$_REQUEST[‘student_id’]}’”;

$msg = "Couldn't execute query $sql on line  " . __LINE__ . ".";
query($sql, $msg);

$row = mysql_fetch_array($result);

?>

Edit Student

" method="post"> 1. Edit Password

Password


2. Edit Student Info

First Name

Middle Name

Last Name

Email

[/php]
Sponsor our Newsletter | Privacy Policy | Terms of Service