What am i missing in this MySQL statement?
Moderator: General Moderators
-
vincenzobar
- Forum Commoner
- Posts: 95
- Joined: Wed Nov 02, 2005 9:57 am
-
vincenzobar
- Forum Commoner
- Posts: 95
- Joined: Wed Nov 02, 2005 9:57 am
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')
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')
-
vincenzobar
- Forum Commoner
- Posts: 95
- Joined: Wed Nov 02, 2005 9:57 am
i did..
and i got this
Code: Select all
$db_row = mysql_fetch_row($all_rows);
$move[] = "'', "."'".implode("', '", $db_row)."'";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
-
vincenzobar
- Forum Commoner
- Posts: 95
- Joined: Wed Nov 02, 2005 9:57 am
