select ft02tbl.a0, ft02tbl.a1, ft02tbl.a2, ft02tbl.a3, ft02tbl.a4,
ft02tbl.a5, ft02tbl.a6, ft02tbl.a7, ft02tbl.a8, event.sname, location.sname
from ft02tbl left join (location,region,event) on ( ft02tbl.a2=event.nId and
ft02tbl.a3=location.nId
ft02tbl.a4=region.nId)
mysql_query("CREATE TABLE event (
nId int(11) NOT NULL auto_increment,
sName varchar(255) NOT NULL default '',
PRIMARY KEY (nId)
) TYPE=MyISAM") or die ("Can not select due to ".mysql_error());
$r=array("Music","Cultural","Art","Sports");
for ($i=0;$i<count($r);$i++){
mysql_query("INSERT INTO event (sName) VALUES ('".$r[$i]."') ") or die ("Can
not select due to ".mysql_error());
}
mysql_query("CREATE TABLE ft02tbl (
ft02 int(11) NOT NULL auto_increment,
a0 varchar(255) NOT NULL default '',
a1 varchar(2) NOT NULL default '',
a2 varchar(255) NOT NULL default '',
a3 varchar(255) NOT NULL default '',
a4 varchar(50) NOT NULL default '',
a5 varchar(255) NOT NULL default '',
a6 varchar(255) NOT NULL default '',
a7 varchar(255) NOT NULL default '',
a8 varchar(255) NOT NULL default '',
a9 varchar(255) NOT NULL default '',
a10 varchar(255) NOT NULL default '',
a11 date NOT NULL default '00/00/0000' ,
a12 varchar(255) NOT NULL default '',
a13 varchar(5) NOT NULL default '00:00',
a14date NOT NULL default '00/00/0000' ,
a15 varchar(5) NOT NULL default '00:00',
a16 varchar(2) NOT NULL default 'o',
a17 text,
a18 text,
a19 varchar(255) NOT NULL default '',
a20 varchar(255) NOT NULL default '',
a21 varchar(255) NOT NULL default '',
a22 varchar(255) NOT NULL default '',
a23 varchar(255) NOT NULL default '',
a24 varchar(255) NOT NULL default '',
a25 varchar(5) NOT NULL default '00:00',
a26 varchar(2) NOT NULL default 'Y',
a27 varchar(2) NOT NULL default 'N',
a28 varchar(55) NOT NULL default 'N',
a29 text,
PRIMARY KEY (ft02)
) TYPE=MyISAM") or die("update error due to :" . mysql_error());
following is previous table
mysql_query("CREATE TABLE location (
nId int(11) NOT NULL auto_increment,
sName varchar(255) NOT NULL default '',
nIdParent int(11) NOT NULL default '0',
nOrder int(11) NOT NULL default '999999',
PRIMARY KEY (nId)
) TYPE=MyISAM") or die ("Can not select due to ".mysql_error());
INSERT INTO location VALUES (42, 'Eindhoven', 14, 416)
mysql_query("CREATE TABLE region (
nId int(11) NOT NULL auto_increment,
sName varchar(255) NOT NULL default '',
nOrder int(11) NOT NULL default ' 77799',
PRIMARY KEY (nId)
) TYPE=MyISAM;") or die ("Can not select due to ".mysql_error());
INSERT INTO region VALUES (14, 'eindhoven', 352)
now I want output
location.nId, location.sName , location.nIdParent, location.nOrder
region.sName
location.nIdParent=region.nId
Thanks
Mukesh Kumar
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
