Jump to content


editing Database


2 replies to this topic

#1 rus321

    Young Padawan

  • Members
  • Pip
  • 49 posts

Posted 15 November 2005 - 04:07 AM

hi

ye you see i have to design this thing...

its for a doctor....basicly ive designed it so tht he can log in, post his details nd view all the details he has sudmited nd a small search engine tht searches all of his records...

so anyway i was wonderin after his posted his details say if he wanted 2 edit something he posted a week ago how do u go bout doing tht...

ive tried using my editing system tht i use for my site which edits your profile but ive had no luck so far

#2 Mr. Matt

    Moderator

  • P2L Staff
  • PipPipPipPip
  • 1,945 posts
  • Gender:Not Telling

Posted 15 November 2005 - 06:01 AM

use an update query

UPDATE `table` SET `field` = 'field', `field2` = 'field2' WHERE `user_id` = '$id' (or whatever the condition is);

#3 Squid

    Young Padawan

  • Members
  • Pip
  • 132 posts
  • Location:Netherlands
  • Interests:Webdesign, php coding, visual basic programming

Posted 15 November 2005 - 06:33 AM

For more information, you could browse this site:

http://www.freewebma...ials/phpmysql/7

It helped me a lot for my questions about updating, deleting and displaying MySQL records. Good luck.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users