Nama table nya bukannya information bukan TABLE_INFORMATION
Querynya :
SELECT information_id, info_title, parent_id information
WHERE visible='1' and languages_id ='1' ORDER BY v_order
On 10/28/06, Mirza Khadnezar <[EMAIL PROTECTED]> 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 :(
>
>
>
--
Kalau Tuhan mau ......Sekarang tidak ada aku, tapi mengapa ada aku ?
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
## Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
