RE: INSER INTO not working!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx]
Sent: Jueves, 12 de Mayo de 2005 05:11 a.m.
To: Mihai Frisan
Cc: MIGUEL ANTONIO GUIRAO AGUILAR; PHP
Subject: Re:  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:
> 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('',$revision)";
> >
> >Using that same query in mysql command line works pretty good and the row
is added to the table, but is not working from my PHP page.
> >
> >I echo the $sqlstring variable for troubleshooting and it is correct.
> >
> >I'm using mysql_query($sqlstring, $link);
> >
> >Any ideas??
> >
> >--------------------------
> >MIGUEL GUIRAO AGUILERA
> >
> >
> >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




**********************************************************************

IMPORTANT NOTICE

This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.

This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.

Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.

************************************************************************
<<<<GWAVAsig>>>>
AdmID:04E590DF442906DF47024583032E9F69



**********************************************************************

IMPORTANT NOTICE

This communication is for the exclusive use of the intended recipient(s)
named above. If you receive this communication in error, you should
notify the sender by e-mail or by telephone (+44) 191 224 4461, delete
it and destroy any copies of it.

This communication may contain confidential information and material
protected by copyright, design right or other intellectual property
rights which are and shall remain the property of Piranha Studios
Limited. Any form of distribution, copying or other unauthorised use
of this communication or the information in it is strictly prohibited.
Piranha Studios Limited asserts its rights in this communication and
the information in it and reserves the right to take action against
anyone who misuses it or the information in it.

Piranha Studios Limited cannot accept any liability sustained as a
result of software viruses and would recommend that you carry out your
own virus checks before opening any attachment.

************************************************************************
<<<<GWAVAsig>>>>
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux