RE: [PHP-DB] INSER INTO not working!

2005-05-17 Thread miguel . guirao
:[EMAIL PROTECTED] Sent: Jueves, 12 de Mayo de 2005 05:11 a.m. To: Mihai Frisan Cc: MIGUEL ANTONIO GUIRAO AGUILAR; PHP Subject: Re: [PHP-DB] INSER INTO not working! Please, take into consideration that in Postgresql you have to quote table name if there are capitals in the name. Thus, if the table

RE: [PHP-DB] INSER INTO not working!

2005-05-16 Thread Miguel Guirao
:[EMAIL PROTECTED] Sent: Jueves, 12 de Mayo de 2005 05:11 a.m. To: Mihai Frisan Cc: MIGUEL ANTONIO GUIRAO AGUILAR; PHP Subject: Re: [PHP-DB] INSER INTO not working! Please, take into consideration that in Postgresql you have to quote table name if there are capitals in the name. Thus, if the table

Re: [PHP-DB] INSER INTO not working!

2005-05-12 Thread Constantin Brinzoi
Please, take into consideration that in Postgresql you have to quote table name if there are capitals in the name. Thus, if the table name is REV then you have to quote it like: $sqlstring = "INSERT INTO \"REV\" (revision) VALUES ($revision)"; Aurel On Thu, 2005-05-12 at 11:09 +0300, Mihai Fris

Re: [PHP-DB] INSER INTO not working!

2005-05-12 Thread Mihai Frisan
Hi, try $sqlstring = "INSERT INTO REV (revision) VALUES ($revision)"; Mihai MIGUEL ANTONIO GUIRAO AGUILAR wrote: Hi list, I'm trying to store a data into a two-column table (id, revision). ID is auto_increment. My table is called REV. I'm using this query: $sqlstring = "INSERT INTO REV VALUES('',$r