[PHP-DB] INSER INTO not working!

2005-05-12 Thread MIGUEL ANTONIO GUIRAO AGUILAR
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, b

[PHP-DB] database synchronization

2005-05-12 Thread Andri
Title: Message Hello all, anyone can help me?   I have web based application running on php and mysql and installed on multiple sites. The data on those sites need to be syn

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

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] database synchronization

2005-05-12 Thread Bastien Koert
have a look into replication...might be what you realy need http://dev.mysql.com/doc/mysql/en/replication.html bastien From: "Andri" <[EMAIL PROTECTED]> To: "PHP DB List" Subject: [PHP-DB] database synchronization Date: Thu, 12 May 2005 14:09:51 +0700 Hello all, anyone can help me? I have web bas

[PHP-DB] problems with a script

2005-05-12 Thread John R. Sims, Jr.
Hi everyone, I have a question. I have built a script on my desktop that works fine, but when I upload it to the server, it does not post the data to the database. I checked the my server and the isp server. I am running php 5.+ but my isp is only running php 4.3.9 does this mean I have to cha

RE: [PHP-DB] database synchronization

2005-05-12 Thread Murray @ PlanetThoughtful
  I have web based application running on php and mysql and installed on multiple sites. The data on those sites need to be synchronized (to have same data on every site after insert/update/delete action in each site). Currently im using an ftp server to handle synchronization, im using batch scri

Re: [PHP-DB] database synchronization

2005-05-12 Thread M Saleh EG
Are you running your sites on the same server? If yes use only one database for all of them.

RE: [PHP-DB] problems with a script

2005-05-12 Thread Mychael Scribner
I think you do. When I first installed php5, the tried a few apps that were written in php4, and they never worked with 5. -Original Message- From: John R. Sims, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 10:04 AM To: php-db@lists.php.net; php_mysql@yahoogroups.com Subject

RE: [PHP-DB] problems with a script

2005-05-12 Thread Bastien Koert
Not enough info to decide. PHP is supposed to be fairly backward compatible. Are you using the mysqli library to connect? You may have to change to the standard mysql library and functions. Bastien From: "John R. Sims, Jr." <[EMAIL PROTECTED]> To: , Subject: [PHP-DB] problems with a script Date

Re: [PHP-DB] database synchronization. .

2005-05-12 Thread Martin Norland
M Saleh EG wrote: Are you running your sites on the same server? If yes use only one database for all of them. Unless he's installed the latest of either SSvX* or QFCP**, I'm guessing his server isn't installed at multiple sites. * [SSvX] Schrodinger's Server vX ** [QFCP] Quantum Flux Computin

RE: [PHP-DB] problems with a script

2005-05-12 Thread Hutchins, Richard
Rally depends on what you mean by "...does not post the data to the database." Can you confirm that you can connect to the database on your ISP's server? Can you echo out the query string and see output that accurately reflects what you expect to be sent to the server? Does PHP or the databa

Re: [PHP-DB] problems with a script. .

2005-05-12 Thread Martin Norland
Mychael Scribner wrote: I think you do. When I first installed php5, the tried a few apps that were written in php4, and they never worked with 5. -Original Message- From: John R. Sims, Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 10:04 AM To: php-db@lists.php.net; php_mysql@

[PHP-DB] replace question

2005-05-12 Thread Chris Payne
Hi there everyone, I'm pulling some sensitive data from a MySQL DB with PHP and the clients wants the first x amount of numbers displayed on the screen to be xx etc ... rather than the numbers, but wants the last 6 to be displayed, is there an easy way to do this? I understand this isn'

RE: [PHP-DB] problems with a script. .

2005-05-12 Thread John R. Sims, Jr.
Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? Keep the faith John Wireless Neighbor

Re: [PHP-DB] replace question

2005-05-12 Thread Chris
Chris Payne wrote: Hi there everyone, I'm pulling some sensitive data from a MySQL DB with PHP and the clients wants the first x amount of numbers displayed on the screen to be xx etc ... rather than the numbers, but wants the last 6 to be displayed, is there an easy way to do this? I underst