20080728 2021 GMT-6
I have been having a problem inserting data into the db. Well, that isnt true.
I
tested this thoroughly on my own system before uploading it to the server and
then the error occurred right away.
The query:
INSERT INTO
deer_product(deer_type,name,parent_father,parent_mother,parent_father_father,parent_father_mother,parent_mother_father,parent_mother_mother,parent_father_father_father,parent_father_father_mother,parent_father_mother_father,parent_father_mother_mother,parent_mother_father_mother)
VALUES ('doe', 'Jaky', 'Big Jake', 'Dropper Doe', 'MAx', 'Y-35', 'Dropper', 'T
Condict Found''Angus', 'Waldvogel Chief Doe', 'Waldvogel Boomer', 'Tex Doe', 'T
Condict Found')
You'll see the problem is just before 'Angus'; there is no comma there.
I use this little script to handle the data query:
$lastdeerkey = end($deer_key);
foreach($deer_key as $key => $value){
if($value != $lastdeerkey){
$deer_key[$key] = $value.",";
}
}
// put commas between values
foreach($deer_data as $key => $value){
$deer_data[$key] = "'".$value."'";
}
$lastdeervalue = end($deer_data);
foreach($deer_data as $key => $value){
if($value != $lastdeervalue){
$deer_data[$key] = $value.", ";
}
}
I cant see that there is an error but can anyone see something I missed?
Im not sure why id didnt put in a comma on that one item though.
Wade
