"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
-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
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
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,
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
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
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
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
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
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
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
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
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
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
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`,
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
-{ 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
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
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
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 (
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
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"
22 matches
Mail list logo