FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » PHP discussions » MySQL Update (Update Code)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
MySQL Update [message #37877] Thu, 28 June 2007 11:07 Go to next message
alhelalat is currently offline  alhelalat   Romania
Messages: 3
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
hi all
i need the right code to update (status) from active to inactive when the numbers in
(ad_rec) = the numbers in (add_bought)
here is ad image from my database
index.php?t=getfile&id=3399&private=0
thanks you all
  • Attachment: untitled.GIF
    (Size: 11.19KB, Downloaded 1001 times)
Re: MySQL Update [message #37879 is a reply to message #37877] Thu, 28 June 2007 12:29 Go to previous messageGo to next message
1harsh789 is currently offline  1harsh789   
Messages: 4
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Try using this SQL. Please backup your data before using this query.

UPDATE your_table_name
SET `status` = 'inactive'
WHERE ad_rec = add_bought 




Re: MySQL Update [message #37880 is a reply to message #37877] Thu, 28 June 2007 12:59 Go to previous message
alhelalat is currently offline  alhelalat   Romania
Messages: 3
Registered: June 2007
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
thank you so much
but what i need is the php code to insert in my web so to set the status inactive automatically
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: archive file extractor script
Next Topic: error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 19 12:34:06 EDT 2017

Total time taken to generate the page: 0.00631 seconds