[williamh26]

Hi, guys I am trying to enter a data into a database using this form

PHP Code:

<form name="form1" method="post" action="askhomework.inc.php">
                <ol>

                  
                  
                  <li><label for="subjects">Subject:</label>&nbsp;
                  <?php

                    include("mylibrary/login.php");

                      $query="SELECT sub_name,freetut_id FROM freetutorials";
                      $result = mysql_query ($query);
                       echo "<select name='subject' value=''>Subjects</option>";
                       // printing the list box select command

                      while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
                      echo "<option value=$nt[freetut_id]>$nt[sub_name]</option>";
                       /* Option values are added by looping through the array */
                       }
                      echo "</select>";// Closing of list box
            ?> </li>

                  <li><label for="select">Due-on:</label>&nbsp;
                  
                   <tr>
                         <td><strong>Day</strong><select name="day"> &nbsp;

                          <?php

                                for($i=1; $i<=31; $i++) {
                                    echo "<option>" . $i. "</option>";
                                      }
                          ?> </select></td>&nbsp;
                         <td><strong>Month</strong><select name="month">
                          <?php
                                for($i=1; $i<=12; $i++) {
                                    echo "<option>" . $i. "</option>";
                                      }
                          ?> </select></td>&nbsp;
                         <td><strong>Year</strong><select name="year">
                          <?php
                                for($i=2011; $i<=2020; $i++) {
                                    echo "<option>" . $i. "</option>";
                                      }
                          ?> </select></td>&nbsp;
                         <td><strong>Hour</strong><select>
                          <?php
                                for($i=0; $i<=23; $i++) {
                                    echo "<option>" . sprintf("%02d",$i) . "</option>";
                                      }
                          ?> </select></td>&nbsp;
                         <td><strong>Min</strong><select>
                          <?php
                                for($i=0; $i<=60; $i++) {
                                    echo "<option>" . sprintf("%02d",$i) . "</option>";
                                      }
                          ?> </select></td>
                   </tr>

                  <br>
                  <li><label for="problems">Problem/s</label>&nbsp;&nbsp;&nbsp;
                  <textarea class="video" name="problems" id="problems" cols="45" rows="5"></textarea></li><br>

                  <li><input name="submit" type="submit" class="submit" id="submit" value="Submit"></li>
                </ol>
            </form>

then i have the actually code for enter the data

PHP Code:

<?php

include("mylibrary/login.php");

$year = $_POST['year'];
$month = $_POST['month'];
$day = $_POST['day'];
$problems = $_POST['problems'];
$subject = $_POST['subject'];
$dueon = $_POST['dueon'];

 
if($_POST['submit']){
$validate = checkdate($_POST['month'], $_POST['day'], $_POST['year']);



    $concatdate = $_POST['year']
    ."-". sprintf("%02d", $_POST['day'])
    ."-". sprintf("%02d", $_POST['month'])



// Insert data into mysql
$query = "INSERT INTO homeworkask (dueon, problems, subject) " .
            " VALUES ('$dueon','$problems', '$subject' )";
            
            ."','" .$concatdate

   $result = mysql_query($query) or die('Unable to add product');
   if ($result)
      echo "<h2>Your Homework has been Submitted. Check your email in about 24 hours.</h2>\n";
   else
      echo "<h2>Problem Submitting your Homework.</h2>\n";
      echo"<a href='index.php'>Back to main page</a>";

}

// close connection
mysql_close();
?>

But this is the error I have Parse error: syntax error, unexpected T_VARIABLE in C: on line 143.. Thanks for your Help

[phplabs]

hi,
neither of the two files you included has 143 lines of code, therefore i'm guessing the problem lies elsewhere. please see what file is mentioned where it says the error is on line 143.