|
Posted by Jim Langston on September 1, 2006, 4:30 pm
Please log in for more thread options
> When adding a new record in my forum, if the new thread is the parent
> thread, the Parent_Ancestor takes on the record ID (field called
> Forum). For some reason, new threads are not inheriting the record ID,
> but always receive the number 65535 in its place.
>
> When I try to update a field in a record through PHPMyAdmin, the query
> executes, but the record isn't actually updated. Here's my update
> statement:
>
> UPDATE `Forum` SET `Forum_Ancestor` = '66901' WHERE `Forum` = '66901'
> LIMIT 1 ;
Don't see table name.
>
> I want the Forum_Ancestor to be the same as the record ID. But, when I
> check the record it is still 65535 (which is an erroneous number
> anyway).
>
> Is there any significance to the number 65535? Why won't the record
> update?
>
> Thanks in advance
65535 is a short (2 byte) interger with all the bits set. The largest
unsigned short.
Try something like:
select 'Forum_Ancestor' from mydb.mytable where 'Forum' = '66901';
Do you get anything returned?
| 
XML Sitemap