[PHP-DB] Problem on Load Data into Specific Fields of a table?

2002-05-05 Thread Jack
Dear all Two Question : 1. I know that the 'LOAD DATA' command loads a bulk of data into a table, but what happen if i only want to load the data into specifc fields on a table instead of whole table. eg. Let say i had a file with 3 column of data, and i want to load these data into a 'ABC' tabl

Re: [PHP-DB] query error

2002-05-05 Thread Miles Thompson
Echo your INSERT statement, so that you know what it looks like, if you have the values you expect, field names are spelled correctly. that you're not inserting char into int, etc. Use mysql_errno() and mysql_err() (Check those against manual to determine what error you are getting. Use mysql_

Re: [PHP-DB] query error

2002-05-05 Thread Jason Wong
On Sunday 05 May 2002 14:44, erich wrote: > when i perform query an mysql db, to insert a new record, the PHP says: > > Warning: Supplied argument is not a valid MySQL result resource in > g:\wwwroot\phpusermanager-1.0\add_order.php on line 24 > > the snippet is as follows > // connect to the dat