|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
July 3rd, 2006, 11:26 AM
|
|||
|
|||
|
Update Statement Not Working
Hi Coders,
someone help me...i have been running this query without success $query_register_session = "UPDATE members SET mem_sess ='$ayo_sess_id' , memIP ='$user_host' WHERE uname = '$UserName' "; $result_register_session = mysql_query($query_register_session); When i echo the query, i get what looks ok to me as shown below; UPDATE ayo_memberz SET mem_sess ='736eb2d9749650a9fd3fa66b4eb20bb4' , memIP ='192.168.0.1' WHERE uname = 'shalomdan' But when i check the database, the members table is not updating....please someone help. What am i not doing right? Thanks in advance.
|
|
#2
July 3rd, 2006, 11:44 AM
|
|||||
|
|||||
|
RE: Update Statement Not Working
check to see whether the query returns any error.. You can do this by using the mysql_error() function in the following method.
php Code:
check and see what the result is..
|
|
#3
July 3rd, 2006, 12:00 PM
|
|||
|
|||
|
RE: Update Statement Not Working
Thanks a million Nazly.
I had a space in my mysql field names before in the fields memIP and mem_sess...so i got the error column not found. Corrected and working fine. Thanks again. > Thread Solved
|
|
| Viewing: Codewalkers Forums > PHP Related > PHP Installation > Update Statement Not Working |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
