Please help with my code?

[baron_samedi]

Ok new problem 🙁

<?php

$connect=mysql_connect("localhost","root","panda") or die (mysql_error());
mysql_select_db("sucko_shop");

$query="INSERT INTO products VALUES ('00001', 'suck-o t-shirt!', 'a', 'b', 'c', 'd'),
[COLOR="Red"]('00002', 'suck-o mug!', 'z', 'zz','zzz', 'zzzz')";[/COLOR]

$result=mysql_query($query) or die (mysql_error());

?>

The line in red is not working...the values are not being added to the table, whilst the first line is :S

$table2="CREATE TABLE IF NOT EXISTS products (

product_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
product_name VARCHAR (100) NOT NULL DEFAULT '',
product_description TEXT NOT NULL DEFAULT '', 
product_price DECIMAL (7,2) NOT NULL DEFAULT 0.00,
product_quantity SMALLINT UNSIGNED NOT NULL DEFAULT 0,


primary key (product_id)
)";

Thats the table.....

[djjjozsi]

lets print NULL to the product_id 's field.

4 example:

INSERT INTO items VALUES
(NULL, 'Boots', 'Light color boot', 'default_item', 'us_post', 5, '2008-11-09'),
(NULL, 'Boots', 'Light color boot', 'default_item', 'us_post', 5, '2008-11-09')

auto increment means it incremented automaticaly.

if you need the beggining value start with 4 digits number, in the table create pu:

AUTO_INCREMENT=1000 ;

[baron_samedi]

Fixed 😃

Fixed it by using INSERT IGNORE.

Seems that whenever I ran the code for a second time, it would come to the duplicate value and then stop.

[djjjozsi]

nice.