>>> Database error: Invalid SQL: select id, subid from policy where
>>> id='2' and subid='0'
>>> MySQL Error: 1054 (Unknown column 'id' in 'field list')
>>> Session halted.
>
> the output look like this..
> mysql> desc policy;
> +----------------+--------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------------+--------+------+-----+---------+-------+
> | service_charge | int(2) | | | 0 | |
> +----------------+--------+------+-----+---------+-------+
> 1 row in set (0.01 sec)
The error message is quite self explanatory, there's no id or subid column
in the table you are querying.
---------------------------------------------------------------------
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
