Re: [tanya-jawab] maap yah tapi pusing nih

2006-10-28 Terurut Topik Mirza Khadnezar

oh iyah
duh maap
hehehe
case closed
On 10/28/06, Gunawan Wibisono [EMAIL PROTECTED] wrote:

baca dulu baik2
CREATE TABLE information (
membuat table 'information'

 FROM TABLE_INFORMATION
harusnya FROM   INFORMATION
lengkapnya
SELECT information_id, info_title, parent_id FROM `INFORMATION`
WHERE visible='1' and languages_id ='1' ORDER BY v_order

- Original Message -
From: Mirza Khadnezar [EMAIL PROTECTED]
To: tanya-jawab@linux.or.id
Sent: Saturday, October 28, 2006 5:32 AM
Subject: [tanya-jawab] maap yah tapi pusing nih


 sorry kali ajah ada yang ngerti

 1146 - Table 'portal_osc1.TABLE_INFORMATION' doesn't exist

 SELECT information_id, info_title, parent_id FROM TABLE_INFORMATION
 WHERE visible='1' and languages_id ='1' ORDER BY v_order

 [TEP STOP]

 itu kenapa yah ?
 padahal udah di add sbb :

 #
 # Table structure `information`
 #

 DROP TABLE IF EXISTS information;
 CREATE TABLE information (
   information_id tinyint(3) unsigned NOT NULL auto_increment,
   visible enum('1','0') NOT NULL default '1',
   v_order tinyint(3) unsigned NOT NULL default '0',
   info_title varchar(255) NOT NULL default '',
   description text NOT NULL,
   languages_id int(11) DEFAULT '0' NOT NULL,
   `parent_id` int(11) default NULL,

   PRIMARY KEY  (information_id,languages_id)
 ) TYPE=MyISAM;

 salah di mana nya yah :(

 ps: to admin :((
 emang sih ini untuk linux tapi kan beberapa temen yg disini sapa tau
 ngerti php juga ya gak ?

 --
 FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
 Unsubscribe: kirim email ke [EMAIL PROTECTED]
 Arsip dan info milis selengkapnya di http://linux.or.id/milis


--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis




--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis



[tanya-jawab] maap yah tapi pusing nih

2006-10-27 Terurut Topik Mirza Khadnezar

sorry kali ajah ada yang ngerti

1146 - Table 'portal_osc1.TABLE_INFORMATION' doesn't exist

SELECT information_id, info_title, parent_id FROM TABLE_INFORMATION
WHERE visible='1' and languages_id ='1' ORDER BY v_order

[TEP STOP]

itu kenapa yah ?
padahal udah di add sbb :

#
# Table structure `information`
#

DROP TABLE IF EXISTS information;
CREATE TABLE information (
 information_id tinyint(3) unsigned NOT NULL auto_increment,
 visible enum('1','0') NOT NULL default '1',
 v_order tinyint(3) unsigned NOT NULL default '0',
 info_title varchar(255) NOT NULL default '',
 description text NOT NULL,
 languages_id int(11) DEFAULT '0' NOT NULL,
 `parent_id` int(11) default NULL,

 PRIMARY KEY  (information_id,languages_id)
) TYPE=MyISAM;

salah di mana nya yah :(

ps: to admin :((
emang sih ini untuk linux tapi kan beberapa temen yg disini sapa tau
ngerti php juga ya gak ?

--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis



Re: [tanya-jawab] maap yah tapi pusing nih

2006-10-27 Terurut Topik I Wayan Yuliarta
Mirza Khadnezar wrote:
 sorry kali ajah ada yang ngerti
 
 1146 - Table 'portal_osc1.TABLE_INFORMATION' doesn't exist
 
 SELECT information_id, info_title, parent_id FROM TABLE_INFORMATION
 WHERE visible='1' and languages_id ='1' ORDER BY v_order
 
 [TEP STOP]
 
 itu kenapa yah ?
 padahal udah di add sbb :
 
 #
 # Table structure `information`
 #
 
 DROP TABLE IF EXISTS information;
 CREATE TABLE information (
  information_id tinyint(3) unsigned NOT NULL auto_increment,
  visible enum('1','0') NOT NULL default '1',
  v_order tinyint(3) unsigned NOT NULL default '0',
  info_title varchar(255) NOT NULL default '',
  description text NOT NULL,
  languages_id int(11) DEFAULT '0' NOT NULL,
  `parent_id` int(11) default NULL,
 
  PRIMARY KEY  (information_id,languages_id)
 ) TYPE=MyISAM;
 
 salah di mana nya yah :(
 
 ps: to admin :((
 emang sih ini untuk linux tapi kan beberapa temen yg disini sapa tau
 ngerti php juga ya gak ?
 

Dari SQL query buat create table nama tabelnya itu INFORMATION.

Koq query select pake nama tabel TABLE_INFORMATION?

Ralatnya :
SELECT information_id, info_title, parent_id FROM INFORMATION
WHERE visible='1' and languages_id ='1' ORDER BY v_order



CMIIW,

IWY


-- 
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis



Re: [tanya-jawab] maap yah tapi pusing nih

2006-10-27 Terurut Topik Gunawan Wibisono
baca dulu baik2
CREATE TABLE information (
membuat table 'information'

 FROM TABLE_INFORMATION
harusnya FROM   INFORMATION
lengkapnya
SELECT information_id, info_title, parent_id FROM `INFORMATION`
WHERE visible='1' and languages_id ='1' ORDER BY v_order

- Original Message - 
From: Mirza Khadnezar [EMAIL PROTECTED]
To: tanya-jawab@linux.or.id
Sent: Saturday, October 28, 2006 5:32 AM
Subject: [tanya-jawab] maap yah tapi pusing nih


 sorry kali ajah ada yang ngerti
 
 1146 - Table 'portal_osc1.TABLE_INFORMATION' doesn't exist
 
 SELECT information_id, info_title, parent_id FROM TABLE_INFORMATION
 WHERE visible='1' and languages_id ='1' ORDER BY v_order
 
 [TEP STOP]
 
 itu kenapa yah ?
 padahal udah di add sbb :
 
 #
 # Table structure `information`
 #
 
 DROP TABLE IF EXISTS information;
 CREATE TABLE information (
   information_id tinyint(3) unsigned NOT NULL auto_increment,
   visible enum('1','0') NOT NULL default '1',
   v_order tinyint(3) unsigned NOT NULL default '0',
   info_title varchar(255) NOT NULL default '',
   description text NOT NULL,
   languages_id int(11) DEFAULT '0' NOT NULL,
   `parent_id` int(11) default NULL,
 
   PRIMARY KEY  (information_id,languages_id)
 ) TYPE=MyISAM;
 
 salah di mana nya yah :(
 
 ps: to admin :((
 emang sih ini untuk linux tapi kan beberapa temen yg disini sapa tau
 ngerti php juga ya gak ?
 
 -- 
 FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
 Unsubscribe: kirim email ke [EMAIL PROTECTED]
 Arsip dan info milis selengkapnya di http://linux.or.id/milis


-- 
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis