Sorry if this is simple but I can't seem to find out what I'm doing wronge. The first value "id_profiles" is INT and index. So for every new value it should be assigned a number. It works with phpmyadmin, but not when I use the php code.
<?php
$db = mysql_connect("host", "username", "pass");
mysql_select_db("dbname", $db);
$insert = "mysql_query(INSERT INTO profiles (id_profiles, user, profile_name) VALUES('', 'mlsbraves', 'theprofilename'))";
mysql_query($insert, $db) or die("Died inserting login info into db. Error returned if any: ".mysql_error());
?>
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_query(INSERT INTO profiles (id_profiles, user, profile_na