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