Problems inserting data in mysql db

[8mycsh]

I have been at it to long....I have no hair left and no patience left. Could someone please take a look and let me know why the info isn't being stored. The date I think is the problem. But I am not sure.

Thanks and I owe you!

<?php

if ($Submit) {
include "data.inc.php";
$CONNECT = mysql_connect($DB_host, $DB_user, $DB_pass) or die(Mysql_error());
mysql_select_db($DB_name);

$notes = stripslashes(htmlspecialchars($notes));
$date = $year . "-" . $month . "-" . $day;

$insert = mysql_query("INSERT INTO $Table_appointments SET date=\"$date\", time=\"$time\", type=\"$type\", notes=\"$notes\"") or die(mysql_error());

mysql_close($CONNECT);
header("location: appointments.php?Sec=schedule");

}

include "header.inc.php";
echo ("&nbsp;&nbsp;&nbsp;<a href=\"index.php\">Home</a> > Add Appointment<br><br>");
?>

<table width="95%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="8" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><img src="images/myappointments.gif" width="200" height="50"><br><br>
<table width="450" border="0" align="center" cellpadding="4" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#6699FF">
<tr>
<td class="Title" style="padding='3'"><div align="center"><strong>Add Appointment</strong></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000">
<tr>
<td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#FFFFCC">
<tr>
<td><form name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td width="100">Type:</td>
<td>
<select name="type" id="type">
<option value="Massage 0.5">Massage 0.5</option>
<option value="Massage 0.45">Massage 0.45</option>
<option value="Massage 1.0">Massage 1.0</option>
<option value="Massage 1.25">Massage 1.25</option>
<option value="Massage 1.5">Massage 1.5</option>
<option value="Massage 2.00">Massage 2.00</option>
</select>
</td>
</tr>
<tr>
<td width="100">Time:</td>
<td><select name="time" id="time">
<option value="09:00">09:00</option>
<option value="09:15">09:15</option>
<option value="09:30">09:30</option>
<option value="09:45">09:45</option>
<option value="10:00">10:00</option>
<option value="10:15">10:15</option>
<option value="10:30">10:30</option>
<option value="10:45">10:45</option>
<option value="11:00">11:00</option>
<option value="11:15">11:15</option>
<option value="11:30">11:30</option>
<option value="11:45">11:45</option>
<option value="12:00">12:00</option>
<option value="12:15">12:15</option>
<option value="12:30">12:30</option>
<option value="12:45">12:45</option>
<option value="13:00">13:00</option>
<option value="13:15">13:15</option>
<option value="13:30">13:30</option>
<option value="13:45">13:45</option>
<option value="14:00">14:00</option>
<option value="14:15">14:15</option>
<option value="14:30">14:30</option>
<option value="14:45">14:45</option>
<option value="15:00">15:00</option>
<option value="15:15">15:15</option>
<option value="15:30">15:30</option>
<option value="15:45">15:45</option>
<option value="16:00">16:00</option>
<option value="16:15">16:15</option>
<option value="16:30">16:30</option>
<option value="16:45">16:45</option>
<option value="17:00">17:00</option>
<option value="17:15">17:15</option>
<option value="17:30">17:30</option>
<option value="17:45">17:45</option>
<option value="18:00">18:00</option>
<option value="18:15">18:15</option>
<option value="18:30">18:30</option>
<option value="18:45">18:45</option>
<option value="19:00">19:00</option>
<option value="19:15">19:15</option>
<option value="19:30">19:30</option>
<option value="19:45">19:45</option>
<option value="20:00">20:00</option>
</select></td>
</tr>
<tr>
<td width="100">Date:</td>
<td><?

$months = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");

echo "<select name=\"month\">";
for($i=0;$i<count($months);$i++) {
echo "<option value=".$months[$i]." ";
if($months[$i] == date("M")) {
echo "selected";
}
echo ">".$months[$i]."</option>";
}

echo "</select>

  <select name=\"day\">"; 

for($i=1;$i<32;$i++) {
echo "<option value=".$i." ";
if($i == date("d")) {
echo "selected";
}
echo ">".$i."</option>";
}

echo "</select>

  <select name=\"year\">"; 

for($i=2000;$i<(date("Y")+5);$i++) {
echo "<option value=".$i." ";
if($i == date("Y")) {
echo "selected";
}
echo ">".$i."</option>";
}
echo "</select>";
?></td>
</tr>
<tr>
<td width="100" valign="top">Notes:</td>
<td><textarea name="notes" cols="32" rows="8" id="notes"></textarea></td>
</tr>
<tr>
<td width="100" valign="top">&nbsp;</td>
<td><input type="submit" name="Submit" value=" Add appointment "></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
</table></td>
</tr>
</table>

<?php

include "footer.inc.php";
?>

[stolzyboy]

are you getting any errors, is anything displayed, are you sure you are getting into the submit if statement, etc...

[8mycsh]

I am not getting any errors, nothing is being displayed and as far as getting to the submit if statement....not sure.

[stolzyboy]

well after this line

if ($Submit) {

put something like

echo "in if statement";

that will tell you if you are even getting in there

[8mycsh]

Ok I think it the way I have the db setup. When I coded it in html and assigned and option value to each month it worked.

<select name="month" id="select" class="select">
<OPTION VALUE=01>January
<OPTION VALUE=02>February
<OPTION VALUE=03>March
<OPTION VALUE=04>April
<OPTION VALUE=05>May
<OPTION VALUE=06>June
<OPTION VALUE=07>July
<OPTION VALUE=08>August
<OPTION VALUE=09>September
<OPTION VALUE=10>October
<OPTION VALUE=11>November
<OPTION VALUE=12>December </select>

But in my php have I assigned a numeric value to the month? I am still new to php and I have gotten alot of help with the php drop down so some of this coding is still over my head.

[darkerstar]

assume your db setup is right, have you checked if your sql statement gone through? use mysql_error(), that will display any mysql problems. Also I suggest you dont use stripslashes on note, as it might contain some " or ' symbles, actaully you should use addslashes on $notes to protect your SQL statement

another hint, debug your sql statement, display what all your sql statement as it is being executed.

[8mycsh]

Ok... I am back at it again.

I have checked everything. The statement goes through but when I check the db it inserts everything but the date, there it inserts as NULL.

I have no mysql errors. So it has something to do with the code I assume now. Can someone take a quick look and see if the code is correct. I realize I am asking alot and also this is a help forum not a "do my project forum" but any help would be great. I have included the mysql_error() now.

PS. THANKS FOR THE TIP!

The default for my db date is 0000-00-00. I am using the date type for that column.

Thanks.

[bodzan]

... I went around it....

My problem was something different I was using the same type (i.e. date) for my date storage column and it wouldn't write in any data at all and not giving me no error also...

Same as yours does I'm afraid...

I went around it because now I use Timestamp type and lenght is 8 if you want to write the same data (YYYYMMDD) as you did and it worked in my case (but I put in current timestamp so I'm not sure whether this helps at all in your case)...

My question is how it is possible that when data type is in question it won't work and it'll not return any error at all...

Not that I helped in any way but...