Re: insert into problems.

> <? > > $text = "yadayada"; > > $date= "today..."; > > $connectionstring = odbc_connect("MYSKODB", "Sa", ""); > #> odbc_do($connectionstring, "INSERT INTO lappar (text,datum) VALUES #> ('$text','$date')"); $query = "INSERT INTO lappar (text,datum) VALUES('$text','$date')"; echo $query, "<BR>\n"; odbc_do($connectionstring, $query) or die(odbc_errormsg()); My first guess is that TEXT is a data type, and should be a reserved word, so there shouldn't be a column named TEXT. > > odbc_close($connectionstring); > > ?> > > /martin > > > > > -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm