[PHP-DB] I have a query

2004-09-29 Thread Mulley, Nikhil 
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 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)
 
I want to know ,in which table among the above is having a particular field data for 
example ...the column name is asset_loc ( common for all the tables,but no constraints 
,no relation with other tables)
 
I want to know if the asset_loc from any table has the data 'heaven'
 
it should be something like this
select * from asset1,asset2,asset3,asset4,asset5 where asset_loc='heaven';
 
 
 
Thanks, waiting for a quick response from a great list.
 
SELECT * FROM Linux_kids where Dis_Hard_Fans='Nikhil' ;-)

RE: [PHP-DB] I have a query

2004-09-29 Thread Bastien Koert 
if the tables have the same structure, use the union operator to query each 
table separately and return it all in one result set

select * from asset1 where asset_loc='heaven'
union
select * from asset2 where asset_loc='heaven'
union
select * from asset3 where asset_loc='heaven'
union
select * 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 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 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)

I want to know ,in which table among the above is having a particular field 
data for example ...the column name is asset_loc ( common for all the 
tables,but no constraints ,no relation with other tables)

I want to know if the asset_loc from any table has the data 'heaven'
it should be something like this
select * from asset1,asset2,asset3,asset4,asset5 where asset_loc='heaven';

Thanks, waiting for a quick response from a great list.
SELECT * FROM Linux_kids where Dis_Hard_Fans='Nikhil' ;-)

_
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines 
 Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] I have a query

2004-09-29 Thread Hutchins, Richard 
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
 
 
 
 if the tables have the same structure, use the union operator 
 to query each 
 table separately and return it all in one result set
 
 select * from asset1 where asset_loc='heaven'
 union
 select * from asset2 where asset_loc='heaven'
 union
 select * from asset3 where asset_loc='heaven'
 union
 select * 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 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 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)
 
 I want to know ,in which table among the above is having a 
 particular field 
 data for example ...the column name is asset_loc ( common 
 for all the 
 tables,but no constraints ,no relation with other tables)
 
 I want to know if the asset_loc from any table has the data 'heaven'
 
 it should be something like this
 select * from asset1,asset2,asset3,asset4,asset5 where 
 asset_loc='heaven';
 
 
 
 Thanks, waiting for a quick response from a great list.
 
 SELECT * FROM Linux_kids where Dis_Hard_Fans='Nikhil' ;-)
 
 
 
 _
 Take advantage of powerful junk e-mail filters built on 
 patented Microsoft(r) 
 SmartScreen Technology. 
 http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994;
 DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines 
   Start enjoying all the benefits of MSN(r) Premium right now 
 and get the 
 first two months FREE*.
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] I have a query

2004-09-29 Thread Joseph Crawford 
 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 database named site or something and a table
called asset_groups, here i would have
id (int 11 auto_increment primary_key)
title (varchar 50)

this is where i would store Asset1, Asset2 etc...

i would then have a table called assets and have that be sturectured like so
id (int 11 auto_increment primary_key)
asset (int 11) (ID of the asset_group)
whatever else you want for column names.

$result = mysql_query(SELECT id, title FROM asset_groups as ag INNER
JOIN assets a ON ag.id=a.asset WHERE a.asset_loc='heaven');
while($data=mysql_fetch_array($result)) {
// returned a row, display it or whatever
}
$result = null;
$data = null;

this would return a row containing everything you want and would allow
you to loop through the rows so you can display them or whatever


-- 
Joseph Crawford Jr.
Codebowl Solutions
[EMAIL PROTECTED]
802-558-5247

For a GMail account
contact me OFF-LIST

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php