Re: select max

[villy skov]

Thanks Phillip,

The post_id is bigint(20) unsigned [0]

And yes, i just copy the Quote from the Adminer :-(


But your code:

Quote

INSERT INTO wp_postmeta ( post_id, meta_key, meta_value )
VALUES ( LAST_INSERT_ID(), '_wpsc_price', 122.2 );

also inserts a 0

if i run this:

Quote

INSERT INTO wp_postmeta ( post_id, meta_key, meta_value )
VALUES ( 2915, '_wpsc_price', 122.2 );

it works, so what would you suggest?