On Thursday, May 23, 2002, at 01:22 PM, Svensson, B.A.T. (HKG) wrote:
> First of all: which error do you get?
>
Don't get any error at all. the next sub (see below) prints out the
correct values fetched from the form.
> If you don't get any error, are you sure that the target row as
> specified in the where clause exists?
>
they exist.....checked that very often...
> Secondly: Have you tried to "print" out the actually query to see what
> it contains?
not sure how to do that...
> Maybe you have some invalid data that is feed to the query. Also a
> sample set of the
> data you are trying to update with as well as the table definition
> could be useful in
> order to track down the fault.
>
table:
CREATE TABLE memberscopy (
id int(6) default NULL,
surname text,
name varchar(50) default NULL,
rank text,
cname text,
caddress text,
ctel text,
cfax text,
cmobile text,
cemail text,
curl text,
btype text,
hq text,
quali text,
experi text,
inhouse text,
resid text,
ptel text,
pfax text,
pmobile text,
pemail text,
birthday text,
marital text,
spouse varchar(150) default NULL,
children_number varchar(150) default NULL,
children_names varchar(150) default NULL,
hobbies text,
membership text,
pcont text,
permtel text,
permfax text,
course int(3) default NULL,
nation varchar(40) default NULL,
lastup year(4) default NULL,
loginid text,
password text,
japan_row set('jjj','rrr') default NULL,
ETPA_membership_paid date default NULL,
ETPA_membership_expires date default NULL,
face blob,
KEY id (id),
FULLTEXT KEY resid (resid)
) TYPE=MyISAM;
sub thx {
print $q->header(), $q->start_html( -Title => "Enter
password", -bgcolor => "#000850", -text => "#FFFFFF" ),
'<div align="center">
<img src="../ETPA/pics/etp-logo_cr-mini.gif" width="118"
height="96">
</div>
<hr>
<h1 align="center"> Thank you for updating your
data!!</h1>
<hr>
you will be forwarded to the <a
href="http://www.etpaj.org";>http://www.etpaj.org</a> in 5 seconds
</body>';
my ( $name, $value );
foreach $name ( $q->param ) {
print" $name ---";
foreach $value ( $q->param( $name ) ) {
print" $value<br>";
}
}
print'<hr></body></html>';
exit;
}
(sub do_data see below)
>
>> -----Original Message-----
>> From: Sven Bentlage [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, May 23, 2002 12:00 PM
>> To: [EMAIL PROTECTED]
>> Subject: update query
>>
>>
>> Hi could somebody please tell me what's wrong with this query?
>> I just can't find the error in it..and it does not update the records
>> at
>> all...
>>
>> update memberscopy
>> set rank='$rank',
>> cname='$cname',
>> caddress='$caddress',
>> ctel='$ctel',
>> cfax='$cfax',
>> cmobile='$cmobile',
>> cemail='$cemail',
>> curl='$curl',
>> btype='$btype',
>> hq='$hq',
>> quali='$quali',
>> experi='$experi',
>> inhouse='$inhouse',
>> resid='$resid',
>> ptel='$ptel',
>> pfax='$pfax',
>> pmobile='$pmobile',
>> pemail='$pemail',
>> marital='$marital',
>> spouse='$spouse',
>> children_number='$children_number',
>> children_names='$children_names',
>> hobbies='$hobbies',
>> membership='$membership',
>> pcont='$pcont',
>> lastup=now()
>> where name = '$name' and surname = '$surname'
>>
>> Thanks for your help in advance,
>>
>> Sven
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <mysql-unsubscribe-
>> [EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
