PHP assistance.

[Sugartonic]

I have been reading for about three days now on how to use a drop down menu with options to write to my database but still haven't been successful, Basically I made a drop down menu for age. made a option for 16 all the way to 50. If's just its not writing at all. Im still very new to php so mainly all my work is based off tutorials, so heres what i have so far.

this is basically the form that a user can use to update his/her info. just though to post if needed.
[HTML]<form action="update. php" method="post" enctype="multip art/form-data">
<table width="98%" border="0" cellspacing="1" cellpadding="1" >
<tr>
<td class="cell">Na me:</td>
<td class="cell"><i nput name="name" type="text" id="name" maxlength="30" value="<?php echo "$name"; ?>" disabled></td>
</tr>
<tr>
<td class="cell">Ag e:</td>
<td class="cell">
<select name="age">
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
</select>
</td>
</tr>
<tr>
<td class="cell"><b >Avatar</b></td>
<td class="cell">
<?php
if ($avatar == '')
echo "No avatar";
else
echo "<img src=\"$avatar\" border=\"0\">";
?>
</td>
</tr>
<tr>
<td class="cell">UR L</td>
<td class="cell"><i nput type="text" name="avatar_ur l"></td>
</tr>
<tr>
<td class="cell">Up load<br>Max size: 10KB<br>Max Dimensions: 64x64</td>
<td class="cell"><i nput type="file" name="avatar_fi le"></td>
</tr>
<tr>
<td class="cell">Em ail Address:*</td>
<td class="cell"><i nput name="email" type="text" id="email" maxlength="200" value="<?php echo "$email"; ?>" ></td>
</tr>
<tr>
<td class="cell">Cu rrent Password:*</td>
<td class="cell"><i nput name="password" type="password" id="password" maxlength="10"> </td>
</tr>
<tr>
<td class="cell">Ne w Password:</td>
<td class="cell"><i nput name="newpass" type="password" id="newpass" maxlength="10"> </td>
</tr>
<tr>
<td class="cell">&n bsp;</td><input type="hidden" name="name" value="<?php echo "$name"; ?>" >
<td class="cell"><i nput type="submit" name="Submit" value="Update Profile"></td>
</tr>
</table>
</form>[/HTML]

This is the update script..

[PHP]<?php
// For register_global on PHP settings
$member = $_COOKIE['member'];

session_start() ; // you must put this to read session variables
if (empty($member) || !isset($member) ) // fail to read the browser cookie
{
// Try to read session
if (empty($_SESSIO N['member']) || !isset($_SESSIO N['member']))
{
header("Locatio n: log-in.php"); // redirect user to login
exit;
}
else
{
$member = $_SESSION['member'];
}
}
// MySQL Connection Variables
// Fill in your values for the next 4 lines
$hostname='**** ';
$user='****'; //'user name for MySQL database';
$pass='*****'; //'Password for database';
$dbase='*****'; //'database name';

$connection = mysql_connect(" $hostname" , "$user" , "$pass") or die ("Can't connect to MySQL");
$db = mysql_select_db ($dbase , $connection) or die ("Can't select database.");

// User has login but you should check his account validity again
$qChk = "select id from membership where name='$member' and status='Y' ";
$rsChk = mysql_query($qC hk);

if (mysql_num_rows ($rsChk) != '1')
{
session_destroy ();
// make the cookie expires instantly.
setcookie ("member",$memb er,time()-1957240,"/");
header("Locatio n: log-in.php");
exit;
}


// Start of Update Code


// For register_global on PHP settings
$name = mysql_escape_st ring($_POST['name']);
$age = mysql_escape_st ring($_POST['age']);
$email = mysql_escape_st ring($_POST['email']);
$password = mysql_escape_st ring($_POST['password']);
$newpass = mysql_escape_st ring($_POST['newpass']);
$avatarf = ($_FILES['avatar_file']['name'] == '') ? $_POST['avatar_url'] : $_FILES['avatar_file'];



// Check that all required fields are not empty

if (empty($name) || empty($email) || empty($password ))
{
die ("Error. Please fill in all required fields.");
}

// Check Email Format
if (!(ereg ("^.+@.+\\..+$" , $email)) )
{
die ("Error. $email does not look like a valid email address.");
}

// Next Verify the current password
$qChk = "select * from membership where name='$name' and password='$pass word' ";
$rsChk = mysql_query($qC hk);

if (mysql_num_rows ($rsChk) !='1')
{
die ("Your current password is incorrect. Please try again.");
}

// Update Database
$qUpdate = "update membership set email='$email' ";

if(is_array($av atarf))
{
$size = 10; // Amount of KB allowed (10 = 10KB)
$maxsize = $size * 1024; // 1024 is 1KB (1024 Bytes)
$extensions = array(
"image/jpg",
"image/pjpeg",
"image/jpeg",
"image/gif",
"image/png"
);

// The above array holds all the Mime-types of images
if($avatarf['size'] > $maxsize) // Above 10KB!
{
die('Your avatar size is more than '.$size.' KB'); // Stop the script
} else if(!in_array($a vatarf['type'], $extensions)) // Not a valid image file!
{
die('The avatar you attempted to uploaded is not a valid jpeg, gif or png file!');
}

// Still one test left, but we'll wait.
if(move_uploade d_file($avatarf['tmp_name'], 'avatars/'.$name)) // If file is uploaded!
{
$sizes = getimagesize('a vatars/'.$name); // Image width(0) & height(1)
if($sizes[0] > 64 || $sizes[1] > 64) // Dimensions over 64x64
{
unlink('avatars/'.$name); // Delete the avatar
die('The avatar dimensions you uploaded were too large. They must be equal to or under 64x64');
}
$qUpdate .= ", 'avatar'='avata rs/$name' ";
} else {
die("Couldn't uploaded the avatar!");
} } else {
$qUpdate .= ", 'avatar'='$avat arf' ";
}

// Check if a new password is entered
if (!empty($newpas s))
{
$qUpdate .= ", 'password'='$ne wpass' ";
}

$qUpdate .= " where name='$name' ";

$rsUpdate = mysql_query($qU pdate);

$sqlquery = "INSERT INTO $table
VALUES('$age')" ;


if ($rsUpdate)
{
echo "Thank you. Your profile has been updated.";
}
?>[/PHP]

Thanks for any insight and/or help anyone can provide.

[Banfa]

You problem is here

[php]
$sqlquery = "INSERT INTO $table
VALUES('$age')" ;
[/php]

Right at the bottom of you php. Here is an excert from the MySql manual

If you do not specify a list of column names for INSERT ... VALUES or INSERT ... SELECT, values for every column in the table must be provided by the VALUES list or the SELECT statement. If you do not know the order of the columns in the table, use DESCRIBE tbl_name to find out.

So that statement is not a valid SQL statement. Even if it where a valid SQL statement you never attempt to execute it.

Why don't you update the age in the main UPDATE statement you build up?

If you are worried about the value of $age being wrong then temporarily echo it.

[Sugartonic]

Well, What im trying to say is, I don't know how to set up a statement that works with the drop down menu, and most of the code was from a tutorial.

[Banfa]

Just add it to $qUpdate
[php]
$qUpdate .= ", 'age'='$age' ";
[/php]

before you add the WHERE statement

[Sugartonic]

OH thats it.. Darn i feel kinda stupid and embarassed now..