jamesxg1 Posted January 22, 2009 Share Posted January 22, 2009 Hiya, Basically i need a PHP page that will update a row on my mysql database, all i need it to do is go into my table *Users* => then use the varible $id to get there username and go into that and change there $groupid to the letter P, but i dont know how :S, please help many many thanks james. Quote Link to comment Share on other sites More sharing options...
DeanWhitehouse Posted January 22, 2009 Share Posted January 22, 2009 Have you heard of Google? Do you even know mysql? Quote Link to comment Share on other sites More sharing options...
Maq Posted January 22, 2009 Share Posted January 22, 2009 UPDATE Users SET groupid = 'P' WHERE userid = '$id'; Quote Link to comment Share on other sites More sharing options...
jamesxg1 Posted January 22, 2009 Author Share Posted January 22, 2009 Thankyou Maq, Your a star *. And in reply to Blade280891 yes thankyou and no not alot isnt that quite apparent !!, I suggest you read better next time mate, But thanks for your concern. James. Quote Link to comment Share on other sites More sharing options...
DeanWhitehouse Posted January 22, 2009 Share Posted January 22, 2009 No, i suggest you read better, i asked if you know mysql, you didn't state that you didn't in your post. Quote Link to comment Share on other sites More sharing options...
Maq Posted January 22, 2009 Share Posted January 22, 2009 I suggest you read better next time mate, But thanks for your concern. All that you stated was that you didn't know how to do it, not the fact that you don't know MySQL. The first logical step for completing this task would be what Blade suggested... Google. Search, "MySQL UPDATE" and you would have had your answer instead of having someone else do it for you. In any case, you're welcome 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.