Re: [PHP-DB] Inserting databasecontent within the same form

2007-09-27 Thread Ruprecht Helms
Hi Niel, SELECT Kunden.*, City.name, City.vorwahl FROM Kunden LEFT JOIN City USING (zipcode) I'm understanding you this is a way for designing the sql-statement. My customer want that they have inserted the city after typing in the zipcode in the zipfield. The city should be searched in a

Re: [PHP-DB] Data not fetching in the textfield.

2007-09-27 Thread OKi98
Niel Archer napsal(a): Your variable value is not being inserted because you have used single quotes for the echo, not double quotes as the nabble example does. Special characters and variables are only interpreted in double quotes, they are treated literally in single quotes. -- Niel Archer

Re: [PHP-DB] Re: mysql statement [SOLVED]

2007-09-27 Thread Jas
Thanks, most of that I knew but the grouping in your first example is the one that allowed me to only use records matching any field but still limited by the one db field. So thanks again. I was not aware of the parenthesis for grouping objects like a mathematical equation where anything inside

Re: [PHP-DB] Pages not fully loading

2007-09-27 Thread ioannes
I am trying to solve this. My server support made this test script: ?php if (mail([EMAIL PROTECTED],test php mail(),test php mail(),From: Bluehost Test [EMAIL PROTECTED])) { print Working.; } else { print Failed.; } ? I tried this many time and had the following experience (it will be the

[PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread Derek
Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in different databases. So far I have recieved at

Re: [PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread TG
If both the databases are on the same database server, you can use the SQL command USE dbname to switch databases or use the full path like dbone.tablename.columnname and dbtwo.tablename.columnname. Or you can use mysql_select_db() PHP function to switch databases on the same server.

[PHP-DB] Looking for a small open-source PHP-DB app that utilize OOP.

2007-09-27 Thread T K
Hi, For a study purpose, I'm looking for a small open source program that works in PHP-MySQL. In particular, I would like to see some examples with PHP 5 and Object-Oriented Programming (such as class, objects, and so on). I'm looking for a small program, possibly like blog, wiki, forum and so

RE: [PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread Bastien Koert
Realistically, there are three options: 1. run the code twice to connect and pass the data to each server 2. set up a primary server and use a stored procedure to load the other server (providing db supports it) 3. set up replication and make one a master and the other a slave and the the

Re: [PHP-DB] Inserting databasecontent within the same form

2007-09-27 Thread Niel Archer
Hi Ruprecht, SELECT Kunden.*, City.name, City.vorwahl FROM Kunden LEFT JOIN City USING (zipcode) I'm understanding you this is a way for designing the sql-statement. Yes. My customer want that they have inserted the city after typing in the zipcode in the zipfield. The city should be

Re: [PHP-DB] Updating 2 Databases from a single form

2007-09-27 Thread Michael Preslar
On 9/27/07, Derek [EMAIL PROTECTED] wrote: Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in

[PHP-DB] Out of Office Autoreply

2007-09-27 Thread jonathon
I will be out of the office until Monday, October 1st. If you have any immediate issues, please contact your project manager. Thank you! Jonathon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Looking for a small open-source PHP-DB app that utilize OOP.

2007-09-27 Thread Bastien Koert
what about wordpress? you may also want to look at some of the code generators bastien Date: Fri, 28 Sep 2007 10:44:31 +0900 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Looking for a small open-source PHP-DB app that utilize OOP. Hi, For a study purpose, I'm looking

[PHP-DB] newbie help

2007-09-27 Thread nhadie
Hi All, I would like to setup a system something like this customer A /\