I have a query regarding mysql and PHP ...
here it is
I know there is a field data exisiting in one of the tables in the present database;
I want to know whether there is any sql or PHP function with which I can find out in
which table the field data is present for example .
I have
* from asset4 where asset_loc='heaven'
union
select * from asset5 where asset_loc='heaven'
bastien
From: Mulley, Nikhil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] I have a query
Date: Wed, 29 Sep 2004 23:19:31 +0530
I have a query regarding mysql and PHP ...
here it is
I know
Just an addendum to Bastien's post:
You'll need MySql 4.0+ if you want to use UNION.
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 2:15 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] I have a query
I have database called asset
in which 5 table are present namely asset1,asset2,asset3,asset4,asset5...
all the tables have the same schema structure and common field names ,equal no of
columns(but not the equal number of rows)
why on earth would you do this?
rather i would create a
