Posted by Ward B on 08/13/05 01:23

Thanks Dave.

Well, you're right. The column name is "task_icaodesc."

But is the first part of this, icaodesc ='$_POST[task_icaodesc]',
throwing off the system? icaodesc is the NAME in the update form.

<TD><strong>ICAO Description of Task:</strong><BR><textarea
name="$icaodesc" cols="30" rows="5"><? echo "$icaodesc";
?></textarea></TD>

And here is from the PHP script in the "show" page.

$icaodesc =$row['task_icaodesc'];

The show page is where the data is extracted from the db and shown in
the applicable form fields for updating.

Does this help?

In the meantime, I'll try some other combinations.

Thanks.

Ward


On Fri, 12 Aug 2005 18:12:25 +0100, Dave <dave@REMOVEbundook.com>
wrote:

>On Fri, 12 Aug 2005 16:58:48 -0400, Ward B decided we needed to hear:
>
>> Greetings all.
>>
>> I'm getting the following error message...
>>
>> Unknown column 'icaodesc' in 'field list'
>>
>> when I try to update a table from a PHP form.
>>
>> What 'field list' is it referring to? My PHP script or the MySQL
>> table???
>
>The MySQL table - icaodesc is evidently not a column in the table.
>
><snip>

[Back to original message]