I'm uploading around 150 entries each with 18 fields of data to a Database.
The script is all fine, and converted using a program I made with Autoit.
The problem is, once uploaded, the database looks clean but there are only around 120-130 entries, meaning some don't go in there.
I except it to be some fields aren't supporting the value being inserted, for example one field called "Rooms" is an Int, but some fields in the spreadsheet may have "Quad". Although I converted this for all integer fields, some others appear to have a problem with the VarChar(15)'s.
Is there a way to have MySQL queries output a message if they failed so I can figure out lines aren't being accepted?
Here is an example query, although I think showing what each type of field is would be a waste of time if theres a simple "Show Errors" tag you can put in a MySQL query.
The entire page has all 160 of these. I upload it, and if all goes well the page stays blank. Once and awhile I get a syntax error from an entry with a single quote in it thats easily fixed. Some fields have characters, such as [#, ???] and the 1/2 symbol represented as one character. Are these rejected by the VarChar field?
The script is all fine, and converted using a program I made with Autoit.
The problem is, once uploaded, the database looks clean but there are only around 120-130 entries, meaning some don't go in there.
I except it to be some fields aren't supporting the value being inserted, for example one field called "Rooms" is an Int, but some fields in the spreadsheet may have "Quad". Although I converted this for all integer fields, some others appear to have a problem with the VarChar(15)'s.
Is there a way to have MySQL queries output a message if they failed so I can figure out lines aren't being accepted?
Here is an example query, although I think showing what each type of field is would be a waste of time if theres a simple "Show Errors" tag you can put in a MySQL query.
Code:
mysql_query('INSERT INTO list (aval, area, city, rms, bth, type, rent, dep, petdep, sec8, cat, dog, wd, ht, gar, address, street, phone, addinfo, state, image, email, ha) VALUES ("Jun, 25", "Southeast", "Eugene", "1", "1", "Apt", "550", "Yes", "Yes", "Yes", "Yes", "Yes", "Site", "NA", "NA", "630", "E. 25th Pl. 8", "555-5000", "Near xxx Park", "Oregon", "NA", "NA", "NA")');
The entire page has all 160 of these. I upload it, and if all goes well the page stays blank. Once and awhile I get a syntax error from an entry with a single quote in it thats easily fixed. Some fields have characters, such as [#, ???] and the 1/2 symbol represented as one character. Are these rejected by the VarChar field?