grudz
04-28-2005, 06:09 PM
Hello,
i have this simple INSERT
$timeprojects = mysql_query("INSERT INTO timecards (client_symbol, project_number, company, project, task, update, time, d, m, y)
VALUES('$symboltime', '$project_numbertime', '$company', '$project', '$task', '$update', '$time', '$day', '$month', '$year')") or die (mysql_error());
print 'Timecard has been added';
and this simple form
<table width="800" height="267" border="0" cellpadding="0" cellspacing="0">
<tr class="form">
<td width="100" height="25">Client Symbol</td>
<td width="178">Project Name </td>
<td>Project Number </td>
<td>Company</td>
</tr>
<tr class="form">
<td height="25"><input name="symboltime" type="text" class="txtbox" id="symboltime" style="width:55px" value="<?php print $_POST['symbolselect']?>"></td>
<td><select name="project" class="txtbox" id="project">
<?php
do {
?>
<option value="<?php echo $row_selectproject['project_name']?>"><?php echo $row_selectproject['project_name']?></option>
<?php
} while ($row_selectproject = mysql_fetch_assoc($selectproject));
$rows = mysql_num_rows($selectproject);
if($rows > 0) {
mysql_data_seek($selectproject, 0);
$row_selectproject = mysql_fetch_assoc($selectproject);
}
?>
</select>
</td>
<td width="231"><select name="project_numbertime" class="txtbox" id="project_numbertime" style="width:55px">
<?php
do {
?>
<option value="<?php echo $row_selectproject['project_number']?>"><?php echo $row_selectproject['project_number']?></option>
<?php
} while ($row_selectproject = mysql_fetch_assoc($selectproject));
$rows = mysql_num_rows($selectproject);
if($rows > 0) {
mysql_data_seek($selectproject, 0);
$row_selectproject = mysql_fetch_assoc($selectproject);
}
?>
</select> <a href="#" onClick="MM_openBrWindow('projects_popup.php','','scrollbars=yes,width=470,height=500')">List of project numbers</a> </td>
<td width="291"><input name="company" type="text" class="txtbox" id="company" value="<?php echo $row_companytime['client']; ?>"></td>
</tr>
<tr class="form">
<td height="25">Task</td>
<td height="25" colspan="3"> </td>
</tr>
<tr class="form">
<td colspan="4"><textarea name="task" wrap="PHYSICAL" class="taskarea" id="task"></textarea></td>
</tr>
<tr class="form">
<td height="25">Update</td>
<td height="25" colspan="3">Y
<input name="update" type="radio" value="y">
N
<input name="update" type="radio" value="n"></td>
</tr>
<tr class="form">
<td height="25">Time</td>
<td height="25" colspan="3">Date</td>
</tr>
<tr class="form">
<td height="25"><select name="time" class="txtbox" id="time" style="width:55px">
<option value="0.00" selected>0.00</option>
<option value="0.25">0.25</option>
<option value="0.50">0.50</option>
<option value="0.75">0.75</option>
<option value="1.00">1.00</option>
<option value="1.25">1.25</option>
<option value="1.50">1.00</option>
<option value="1.75">1.75</option>
<option value="2.00">2.00</option>
<option value="2.25">2.25</option>
<option value="2.50">2.50</option>
<option value="2.75">2.75</option>
<option value="3.00">3.00</option>
<option value="3.25">3.25</option>
<option value="3.50">3.50</option>
<option value="3.75">3.75</option>
<option value="4.00">4.00</option>
<option value="4.25">4.25</option>
<option value="4.50">4.50</option>
<option value="4.75">4.75</option>
<option value="5.00">5.00</option>
<option value="5.25">5.25</option>
<option value="5.50">5.50</option>
<option value="5.75">5.75</option>
<option value="6.00">6.00</option>
<option value="6.25">6.25</option>
<option value="6.50">6.50</option>
<option value="6.75">6.75</option>
<option value="7.00">7.00</option>
</select></td>
<td height="25" colspan="3"><select name="month" class="txtbox" id="month" style="width:85">
<option value="1" selected>January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="day" class="txtbox" id="day" style="width:45">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<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>
</select>
<select name="year" class="txtbox" id="year" style="width:65">
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005" selected>2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
</select></td>
</tr>
<tr>
<td height="35" align="left" valign="bottom"><input type="submit" name="Submit" value="Submit" tabindex="9"></td>
<td colspan="3" class="form"> <a href="timecard.php">reload page</a></td>
</tr>
</table>
yet everytime i click submit
I get an error like this
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'update, time, d, m, y) VALUES('10000', '20000', 'test
I'm sure it has to do with the update radio buttons, because if i take it out from the INSERT, everything is ok...but i can't seem to get it!.....
Thank you for any help
i have this simple INSERT
$timeprojects = mysql_query("INSERT INTO timecards (client_symbol, project_number, company, project, task, update, time, d, m, y)
VALUES('$symboltime', '$project_numbertime', '$company', '$project', '$task', '$update', '$time', '$day', '$month', '$year')") or die (mysql_error());
print 'Timecard has been added';
and this simple form
<table width="800" height="267" border="0" cellpadding="0" cellspacing="0">
<tr class="form">
<td width="100" height="25">Client Symbol</td>
<td width="178">Project Name </td>
<td>Project Number </td>
<td>Company</td>
</tr>
<tr class="form">
<td height="25"><input name="symboltime" type="text" class="txtbox" id="symboltime" style="width:55px" value="<?php print $_POST['symbolselect']?>"></td>
<td><select name="project" class="txtbox" id="project">
<?php
do {
?>
<option value="<?php echo $row_selectproject['project_name']?>"><?php echo $row_selectproject['project_name']?></option>
<?php
} while ($row_selectproject = mysql_fetch_assoc($selectproject));
$rows = mysql_num_rows($selectproject);
if($rows > 0) {
mysql_data_seek($selectproject, 0);
$row_selectproject = mysql_fetch_assoc($selectproject);
}
?>
</select>
</td>
<td width="231"><select name="project_numbertime" class="txtbox" id="project_numbertime" style="width:55px">
<?php
do {
?>
<option value="<?php echo $row_selectproject['project_number']?>"><?php echo $row_selectproject['project_number']?></option>
<?php
} while ($row_selectproject = mysql_fetch_assoc($selectproject));
$rows = mysql_num_rows($selectproject);
if($rows > 0) {
mysql_data_seek($selectproject, 0);
$row_selectproject = mysql_fetch_assoc($selectproject);
}
?>
</select> <a href="#" onClick="MM_openBrWindow('projects_popup.php','','scrollbars=yes,width=470,height=500')">List of project numbers</a> </td>
<td width="291"><input name="company" type="text" class="txtbox" id="company" value="<?php echo $row_companytime['client']; ?>"></td>
</tr>
<tr class="form">
<td height="25">Task</td>
<td height="25" colspan="3"> </td>
</tr>
<tr class="form">
<td colspan="4"><textarea name="task" wrap="PHYSICAL" class="taskarea" id="task"></textarea></td>
</tr>
<tr class="form">
<td height="25">Update</td>
<td height="25" colspan="3">Y
<input name="update" type="radio" value="y">
N
<input name="update" type="radio" value="n"></td>
</tr>
<tr class="form">
<td height="25">Time</td>
<td height="25" colspan="3">Date</td>
</tr>
<tr class="form">
<td height="25"><select name="time" class="txtbox" id="time" style="width:55px">
<option value="0.00" selected>0.00</option>
<option value="0.25">0.25</option>
<option value="0.50">0.50</option>
<option value="0.75">0.75</option>
<option value="1.00">1.00</option>
<option value="1.25">1.25</option>
<option value="1.50">1.00</option>
<option value="1.75">1.75</option>
<option value="2.00">2.00</option>
<option value="2.25">2.25</option>
<option value="2.50">2.50</option>
<option value="2.75">2.75</option>
<option value="3.00">3.00</option>
<option value="3.25">3.25</option>
<option value="3.50">3.50</option>
<option value="3.75">3.75</option>
<option value="4.00">4.00</option>
<option value="4.25">4.25</option>
<option value="4.50">4.50</option>
<option value="4.75">4.75</option>
<option value="5.00">5.00</option>
<option value="5.25">5.25</option>
<option value="5.50">5.50</option>
<option value="5.75">5.75</option>
<option value="6.00">6.00</option>
<option value="6.25">6.25</option>
<option value="6.50">6.50</option>
<option value="6.75">6.75</option>
<option value="7.00">7.00</option>
</select></td>
<td height="25" colspan="3"><select name="month" class="txtbox" id="month" style="width:85">
<option value="1" selected>January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="day" class="txtbox" id="day" style="width:45">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<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>
</select>
<select name="year" class="txtbox" id="year" style="width:65">
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005" selected>2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
</select></td>
</tr>
<tr>
<td height="35" align="left" valign="bottom"><input type="submit" name="Submit" value="Submit" tabindex="9"></td>
<td colspan="3" class="form"> <a href="timecard.php">reload page</a></td>
</tr>
</table>
yet everytime i click submit
I get an error like this
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'update, time, d, m, y) VALUES('10000', '20000', 'test
I'm sure it has to do with the update radio buttons, because if i take it out from the INSERT, everything is ok...but i can't seem to get it!.....
Thank you for any help