Hi Sergio,
That's fixed it - many thanks for your help!
Search found 8 matches
- Sun Jan 04, 2009 3:07 am
- Forum: Databases
- Topic: SOLVED: PHP Script to Update DB Row - Not Working
- Replies: 6
- Views: 603
- Sat Jan 03, 2009 9:18 am
- Forum: Databases
- Topic: SOLVED: PHP Script to Update DB Row - Not Working
- Replies: 6
- Views: 603
Re: PHP Script to Update DB Row - Not Working
OK, I see the problem, thanks. But I use the ID as a link to select the row to edit, so I still need to use the loop to output the data at the top of the script. Is there any simple way to make sure that the right ID is passed to the query? Apologies if I'm missing something obvious - I've never don...
- Sat Jan 03, 2009 4:29 am
- Forum: Databases
- Topic: SOLVED: PHP Script to Update DB Row - Not Working
- Replies: 6
- Views: 603
Re: PHP Script to Update DB Row - Not Working
Hi Sergio, Thanks very much for finding that error - should have seen that :oops: There's another problem now where the last row of the database is being updated rather than the one I want to update - I expect that the unique ID isn't being passed correctly to the query, so this causes the database ...
- Fri Jan 02, 2009 7:10 am
- Forum: Databases
- Topic: SOLVED: PHP Script to Update DB Row - Not Working
- Replies: 6
- Views: 603
SOLVED: PHP Script to Update DB Row - Not Working
Hi, I took the script below from Spoono, and edited it slightly to how I wanted it. The script should do three things: [1] Display a list of rows in the database, with a link on the unique ID. [2] Populate the form fields with the row info when selected. [3] Update the row with the new information f...
- Sat May 03, 2008 3:40 am
- Forum: PHP - Code
- Topic: CSV Import Problem to MySQL
- Replies: 9
- Views: 453
Re: CSV Import Problem to MySQL
OK, seems the problem was quotes in the data, but I can't change that as the CSV is supplied to me. I've found this script which does the job perfectly. The problem is I don't know what I need to do to load this array into the database. I've only shown the function below - connecting to the DB fine ...
- Tue Apr 29, 2008 11:48 am
- Forum: PHP - Code
- Topic: CSV Import Problem to MySQL
- Replies: 9
- Views: 453
Re: CSV Import Problem to MySQL
Hi, Yes, I think you are right - I think the CSV contains the separator where it should not be. The CSV is generated for me, so this is not something I can change. But - because the "load data local infile" method works if I enter it in the console as in my post above, I'm thinking there m...
- Tue Apr 29, 2008 12:52 am
- Forum: PHP - Code
- Topic: CSV Import Problem to MySQL
- Replies: 9
- Views: 453
Re: CSV Import Problem to MySQL
Hi,
No it's something I'll want to do regularly.
No it's something I'll want to do regularly.
- Mon Apr 28, 2008 12:47 pm
- Forum: PHP - Code
- Topic: CSV Import Problem to MySQL
- Replies: 9
- Views: 453
CSV Import Problem to MySQL
Hi, Apologies if this has been posted before - I've searched through the forum and googled, but as I don't exactly know what I'm looking for, the results haven't been great. As you'll gather, I'm totally new to PHP, so please bear with me... I'm trying to import a .csv into MySQL using the PHP scrip...