What's wrong with my query? pls help

[Azeem]

Something is going wrong with city, state and zip fields...

 $query = "INSERT into tbl_students (vb_id, username, student_fname, student_lname, student_gender, student_address1, student_address2, student_city, student_state, student_zip, student_email, student_dob, student_home_number, student_cell_number, student_work_number, student_dorm_number, student_organization) VALUES ".
          "('{$bbuserinfo['userid']}','{$bbuserinfo['username']}','{$_POST['student_fname']}','{$_POST['student_lname']}','{$_POST['student_gender']}','{$_POST['student_address1']}',".
          ($_POST['student_address2'] == "" ? "NULL," : "'{$_POST['student_address2']}',") .
          "'{$_POST['student_city']}','{$_POST['student_state']}','{$_POST['student_zip']}','{$bbuserinfo['email']}','{$_POST['student_dob']}','{$_POST['student_home_number']}','{$_POST['student_cell_number']}','{$_POST['student_work_number']}','{$_POST['student_dorm_number']}',".

      ($_POST['student_organization'] == "" ? "NULL," : "'{$_POST['student_organization']}',") ;
     

[planetsim]

and that something is? Looking at your query its a bit hard to tell.

[Azeem]

Its a required field on my form.. I am using the following code to check to make sure that the field is filled:

if (strlen($_POST['student_city']) < 1) {
    $cA['student_city'] = "<b><font color=#FF0000>City</font></b>";
    $ec++;
}

if (strlen($_POST['student_state']) != 2) {
    $cA['student_state'] = "<b><font color=#FF0000>State/Province</font></b>";
    $ec++;
}

if ( !(ereg("^[a-zA-Z0-9]{5,6}$", $_POST['student_zip'])) ) {
    $cA['student_zip'] = "<b><font color=#FF0000>ZIP/Postal Code</font></b>";
    $ec++;
}

this code works fine in other forms.. so I don't think this is the problem...