[PHP-DB] How to create a new Table in prostgresql from a Webinterface

2004-08-14 Thread Michelle Konzack
Hello, Never I have done this before (no need) but now I need to create a new table with some colums from a Webinterface and do not know how to do that. Please can anyone point me into the right direction ? Thanks, Greetings and nice Weekend Michelle -- Linux-User #280138 with the Linux

[PHP-DB] RE: [PHP] How to create a new Table in prostgresql from a Webinterface

2004-08-14 Thread Watty
What language are you using? Watty -Original Message- From: Michelle Konzack [mailto:[EMAIL PROTECTED] Sent: 14 August 2004 17:39 To: [EMAIL PROTECTED] Subject: [PHP] Re: [PHP-DB] How to create a new Table in prostgresql from a Webinterface Hello Watty, Am 2004-08-14

[PHP-DB] Joinging two different mySQL result?

2004-08-14 Thread Kim Steinhaug
Im wondering how It would be possible to join two different mySQL results into one set? To clear it up a little bit, say we have two different databases which are completely different but they both share fields name and email. I want to select all the emails and names from both databases and show

[PHP-DB] Re: Joinging two different mySQL result?

2004-08-14 Thread Kim Steinhaug
Here are some tables to reflect the accual problem : So if you can select the two records in one query I would be very happy, :D What I want is this : users.id = users_info.cid I would like to select from users, usr (which is the email ) as email, aktiv, newsletter, emailblock,

Re: [PHP-DB] Re: Joinging two different mySQL result?

2004-08-14 Thread Micah Stevens
select users.usr as email, users.aktiv, users.newsletter, users.emailblock, users.htmlmode, users.none_registered, users_info.* from users, users_info WHERE users.id = users_info.cid That would work. There's no obvious way to join in the

Re: [PHP-DB] Joinging two different mySQL result?

2004-08-14 Thread John Holmes
Kim Steinhaug wrote: Im wondering how It would be possible to join two different mySQL results into one set? To clear it up a little bit, say we have two different databases which are completely different but they both share fields name and email. I want to select all the emails and names from

Re: [PHP-DB] Joinging two different mySQL result?

2004-08-14 Thread Kim Steinhaug
* John Holmes wrote : If you're using MySQL 4.0+ you can use UNION: Perfect! Unioin is my friend, our software is installed on several servers but I just checked them and 4/5 had 4 on mySQL, I can live with that. I need to do some smart quering to make them both identical in the resultsset but

[PHP-DB] Re: [PHP] How to create a new Table in prostgresql from a Webinterface

2004-08-14 Thread Michelle Konzack
Am 2004-08-14 17:42:20, schrieb Watty: What language are you using? php4 under Debian GNU/Linux 3.0 wirh postgresql 7.4.2 (Backport) Watty Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886

Re: [PHP-DB] How to create a new Table in prostgresql from a Webinterface

2004-08-14 Thread Robby Russell
On Sat, 2004-08-14 at 08:31, Michelle Konzack wrote: Hello, Never I have done this before (no need) but now I need to create a new table with some colums from a Webinterface and do not know how to do that. Please can anyone point me into the right direction ? Well, CREATE TABLE is

Re: [PHP-DB] How to forward a POSTed form to another server and catch the return for further processing

2004-08-14 Thread Robby Russell
On Sat, 2004-08-14 at 17:41, Yanglong Zhu wrote: How to forward a POSTed form to another server and catch the return for further processing. I think I did this before. But now I have completely forgot how that was done. The posted form data is processed on the other server, the results

Re: [PHP-DB] How to forward a POSTed form to another server and catch the return for further processing

2004-08-14 Thread John Holmes
Yanglong Zhu wrote: How to forward a POSTed form to another server and catch the return for further processing. I think I did this before. But now I have completely forgot how that was done. The posted form data is processed on the other server, the results should be returned or captured by the

[PHP-DB] Re: How to forward a POSTed form to another server and catch the return for further processing

2004-08-14 Thread Manuel Lemos
Hello, On 08/14/2004 09:41 PM, Yanglong Zhu wrote: How to forward a POSTed form to another server and catch the return for further processing. I think I did this before. But now I have completely forgot how that was done. The posted form data is processed on the other server, the results should be