Search found 8 matches

by will808
Sun Jan 04, 2009 3:07 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,

That's fixed it - many thanks for your help!
by will808
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...
by will808
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 ...
by will808
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...
by will808
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 ...
by will808
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...
by will808
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.
by will808
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...