Update Query not Updating

[Anon]

Hi,

I have an UPDATE query to update member information and yet it doesn't update the database. It doesn't give me an error either, just says it was successful.

Please help. Here's the code.

$isql = "UPDATE members
SET memberid='$memberid',
username='$username',
password='$password',
regdate='$regdate',
postnumber='$postnumber',
email='$email',
siteurl='$siteurl',
aimnum='$aimnum',
icqnum='$icqnum',
yahoonum='$yahoonum',
journeyer='$journeyer',
signature='$signature',
showemail='$showemail',
lives='$lives',
historyurl='$historyurl',
gmt='$gmt',
picture='$picture',
acctstatus='$acctstatus',
themeid='$themeid',
birthday='$birthday',
threadposts='$threadposts',
postposts='$postposts',
newsletter='$newsletter',
regip='$regip',
msn='$msn',
ignorelist='$ignorelist',
lastvisit='$lastvisit',
status='$status',
jpic='$jpic',
role='$role',
shortbio='$shortbio',
sex='$sex'
WHERE memberid='$memberid'";
$rinsert = mysql_query ($isql);
if(!$rinsert) {
print ("<b>There was an error. Please report this to the ");
/ line 65 /
print ("<a href=mailto:[e-mail]>Administrator</a>");
echo "<br> Failed update:</b> ", mysql_error();
} else {
echo ("Updated your information successfully. <a href='writerspage.100megsdns.com'>Return</a>");
exit;
}

[amcgrath]

outta curiousity, have you tried echoing the query and running it directly in the database? Most likely you passing wrong info in $memberid.....

[harryj]

That was the problem. I had forgotten to put the memberid info into the form, so it didn't get passed on. How silly of me.
Thanks!