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
