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: 
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

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: 
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

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

[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