Re: [Phpwebsite-developers] weird blocks problem

[spiggy <th...@me...>]

Vlad Sedov wrote:

>Ok, here's a minor problem i had with CVS tarball and blocks -
>
>remember I complained that I could not add blocks (they were somehow
>directed into oblivion)?
>I made the id field in the core_blocks table auto_increment, and voila!
>Blocks started showing up.
>
>the saving query looks like this:
>
>mysql_query("INSERT INTO " . $table_prefix."core_blocks VALUES (NULL,
>$block_order+1, '$block_location', '1',.......... etc etc
>
>from what I could figure out, if you're trying to pass NULL to the primary
>key field that doesn't auto-increment, the query succeeds but doesn't
>actually add anything to the table.
>
>Has anyone else had this problem?...
>

mine increments just fine but there is a missing value in the middle of 
the insert statement, namely 'docking',. i havent figured out the 
meaning of it so if i insert docking as zero (NULL, $block_order+1, 
'$block_location', '0', '1', '$data') the block gets inserted into the 
table.

paivi