I'm trying to upload data (a CSV file) using PHP MyAdmin's "Insert data from a textfile into table" and keep getting this error "#1148 - The used command is not allowed with this MySQL version" I also Tried uploading using the following script but was unsuccessful (this was just a test script).
//connect to the database - either include a connection variable file or type the following
$connect = mysql_connect("sql4.bravehost.com", "myusername", "mypassword") or die ("No Connection Found")
mysql_select_db("1517330965");
$query = "INSERT INTO products VALUES ('00001', 'CBA Logo T-shirt', 'This T-shirt will show off your CBA connection. Ourt t-shirts are high quality annd 100% preshrunk cotton.', '17.95', '2004-08-01'), ('00002', 'CBA Bumper Sticker', 'Let the world know you are a proud supporter of the CBA Web site with this colorful bumper sticker.', '5.95', '2004-08-01')";
$result = mysql_query($query) or die (mysql_error());
echo "Products added successfully!";
?>