> 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

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

Reply via email to