thank you.. for your answer... i think i know what wrong it is.. :).
-----Original Message-----
From: "Chris Bolt" <[EMAIL PROTECTED]>
Date: Wed, 25 Jul 2001 22:29:00 -0600
To: <[EMAIL PROTECTED]>
Subject: RE: Invalid SQL..?
Re: >>> Database error: Invalid SQL: select id, subid from policy where
Re: >>> id='2' and subid='0'
Re: >>> MySQL Error: 1054 (Unknown column 'id' in 'field list')
Re: >>> Session halted.
Re: >
Re: > the output look like this..
Re: > mysql> desc policy;
Re: > +----------------+--------+------+-----+---------+-------+
Re: > | Field | Type | Null | Key | Default | Extra |
Re: > +----------------+--------+------+-----+---------+-------+
Re: > | service_charge | int(2) | | | 0 | |
Re: > +----------------+--------+------+-----+---------+-------+
Re: > 1 row in set (0.01 sec)
Re:
Re: The error message is quite self explanatory, there's no id or subid column
Re: in the table you are querying.
Re:
Re:
Re: ---------------------------------------------------------------------
Re: Before posting, please check:
Re: <A HREF="http://www.mysql.com/manual.php"
TARGET="_new"><FONT
COLOR="BLUE">http://www.mysql.com/manual.php</FONT></A>
(the manual)
Re: <A HREF="http://lists.mysql.com/"
TARGET="_new"><FONT
COLOR="BLUE">http://lists.mysql.com/</FONT></A>
(the list archive)
Re:
Re: To request this thread, e-mail <[EMAIL PROTECTED]>
Re: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Re: Trouble unsubscribing? Try: <A
HREF="http://lists.mysql.com/php/unsubscribe.php"
TARGET="_new"><FONT
COLOR="BLUE">http://lists.mysql.com/php/unsubscribe.php</FONT></A>
Re:
Re:
--
Get your free email from www.linuxmail.org
Powered by Outblaze
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
