Re: [tanya-jawab] maap yah tapi pusing nih
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
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
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
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