Shawn,
Yes, I know that is true.
With a framework that is properly spread out however, often the
inner query does not even know that the outer one is active.
The situation: list a bunch of hits from the database to be
displayed in a table.
1) the query is constructed and handed to the
Don Huff <[EMAIL PROTECTED]> wrote on 03/01/2005 02:33:34 PM:
> Hi,
>
> I am wanting to write a nesting of queries without having to
> retrieve all the records of the first query (because of the volume).
>
>
>
> res1 = query(db, sql1, USE_DATA);
>
Hi,
I am wanting to write a nesting of queries without having to
retrieve all the records of the first query (because of the volume).
res1 = query(db, sql1, USE_DATA);
while (row1 = fetch_row(res1))
{ res2 = query(db, sql2_function_of(row1);
row2 = fetch_row(res2, USE_DATA
Spahni [mailto:[EMAIL PROTECTED]]
Envoye : lundi 8 juillet 2002 10:30
A : Ben Ocean
Cc : [EMAIL PROTECTED]
Objet : Re: Deep Nesting
Ben,
The description of your project is as clear as mud or as clear as
astrology in general, but it seems to me that you could put all data into
one table?
However,
Ben,
The description of your project is as clear as mud or as clear as
astrology in general, but it seems to me that you could put all data into
one table?
However, a bigger number of tables is no problem for MySQL. Using MyIsam
tables each table will be equivalent to 3 files. With ReiserFS you
Beautiful. Thanks!
BenO
At 05:00 PM 7/7/02 -0500, you wrote:
> >The tables will be used to enable users to enter comments concerning what
> >they believe happens at individual conjunctions. For example, in astrology,
> >let's say one enters a comment of what happens when the Moon enters
> >Scorpi
>The tables will be used to enable users to enter comments concerning what
>they believe happens at individual conjunctions. For example, in astrology,
>let's say one enters a comment of what happens when the Moon enters
>Scorpio. These comments can then be called by other users and rated with
Hi;
I'm trying to programmatically create tables which are nested so deeply
that I fear I'll be creating a gargantuan number of them. I'm seeking a
means to limit this, if possible. I'm creating what I call *open source
metaphysics*. Here's the scenario:
The tables will be used to enable users
Hi;
I'm trying to programmatically create tables which are nested so deeply
that I fear I'll be creating a gargantuan number of them. I'm seeking a
means to limit this, if possible. I'm creating what I call *open source
metaphysics*. Here's the scenario:
The tables will be used to enable users
er Garcia
Gerente de Marketing
Preventix S.A.C.
--
http://www.zapantivirus.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 12:45 AM
Subject: Nesting Problem for Multilevel Marketing
I solved the problem. Add a few more columns in the database table, one
column per higher level, and add a few more mysql query coding, tracing who
recruited who. Then everything becomes simple and fast mysql selects, and no
nested queries or subselects are necessary.
to go back to MySQL
$SecondQuery = select * from table where field = $variable
How can I do this without nesting, but assigning a $variable instead to
place in the second query?
What's an alternative solution to this?
Hi Everyone,
I have a few questions based on a scenario that was posed to me, and I have
no idea how to go about it...
For example, a multi-level / multilevel marketing project has the following
Membertable with 2 fields for a generated Account Number the first field
is Member's Unique
At 12:21 PM +1000 5/30/01, Steven Wren wrote:
>Hello
>
>I am trying to display a table depending if the registration date is
>between a certain period. To do this , I want to pull the 'day' field
>from another table and construct one of the comparison dates with this
>value. It is probably best
Hello
I am trying to display a table depending if the registration date is
between a certain period. To do this , I want to pull the 'day' field
from another table and construct one of the comparison dates with this
value. It is probably best explained with a query.
This is what I am trying to
for your help.
John Halladay
-Original Message-
From: Boulat Khakimov [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 2:48 PM
To: [EMAIL PROTECTED]
Subject: Re: Nesting
John Halladay wrote:
>
> I'm getting a warning that says "the supplied argument is not a valid
MyS
uot;,CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
> - ',CMEYR))),' - ')
> FROM
> TABLE;
>
> Is it not possible to nest an "if, then, else" statement?
>
> Thanks.
> John Halladay
>
Yes it is possible, I was nesting if inside another if w/o any problems,
I'm getting a warning that says "the supplied argument is not a valid MySQL
result resource."
Here is the SQL that I'm trying to write in a php document.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Is it not possible to nest
I'm forwarding this to the list, as someone asked me on list today about
this, and I can't find their post to respond to...
> >Speaking as someone new with MySQL. I can see your point Ed about this
> >being a general database question, but were do you draw the line? If
> >the tool you are using
revathi venkatraman ([EMAIL PROTECTED]) writes:
> Sir,
> Is there this concept of nesting tables and
> varrays in mysql?. Iam creating a chemical compounds
> database.
> there are 20 field in this . Amongst them, I have a
> author field where there are multiple authors, a
What do you mean by "nesting tables" and "varrays"? What you have described
is known as relational databases and a good idea would be to buy a good book
on Relational Database Management Systems.
- Original Message -
From: "revathi venkatraman" <[EMAIL
Sir,
Is there this concept of nesting tables and
varrays in mysql?. Iam creating a chemical compounds
database.
there are 20 field in this . Amongst them, I have a
author field where there are multiple authors, amongst
which one is common for all the records. suppose I
query giving the
22 matches
Mail list logo
