<?
$connect = mysql_connect("localhost", "adamf", "adamf123") or
die ("Wrong password, jerk.");

mysql_select_db ("adamf");

$insert="INSERT INTO product (product_id, product_name, product_type, product_brand, product_year)
VALUES (1, 'Cyber', 1, 1, 2001),
(2, 'Motive', 8, 1, 2005),
(3, 'Oracle', 8, 2, 2005)";
$results = mysql_query($insert)
or die(mysql_error());

$type="INSERT INTO producttype (producttype_id, producttype_label)
VALUES (1, 'Heads'),
(2, 'Shafts'),
(3, 'Helmets'),
(4, 'Gloves'),
(5, 'Arm Pads'),
(6, 'Shoulder Pads'),
(7, 'Stringing'),
(8, 'New'),
$results=mysql_query($type)
or die(mysql_error());

echo "Data inserted successfully!";
?>

okay, line 26 is the "echo "Data inserted successfully!"; line, so, my guess is the line above it has the error. However, I don't see what the heck it could be. I'm pretty much copying this out of the wrox book "PHP, Apache, MySQL Web Developement", just with different words and other such things, so it isn't a movie site. I've probably looked at this for 20 minutes, could anybody tell me what's wrong?

[PHP]<?
$connect = mysql_connect("localhost", "adamf", "adamf123") or
die ("Wrong password, jerk.");

mysql_select_db ("adamf");

$insert="INSERT INTO product (product_id, product_name, product_type, product_brand, product_year)
VALUES (1, 'Cyber', 1, 1, 2001),
(2, 'Motive', 8, 1, 2005),
(3, 'Oracle', 8, 2, 2005)";
$results = mysql_query($insert)
or die(mysql_error());

$type="INSERT INTO producttype (producttype_id, producttype_label)
VALUES (1, 'Heads'),
(2, 'Shafts'),
(3, 'Helmets'),
(4, 'Gloves'),
(5, 'Arm Pads'),
(6, 'Shoulder Pads'),
(7, 'Stringing'),
(8, 'New')";
$results=mysql_query($type)
or die(mysql_error());

echo "Data inserted successfully!";
?>[/PHP]

According to your error, in your code you forgot to put "; in the end of $type sentence. Hope it works. If this is not, insert data row by row.

Good answer. I solved my problem too.

I'm sure he heard you. By the way, can I borrow your necronomicon so I can resurrect the dead as well? Come on, this thread is over 5 years old

I'm just new at online foruns.

Probably he will not hear me, but oder IT curious like me will see the answer. I'm not a IT professional. Just learning a little bit.

See you.