Search found 8 matches
- 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',...
- 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?
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?
- 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!!
Can't even get it to print the string. However, I'm trying to debug, by trial and error will keep you posted!!
- 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.
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.
- 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...
- 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.
- 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 ...
- 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...