Page 2 of 2
Posted: Wed Nov 09, 2005 12:10 pm
by vincenzobar
CB_rateplan is 28 columns
archive_rateplan is 29
achive has its own ar_id and then the next column is the CB_rateplan table R_id -28 total rows = 29
is this a problem? i thought Auto increment didn't need a value in an insert statement
Posted: Wed Nov 09, 2005 12:11 pm
by Luke
it needs you to submit this -> '' just a blank value
Posted: Wed Nov 09, 2005 12:24 pm
by vincenzobar
how in the hell do i do that!!!!

Posted: Wed Nov 09, 2005 12:38 pm
by Luke
VALUES ('1', 'Greater Freedom 700 - 2YR', '700', '39.9900', '0.4000', '20.0000', '0.9900', 'up to $.99/min', '24', '$200.00', '', '', '1000', '', '1000', '', '0', '$0.00/min within home calling area ($0.25/min outside home calling area)', '', '', '', '', '53037', 'alltel wireless', 'images/carriers/', 'alltel_logo.gif', 'false', '13283')
OK... in those values, you still need to have a field for the id... just make it blank. If the id is your first column, just make that into this...
VALUES ('', '1', 'Greater Freedom 700 - 2YR', '700', '39.9900', '0.4000', '20.0000', '0.9900', 'up to $.99/min', '24', '$200.00', '', '', '1000', '', '1000', '', '0', '$0.00/min within home calling area ($0.25/min outside home calling area)', '', '', '', '', '53037', 'alltel wireless', 'images/carriers/', 'alltel_logo.gif', 'false', '13283')
Posted: Wed Nov 09, 2005 12:53 pm
by vincenzobar
i did..
Code: Select all
$db_row = mysql_fetch_row($all_rows);
$move[] = "'', "."'".implode("', '", $db_row)."'";
and i got this
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'archive_rateplan VALUES ('', '1', 'Greater Freedom 700 - 2YR', '700', '39.9900'' at line 1
Posted: Wed Nov 09, 2005 12:55 pm
by vincenzobar
nevermind dumb mistake!!!
It worked!!! thanks
i forgot i put acolumn call in and once i deleted that it worked great!!!
Posted: Wed Nov 09, 2005 12:58 pm
by Luke
YAY!!
Posted: Wed Nov 09, 2005 1:05 pm
by conthox
Posted: Wed Nov 09, 2005 1:09 pm
by vincenzobar
laughing my ass off!!!!