$ingredient=substr($ingredientsHTML,strpos($ingreidentsHTML,'')+4,strpos($ingreidentsHTML,'')-strpos($ingreidentsHTML,'')+4); $ingredientquery="INSERT INTO ingredients (drinkid,ingredient) VALUES ('".$drink['id']."','".$ingredient."');"; //mysql_query($query); echo $ingredientquery; die(); THAT GIVES INSERT INTO ingredients (drinkid,ingredient) VALUES ('5','>