Please correct me if I am wrong but it looks like you are asking how to assemble the values in your PHP script into a string that you can insert into your database... if that is the case you need to use the concatenate operator in PHP. You can do this in a few ways... $date = $year . "-" . $month . "-" . $day; insert into s_objetivos_caso values ($dni,$date,$cod_s_objetivos,$conn); or right in the the query itself... insert into s_objetivos_caso values ($dni,$year . "-" . $month . "-" . $day,$cod_s_objetivos,$conn); you would need to check that second way to be sure, but the first one will work for sure. Alan ----- Original Message ----- From: "Mathew Dredge" <mathew@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> To: "Jesus Rios" <galiza-vermelha@xxxxxxxxxx>; "POSTGRESLQ-PHP" <pgsql-php@xxxxxxxxxxxxxx> Sent: Thursday, January 23, 2003 10:05 PM Subject: Re: [PHP] Date type: DATE > Try putting single quotes around the date, this works for me.. > > insert into s_objetivos_caso values ($dni,'$date',$cod_s_objetivos,$conn); > > > ----- Original Message ----- > From: "Jesus Rios" <galiza-vermelha@xxxxxxxxxx> > To: "POSTGRESLQ-PHP" <pgsql-php@xxxxxxxxxxxxxx> > Sent: Thursday, January 23, 2003 5:59 AM > Subject: [PHP] Date type: DATE > > > > > > Hi everybody. > > > > I've got a form where I ask for the date.I store the date in 3 variables: > for > > the day i have $day (dd), for the month i have $month (mm) and for the > year > > $year (yyyy). > > At the same time i have a table which is as it follows: > > Table "s_objetivos_caso" > > Column | Type | Modifiers > > -----------------+---------+----------- > > dni | integer | not null > > fecha | date | not null > > cod_s_objetivos | integer | not null > > > > How do i have to insert the column date?. > > > > $date="$year-$month-$day"; > > insert into s_objetivos_caso values ($dni,$date,$cod_s_objetivos,$conn); > > > > Can anyboy help me for how a i must format the date for introduce into > the > > table??? > > > > > > Thank you. And sorry with my English. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > > message can get through to the mailing list cleanly > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
