Wanyika

Hi, Yes i saw that also at 03.00AM but did go to sleep. Todayy I truncate all tables and the strange thing is that when adding a record, it is doing what it needs to do. If i echo the query it gives me: INSERT IGNORE INTO tng_breeders (gedcom,breeder) VALUES ("World","Unknown Breeder") You see there is a table name. Is there a reason why it fails when adding a lot of records? I start putting back data in the tables and see when it starts to fail again.

Thanks for the fast reply. When changing it to your version it is still giving me the same error but with ``after the INTO: Cannot execute query: INSERT IGNORE INTO `` (`gedcom`,`kennel`) VALUES ('World','Avongara') before it was: Cannot execute query: INSERT IGNORE INTO (gedcom,kennel) VALUES ("World","Avongara") Not enough for me to find the problem.

Having a problem with that "insert ignore into". If it is a new record, it works, when it is a excisting record that needs to be updated, it is giving me this error: Cannot execute query: INSERT IGNORE INTO (gedcom,kennel) VALUES ("World","Avongara") What or where is it going wrong? This message is for me not enough to find the problem. $kennels = array(); if( !in_array( $kennel, $kennels ) ) array_push( $kennels, $kennel ); foreach( $kennels as $kennel ) { $query = "INSERT IGNORE INTO $kennels_table (gedcom,kennel) VALUES (\"$tree\",\"$kennel\")"; $result = @mysql_query( $query ) or die ("$admtext[cannotexecutequery]: $query"); } Thanks for helping