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);
> while (row1 = fetch_row(res1)
Hi
For performance reasons, the best way to deal with
the network is to separate it from your "clients" table
because you would be searching the network heavily
and if the table is short, that would be much faster.
So, create a new table called "network" with only
two integer fields, where you
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
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
John Halladay wrote:
>
> 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))),' - ')
>
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, amongst
> which one i
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 PROTECTED]>
To: <[EMAIL PROTECTED]
