Search found 8 matches

by DanielDaBello
Tue Apr 07, 2009 7:03 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

I'm not too sure either. I though that maybe the html at the end could stop the print fn working, anyway this is the end portion of my code. When I submit the form it just says that my entry has been updated, but doesn't show the query-any ideas? //modify the animal table $fields = array('animalId',...
by DanielDaBello
Tue Apr 07, 2009 6:08 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

Hi
That's exactly what I was trying to do with 'print', but I don't get anything apart from my html. Would the fact that after the query, I run it through an html scrip stop the print fN displaying?
by DanielDaBello
Fri Apr 03, 2009 9:33 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

Hi, I've been trying to get it to work, but it just doesn't update anything.
Can't even get it to print the string. However, I'm trying to debug, by trial and error will keep you posted!!
by DanielDaBello
Thu Apr 02, 2009 12:07 pm
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

I wasn't-I'm very new to php!!
Should it be something like this?
$result = mysql_query($query) or die(mysqli_error($mysqli));
Doesn't seem to work though.
As regard to the aminalId, it probably wont be amendable in the end, but I just wanted to get everything working first.
by DanielDaBello
Thu Apr 02, 2009 9:50 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

okay I've tried that and it doesn't seem to modify anything, probably a lack of understanding on my part1!! this is the code I used:- //modify the animal table $fields = array('animalId', 'animalName', 'animalSpecies', 'animalBreed', 'animalDob', 'animalSex', 'animalSecurity', 'animalComments'); $ch...
by DanielDaBello
Thu Apr 02, 2009 8:57 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

Thanks for the help, I'll give it a try and let you know how I get on.
by DanielDaBello
Thu Apr 02, 2009 7:39 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Re: Newbie needs help on modifying records in a table

Thanks Apollo I get that, but the problem is that the end user is just going to click on a link to modify a record, which is going to show a form with id, first name, surname, dob, sex, location etc, now if they only put 846173 against id & 1-4-1982 against dob, then click submit, all the other ...
by DanielDaBello
Thu Apr 02, 2009 6:54 am
Forum: Databases
Topic: Newbie needs help on modifying records in a table
Replies: 13
Views: 945

Newbie needs help on modifying records in a table

Hi I'm pretty new to PHP. I have some tables that I need to be able to modify, one contains user id, name, dob, etc, another contains location information. To modify a record I'm using a form with all the fields listed and as it stands I can modify all the fields in one record across the tables, but...