cheelee

line 18: if(mysql_num_rows($result) < 1) // it returns a number = true, otherwise is FALSE, i don't think you can use operator here, try below if(!mysql_num_rows($result)) // if not true

it's better not to use variable for $_POST gives a different name: i put "aname" for example line 31 of createalbum.php <input type='text' name='$albumname' value='aname'> line 6 of albumcreated.php $albumnaam=($_POST["aname"]); //this is lin 6 let me know how it works.

i suggest you debug the bad code that you mentioned step by step under MySQL query (if you are using phpadmin) and see if the result is correct each step start from select *, then insert, then insert ignore.... hope this helps!

then you can simply use PHP $_GET or $_POST function, then do a call to the database, then insert those data to the database [url]http://www.w3schools.com/php/php_forms.asp[/url] [url]http://www.w3schools.com/php/php_mysql_insert.asp[/url] w3schools is a very good site with many easy understand examples

to work with mySQL you should learn php also this is the 1st step you should do, writing a php form that will run from client side: [url]http://www.w3schools.com/php/php_forms.asp[/url]

try mysql --tee="filename" found here [url]http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html#option_mysql_tee[/url]

LOAD DATA INFILE "C:/arichivedlog.csv" from above looks like you are importing from your local computer try LOAD DATA LOCAL INFILE "C:/arichivedlog.csv"