Whats wrong with this PHP code

jayakrishnan · 12-16-2006, 03:36 AM

Quote:

$rS = $db_conn->execute("update member_details set member_details.uno1='$uno1' &member_details.v_rcpt_no='$v_rcpt_no' & member_details.uno2='$uno2' & member_details.vno='$vno' & member_details.rcpt_no='$rcpt_no' & member_details.vdate='$v_date' & member_details.name='$name' & age=$age & member_details.fhname='$fhname' & member_details.edu='$edu' & member_details.address='$address' & member_details.job='$job' & member_details.phone='$phone'& member_details.caste='$caste' & member_details.district='$district' & member_details.taluk='$slave' & member_details.blocks='$blocks' & member_details.anusal='$anusal' where member_details.mem_id='$mem_id';");

I have a php program which is used to update a MS Access database thru DSN-Less

The above code is the one which does the updation, but somehow it doesnt work , nothing happens , but when i change the update code to

Quote:

$rS = $db_conn->execute("update member_details set member_details.anusal='$anusal' where member_details.mem_id='$mem_id';");

it works fine.

All the variables are initialized properly and aren't set to null

Any suggestions , comments?

Thanks

Regards
JayaKrishnan

Nathanael · 12-16-2006, 04:27 AM

i believe you want a comma (,) instead of an ampersand (&) in your sql statement

another way of doing this would be
UPDATE blah SET (field1, field2, field3) VALUES(value1, value2, value3) WHERE 1=1

ps: i hope you do some escaping on those variables

jayakrishnan · 12-16-2006, 05:16 AM

Hey , i got it working , yes it was the comma issue

, thanks for the reply Nathanael

Regards
JayaKrishnan

jayakrishnan · 12-19-2006, 02:47 AM

Can i pass multiple field name in the where clause like this

Quote:

$rS = $db_conn->execute("update member_details set member_details.mem_id='$mem_id',member_details.mem_name='$mem_name' ,member_details.rname='$rname',member_details.relationship='$rel' ,member_details.gender='$gender',member_details.age='$age' ,member_details.education='$edu',member_details.work='$work' where member_details.mem_id='$mem_id',member_details.rname='$rname' , member_details.relationship='$rel' , member_details.gender='$gender' , member_details.age='$age';");

Thanks
Jay

Nathanael · 12-19-2006, 02:52 AM

in the where, order by clauses you will want to use AND or OR

how about taking a stroll through www.w3schools.com
they have a great sql tutorial.

jayakrishnan · 12-19-2006, 03:02 AM

Thanks for the quick reply Nathanael

.