lpxxfaintxx Posted December 22, 2008 Share Posted December 22, 2008 $marital = form($_POST['marital']); $sexpref = form($_POST['sexpref']); $relview = form($_POST['relview']); $polparty = form($_POST['polparty']); $music = form($_POST['music']); $books = form($_POST['books']); $movies = form($_POST['movies']); $shows = form($_POST['shows']); $aboutme = form($_POST['aboutme']); $userid = form($_POST['userid']); $query = "UPDATE users SET marital='$marital',$sexpref='$sexpref',relview='$relview',polparty='$polparty',music='$music',books='$books',movies='$movies',tv='$shows',aboutme='$aboutme' WHERE user_id='$userid'" ; mysql_query($query) or die ("Error in query: $query"); I get an error, but I can't figure out what I did wrong. I looked at working examples, and they are structured the same. Quote Link to comment Share on other sites More sharing options...
rhodesa Posted December 22, 2008 Share Posted December 22, 2008 use this instead: mysql_query($query) or die ("Error in query: ".mysql_error()); it will tell you what is wrong most likely thought it's because $sexpref='$sexpref' should be sexpref='$sexpref' Quote Link to comment Share on other sites More sharing options...
fenway Posted December 22, 2008 Share Posted December 22, 2008 I get an error, but I can't figure out what I did wrong. Neither can we, since we don't see (a) the actual query sent to the server or (b) the actual error message returned from the server (from mysql_error()). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.