Hi; mysql> select * from products; +----+----------+----------+-------+--------+-------------+-------+------------+--------------+------------+-------------+------------------+-------------------+--------------+-----------+---------------+--------+----------+--------------+------+------+-------------+--------------------------+ | ID | SKU | Category | Name | Title | Description | Price | SortFactor | Availability | OutOfStock | ShipFlatFee | ShipPercentPrice | ShipPercentWeight | Associations | TempPrice | LastDatePrice | Weight | Metal | PercentMetal | pic0 | pic1 | sizes | colorsShadesNumbersShort | +----+----------+----------+-------+--------+-------------+-------+------------+--------------+------------+-------------+------------------+-------------------+--------------+-----------+---------------+--------+----------+--------------+------+------+-------------+--------------------------+ | 1 | prodSKU1 | prodCat1 | name1 | title1 | desc | 12.34 | 500 | 1 | 0 | 10.00 | 5 | 2 | | 1 | 2000-01-01 | 2.50 | 14k gold | 20 | NULL | NULL | Extra-small | | +----+----------+----------+-------+--------+-------------+-------+------------+--------------+------------+-------------+------------------+-------------------+--------------+-----------+---------------+--------+----------+--------------+------+------+-------------+--------------------------+ 1 row in set (0.00 sec)
mysql> select last_insert_id() from products; +------------------+ | last_insert_id() | +------------------+ | 0 | +------------------+ 1 row in set (0.00 sec) mysql> Now, I was expecting 1, not 0! What up? TIA, Victor
