$sql="INSERT into data (owner, name, manufacturer, package, pins, smd, quantity, location, scrap, width, height, depth, weight, datasheet, comment, category, url1, url2, url3, url4, price, public, order_quantity, ordera)
VALUES
('".$owner."','".$name."','".$manufacturer."','".$package."','".$pins."','".$smd."','".$quantity."','".$location."','".$scrap."','".$width."','".$height."','".$depth."','".$weight."','".$datasheet."','".$comment."','".$category."','".$url1."','".$url2."','".$url3."','".$url4."','".$price."','".$public."','".$orderquant."')";

$sql_exec = mysql_query($sql);

    foreach ($project as $p){
        $component_ids = mysql_insert_id();
        $proj_add="INSERT into projects_data (owner_id, project_id, component_id)
        VALUES
        ('".$owner."','".$p."','".$component_ids."')";

        $sql_exec = mysql_query($proj_add);
    }

echo '<br />Component added!';
echo '<br /><a href=".">Home</a>';
echo '<br />';
echo '<a href="component.php?view=';
echo mysql_insert_id();
echo '">View component</a>';