Re: [PHP-DB] Please point me in the right direction.......

On Wed, 2004-11-10 at 14:12 -0500, Michael Cortes wrote: > I have a question about contracts or agreements. > > I am considering hiring a local company to do some coding for us in LAMP to > augment what we have done already. I have a problem with the standard "we > own the code and copyright"

[PHP-DB] Looking for more optimal way to do multiple similar inserts at once

Hi gang I'm in need of, if at all possible, cutting down the processing time for sending messages to multiple recipients with my insite messenger. The current version runs 1 query to get the names of all recipients, then 1 query per recipient, and then 1 query to deliver a copy to the sender. Th

Re: [PHP-DB] how to find

1. learn the basics of arrays 2. RTFM At 12:27 11-11-2004, peppe wrote: Hi , I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how can I find the first 1 and the last is there a function for it -- PHP Database Mailing List (

Re: [PHP-DB] how to find

I really don't understand why people like you respond on questions do you want to make yourself interesting . I'm new to php and I'm trying to learn something that's why I mail in newsgroup but please please do not insult and do not respond any more if you think people are asking stupid questions

[PHP-DB] how to find

Hi , I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how can I find the first 1 and the last is there a function for it Regards -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

-{ Rene Brehmer }- wrote: Hi gang I'm in need of, if at all possible, cutting down the processing time for sending messages to multiple recipients with my insite messenger. The current version runs 1 query to get the names of all recipients, then 1 query per recipient, and then 1 query to delive

[PHP-DB] Re: how to find

Peppe wrote: I have numbers in my array 0 0 0 1 1 1 1 1 1 1 1 0 0 0 0 or 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 or 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 how can I find the first 1 and the last is there a function for it Regards array_search() returns first '1' array_keys() can return all '1's getting the highest

Re: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

At 13:42 11-11-2004, Sebastian Mendel wrote: // send Messages $sql = ' INSERT INTO `hf_privmessages` (`ownerID`,`fromID`,`toID`,`from_name`,`to_name`,`priority`,`date`,`subject`,`message`,`folder`) SELECT `userID` AS `ownerID`, ' . (int) $userID . 'AS `fromID`,

RE: [PHP-DB] how to find

I think (hope) that Rene was just trying to emphasize that while this is a php mailing list - it is focused on databases. An array full of 0's and 1's - while certainly data - hardly constitutes that. I suggest a 'for' loop using 'count()' of the array, or perhaps 'array_walk()'. Store the keys

RE: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

Please note that his solution uses a subselect - and your version of mysql may not support subselects. Subselects were introduced (I believe) in Mysql 4.1 - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily repre

[PHP-DB] configuration files

I thought it would be a good idea to use parse_ini_file instead of doing require_once("config.ini"). However, what do I do about arrays that i had in my config file, cos parse_ini_file() does not like them. eg: [foods] favFoods = array('this','that','other',) I notice my php.ini file is arranged

RE: [PHP-DB] how to find

Martin, Thanks for your kind words to the new guy. I really don't understand why others don't simply refrain from responding rather than burn bandwidth with their rants of "RTFM" or or "Off Topic - go somewhere else". I really appreciate all the posts folks make as I tend to learn something, e

Re: [PHP-DB] configuration files

Malcolm JC Clark wrote: I thought it would be a good idea to use parse_ini_file instead of doing require_once("config.ini"). However, what do I do about arrays that i had in my config file, cos parse_ini_file() does not like them. eg: [foods] favFoods = array('this','that','other',) I notice my php

[PHP-DB] Persistent Connections to Oracle databases

Hi, I'm new in PHP, but I have already written a lot of pages using Perl. Now I would to rewrite some modules of my web application in PHP but I have a problem with persistent connections to Oracle databases. My understanding of persistent connections was that using the ociplogon function a

RE: [PHP-DB] Re: Looking for more optimal way to do multiple similar inserts at

yeah, I noticed that ... haven't had a chance to check for certain, but I believe the server I have to work with is 3.23 ... and since my space is rented, I don't have alot of say in upgrading ... although it might be possible to get them to do it ... their PHPMyAdmin is really old too ... :-s

RE: [PHP-DB] configuration files

Yeah, maybe i need to reorganise my code a little. Thanks. -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: 11 November 2004 18:20 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] configuration files Malcolm JC Clark wrote: > I thought it would be a g

[PHP-DB] Cannot load module php_mysql.dl!!

I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It

[PHP-DB] Cannot load module php_mysql.dll!!

I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It w

[PHP-DB] query of two tables returns too many rows, many more than the two tables contain

I have two tables I want to get out the rows that are different between them. The results I am getting is almost 50,000 rows, but the two tables, combined, contain only about 600 rows total. Here is the select statement - SELECT dealers.account_no, dealers.DealerName, blackgate_users.User_Name,

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

This is a common join issue. If you don't specify ANYTHING to connect between the two tables, it'll do one row from the first table, then ALL the rows from the second. Row #2 from the first, then ALL the rows from the second. If you had 600 rows in each table, you'd end up with 360,000 rows as a

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

-Original Message- From: Chip Wiegand [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 3:28 PM To: PHP DB Subject: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain I have two tables I want to get out the rows that are different between t

RE: [PHP-DB] query of two tables returns too many rows, many more than the two tables contain

"Gryffyn, Trevor" <[EMAIL PROTECTED]> wrote on 11/11/2004 01:39:37 PM: > This is a common join issue. If you don't specify ANYTHING to connect > between the two tables, it'll do one row from the first table, then ALL > the rows from the second. Row #2 from the first, then ALL the rows from > th