Home > Archive > PHP DB > May 2005 > Re: [PHP-DB] INSER INTO not working!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] INSER INTO not working!
|
|
| Constantin Brinzoi 2005-05-13, 4:00 pm |
| 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 Frisan wrote:[color=darkred]
> Hi,
>
> try $sqlstring = "INSERT INTO REV (revision) VALUES ($revision)";
>
> Mihai
>
> MIGUEL ANTONIO GUIRAO AGUILAR wrote:
>
| |
| Miguel Guirao 2005-05-16, 3:55 pm |
| Acctually my problem was in that I was using the name of the table in
uppercase rather than in lowercase. So MySQL was looking for table REV
instead of rev. So for MySQL, REV and rev are very different tables!!
Regards,
Miguel Guirao
-----Original Message-----
From: Constantin Brinzoi [mailto:aurel@irecson.ro]
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 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 Frisan wrote:[color=darkred]
> Hi,
>
> try $sqlstring = "INSERT INTO REV (revision) VALUES ($revision)";
>
> Mihai
>
> MIGUEL ANTONIO GUIRAO AGUILAR wrote:
>
is added to the table, but is not working from my PHP page.[color=darkred]
|
|
|
|
|