On 5/2/05, Pete <[EMAIL PROTECTED]> wrote:
> In message <[EMAIL PROTECTED]>, Gordon Stewart
> Can't you use a .sql script? It should take seconds...
Ive found the error :- But dont know how to fix it :-
LOG REPORT
==============
<BR>
TEXT -
''100-','WC9173','VOLVO','B58A','','','','','','','B41D','','1983','','10BAYLINE
TAURANGA','','','''
Has connected to database gordon
QUERY1
INSERT INTO `BusNZ` VALUES ('','100','WC9173', 'VOLVO', 'B58A', '',
'', '', '', '', '','B41D', '', '1983', '', '10BAYLINE TAURANGA',
'','', '')
Unable to add to database:<br>
INSERT INTO `BusNZ` VALUES ('','100','WC9173', 'VOLVO', 'B58A', '',
'', '', '', '', '','B41D', '', '1983', '', '10BAYLINE TAURANGA',
'','', '')<hr>
Duplicate entry '127' for key 1
==============
Here is my script :-
===================
$query = "INSERT INTO `BusNZ` VALUES ('','".$fleet."','".$reg."',
'".$ChMan."', '".$ChType."', '".$ChMod."', '".$VIN."', '".$ChNum."',
'".$BodMan."', '".$BodType."', '".$BodNum."','".$seating."',
'".$DISA."', '".$DISNZ."', '".$DOUT."', '".$Operator."',
'".$Status."','".$comments."', '".$classification."')";
echo "QUERY1\n$query\n";
mysql_query( $query) or die( "Unable to add to
database:<br>\n$query<hr>\n" .mysql_error());
===================
There are 19 columns / fields per row... - however Ive been chatting
with someone - Live chat - He cant fix it either
--
G Stewart
NZ: [EMAIL PROTECTED]
NZ Bus Website update form
http://busnz.kwister.com/feedback.php
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
