RE: [PHP-DB] Re: form results to email

2004-07-31 Thread Vincent Jordan
I wrote this, $message is not displaying. What am I doing wrong?? Nevermind. I forgot to add method=post to the html page. I have gotten it to work however I would like to add some formatting to the email. Sent. I currently have: $message = $firstname $lastname .; mail([EMAIL PROTECTED],

Re: [PHP-DB] Re: form results to email

2004-07-31 Thread Jason Wong
On Saturday 31 July 2004 23:25, Vincent Jordan wrote: I have tried to add some html such as strong$firstname $lastname /strong...; however when I do this there is nothing displated in the email message. google html mime message Or look on www.phpclasses.org -- Jason Wong - Gremlins

[PHP-DB] RE: Urgent JOIN help needed

2004-07-31 Thread Jensen, Kimberlee
Why you are getting multiple results is because a JOIN attempts to find all the possible combinations in the output. (It's called a Cartesian product, not that you care at this very moment.) Also, when doing joins, it's a bad idea to do a select * since you will have two fields with the same

[PHP-DB] One or Many Databases?

2004-07-31 Thread Paul Burney
Hello everyone, I'm developing a community system, that has things like members, roles, events, etc. Currently everything is in multiple tables of a single MySQL database. It looks something like this... --- Communities - community_id PK, other_info

Re: [PHP-DB] One or Many Databases?

2004-07-31 Thread John Holmes
Paul Burney wrote: Hello everyone, I'm developing a community system, that has things like members, roles, events, etc. Currently everything is in multiple tables of a single MySQL database. It looks something like this... --- Communities - community_id

Re: [PHP-DB] One or Many Databases?

2004-07-31 Thread Ross Honniball
At 07:41 AM 1/08/2004, you wrote: More server load (??? - Using PEAR, I think each separate database would be a separate connection) No you won't. When you code up your DB Query, you can specify the database that a table comes from by simply using a period as a seperator. eg. select * from